Excel Excel: Merging data from multiple sheets / different columns

[VPCPG]

I have a need to merge data from multiple sheets to create a consolidated list. The content of the data from each of these sheets is in different columns.

Eg.

Sheet A columns A12:A65535, B12:B65535, D1265535, C12:C65535, I12:I65535, L12:L65535

Sheet B columns L3:L65535, J3:J65535, M3:M65535, N3:N65535, O3:O65535, S3:S65535 (this last column needs to be multiple by 1,000

Sheet C columns L2:L65535, B2:B65535, C2:C65535, D265535, E265535, M2:M65535

This needs to work in either Excel 2007

Help appreciated.

 

[Becky]

Hi VPCPG, and welcome to the forums

What are you trying to do exactly? When you say you are trying to create a consolidated list, do you mean you want information from different columns to show in one cell? I could do with knowing what kind of data you are dealing with - numbers, text, etc.

 

[VPCPG]

I think the easiest way to explain it is:

Each sheet contains similar information but in different columns.
I need to append all the rows together onto 1 sheet. this requires me to select specific columns from each of the sheets.

 

[Becky]

Without seeing the spreadsheet it's hard to say - I can't think of any short cuts. If you want a consolidated sheet that links to the data in the other sheets (A, B & C) can you not just link the cells using a simple formula? '=Sheet A!A12' then using the formula handle drag this to the rest of the column. You could do this for all the columns you want to consolidate.

I'm not sure if this is what you're getting at - if I've got the wrong end of the stick let me know!