Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidate an XLS sheet
Hi,
I would like to consolidate a new sheet retrieving data from two separate tabs having exactly the same logical organization. Number of rows is known, and varies among the two tabs. Conceptually it is a simple sort of iterative loop, not sure how to implement it though. Thanks, Stefano |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidate an XLS sheet
With the two sheets in one workbook, you can insert a new worksheet
and copy the field which uniquely defines a record to the new sheet from both sheets (one under the other). Then you can obtain a unique list of these using Advanced filter. Then using a VLOOKUP function you can bring data from one sheet, or the other, or both (eg descriptions and other text need only be brought once, but a record may not be present in both sheets, whereas numbers from both sheets may need to be added or subtracted). Sorry the answer is generalised - give further details of your data layout if you require a more specific solution. Hope this helps. Pete On Dec 15, 11:19*pm, smaruzzi wrote: Hi, I would like to consolidate a new sheet retrieving data from two separate tabs having exactly the same logical organization. Number of rows is known, and varies among the two tabs. Conceptually it is a simple sort of iterative loop, not sure how to implement it though. Thanks, Stefano |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidate an XLS sheet
Pete,
I was looking for something which might automate the process something like extracting X rows from one sheet, Y rows from another, and then collate them (X + Y) in a new worksheet. Any idea? Thanks, Stefano "Pete_UK" wrote: With the two sheets in one workbook, you can insert a new worksheet and copy the field which uniquely defines a record to the new sheet from both sheets (one under the other). Then you can obtain a unique list of these using Advanced filter. Then using a VLOOKUP function you can bring data from one sheet, or the other, or both (eg descriptions and other text need only be brought once, but a record may not be present in both sheets, whereas numbers from both sheets may need to be added or subtracted). Sorry the answer is generalised - give further details of your data layout if you require a more specific solution. Hope this helps. Pete On Dec 15, 11:19 pm, smaruzzi wrote: Hi, I would like to consolidate a new sheet retrieving data from two separate tabs having exactly the same logical organization. Number of rows is known, and varies among the two tabs. Conceptually it is a simple sort of iterative loop, not sure how to implement it though. Thanks, Stefano |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidate an XLS sheet
Ron d Bruin has code he
http://www.rondebruin.nl/copy2.htm for merging two or more worksheets. I'm sure you can find a suitable macro there for what you want to do. Hope this helps. Pete On Dec 16, 1:12*am, smaruzzi wrote: Pete, I was looking for something which might automate the process something like extracting X rows from one sheet, Y rows from another, and then collate them (X + Y) in a new worksheet. Any idea? Thanks, Stefano "Pete_UK" wrote: With the two sheets in one workbook, you can insert a new worksheet and copy the field which uniquely defines a record to the new sheet from both sheets (one under the other). Then you can obtain a unique list of these using Advanced filter. Then using a VLOOKUP function you can bring data from one sheet, or the other, or both (eg descriptions and other text need only be brought once, but a record may not be present in both sheets, whereas numbers from both sheets may need to be added or subtracted). Sorry the answer is generalised - give further details of your data layout if you require a more specific solution. Hope this helps. Pete On Dec 15, 11:19 pm, smaruzzi wrote: Hi, I would like to consolidate a new sheet retrieving data from two separate tabs having exactly the same logical organization. Number of rows is known, and varies among the two tabs. Conceptually it is a simple sort of iterative loop, not sure how to implement it though. Thanks, Stefano- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
trying to consolidate info into one sheet | Excel Worksheet Functions | |||
Consolidate data to summary sheet | Excel Discussion (Misc queries) | |||
Consolidate multiple worksheets into new sheet | Excel Worksheet Functions | |||
Can I consolidate one work sheet from several workbooks? A few oth | Excel Discussion (Misc queries) | |||
consolidate values to a checklist on sheet 2 | Excel Discussion (Misc queries) |