Excel Tips - Inserting rows and columns

I use Excel 2007 and I'm using hyperlinks for better viewing when I send this spreadsheet out. My question is:

Are there any tips to getting these applied faster?

I have 403 lines to insert a different hyperlink on and it get's kind of crazy having to go through 3 files to get to the ID's I created for each line... I'm not trying to sound like a whiner, I just wanted to find out if there were any quicker ways around this... Thanks in advance

hi guys,

(Note: excel for Mac, so VBA not really an option)

I have data where the fourth field is in multiple columns, and I need it in multiple rows:

e.g.
masks 1954 producta productb productc
coats 1543 productd
shoes 1234
hats 9876 producta productf productg productz productd

and I need it in the format:
masks 1954 producta
masks 1954 productb
masks 1954 productc
coats 1543 productd
shoes 1234
hats 9876 producta
hats 9876 productf
hats 9876 productg
hats 9876 productz
hats 9876 productd

in other words the fourth field (products) is in multiple columns, and I need the fourth field only transposed to multiple rows, and the other fields repeated.

any help appreciate (and excel for mac is very limited with VBA. prefer formulas if possible, or mac friendly vba if not)

David




Category Blah1 Blah2 Products

I'm afraid that I know the answer to this but I thought I'd ask anyway ...

Is it possible to insert columns for only a certain section of the
spreadsheet, i.e., to affect only a certain range of rows?

Over the years, I've created a spreadsheet with about 300 rows (and with a
6,000-line macro) and now realize that I need about 10 extra columns ... but
only in a certain part of the spreadsheet (rows 100 to 150).

If I insert columns, the ENTIRE spreadsheet (from row 1 to 65536) is going
to be affected (and all of the address references in my macro will have to be
redefined) and then I'll have to cut-and-paste all of the fields from rows 1
to 99 and 151 to 300 back over to their original columns and then all my
row/column references are going to get screwed up and it's going to become a
major hassle.

So, I thought that there might be a trick to inserting columns in specific
rows without affecting any of the other rows. (Wishful thinking, I know.)

Thanks. Dan

Hello Everybody,

I am comparing 2 sets of data's. The number of rows or columns will not be constant every-time when i run this comparison.

I want to know how to insert a row or a column when the data is missing/extra in either of the data. for e.g. if the 3rd column is missing in the 2nd data, i want to insert a new column in the 2nd data.

Thanks in advance,
Prashanth Vakkund

Hi, for some strange reasn, I cannot insert or remove rows and columns in my spreadsheets. This happens in both new or existing worksheets. The options in the menus (title menu as well as when I right click my mouse), stay grey. Can you please assist?

Thanks

Hi all,

I'm trying to figure out the best way how to do the following, either through some formula or macro.

I have four colour options and if there is more than one colour column with a value I need it to create a new row underneath, copy down the price and cells etc (and insert "Variant" into the first column).

The upper records are examples of the way the records are currently set and the lower records are the output I need them to be in



Please see the attached image, I hope that will make more sense. I need to do this for around a thousand records.

Many thanks

Ryan

Hello everybody,

I have some data like below and i have a value...for ex: 28

column1 column2
1 21
2 30
3 15
. .
. .
10 20

i need an additional column based on the value like below

column1 column2 column3
1 1 21
1 2 30
. . .
. . .
1 10 20
2 1 21
2 2 30
. . .
. . .
2 10 20
. . .
. . .
28 1 21
. . .
. . .
28 10 20


Can someone help me ?

Thanks,
Vijay

I have got a protected sheet in which some of the columns and rows are locked. Hence the user will not be able to edit these cells. But they can edit the unlocked cells.

But when i am trying to create a new column next to locked column or new row next to the locked row, the newly created column or row is also getting locked which is not the desired output for me.

If i create a new column, then it should be editable and the fresh format should be used. i mean it should not take the format of the adjacent cell while creating new column or row.

Can any of you help me on this issue.

I have a spread sheet with formulas totalling number across columns and also adding up columns. When I insert a new row the formulas dont update. I have tried tables and I have set the reference to extend formulas and functions. Sometimes the new insert is added at the bottom but not across. Am attaching a sample sheet. If I insert a row at 12 and key a number it calculates sometimes and not others. Help

Hi Everyone!

I have a worksheet which is using the following code:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Application.ScreenUpdating = False
Dim STR As String
STR = Target.Value
If Target.Column = 4 Then
thisrow = Target.Row
Cells(thisrow, 5).Select
If Target.Value "" Then
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="=" & STR
End With
End If
End If
End Sub

Everytime i try to insert/del row/column, excel freezes. I've tried searching onlne and find that many people have faced this problem, however not found a solution yet! please help...