Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Realign Columns? Imossible?
I used Ron de Bruins €˜merge cells macro:
http://www.rondebruin.nl/copy2.htm Ive used it multiple times and the macro itself works great €“ everything is copied to one summary sheet, named MergeSheet. Great!!! I have one small problem now (which I never encountered before). If the data in the some of the columns in the different sheets is not in sync, the data in some of the columns of the MergeSheet is not in sync€¦and I cant build a Pivot Table based on this data set. Lets say Firm Name is in Column A; this is consistent for all columns, so were ok here. However, when I move further to the right, Column G of MergeSheet has €˜Contact Person (because this is the way it is on one sheet) and Column G of MergeSheet also has €˜Phone Number (because this is the way it is on another sheet)!!! Is there a way to get Excel to line up all the columns that have the same heading? Im thinking this could be quite easy, quite difficult, or just totally impossible. I cant think of a solution right now. Does anyone have any thoughts on the matter? Regards, Ryan--- -- RyGuy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I realign all data labels in a chart at once | Charts and Charting in Excel | |||
Excel 2002: How to realign data table ? | Excel Discussion (Misc queries) | |||
create a macro to delete columns and then border remaining columns | Excel Programming | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) |