Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro Help
I'm using Office 98
I have written a macro to take rows of data and make it columns of data. I am doing this one group at a time. This is the macro I am using. Keyboard Shortcut: Ctrl+q ' Selection.Copy Range("A13500").End(xlUp).Offset(1, 0).Select Selection.PasteSpecial Paste:=xlAll, Operation:=xlNone, SkipBlanks:=False _ , Transpose:=True End Sub My issue is that I have several rows of data, with a blank space inbetween each section; rather than doing it one section at a time, is there a way to edit the macro to read a blank space and make the next section of data occur in a new row. Example: Currently I take Name Address Phone with my macro it does a transpose, to make it look like this Name Address Phone I do this one section at a time. If I have the following: Name1 Address1 Phone 1 <blank line Name 2 Address2 Phone 2 Can I make it look like this Name 1 Address 1 Phone 1 Name 2 Address 2 Phone 2 without having to do each section individually? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving down one row in a macro | New Users to Excel | |||
Zip Code Macro | Excel Worksheet Functions | |||
Macro and If Statement | Excel Discussion (Misc queries) | |||
Macro Formula revision? | Excel Worksheet Functions | |||
Macro for multiple charts | Excel Worksheet Functions |