Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Row Data From Multiple Sheets To Master
Hi Have been given a problem here at work but have no idea where to begin. I have a master sheet that I need to populate with data from 5 subsidiary sheets. Obviously all six sheets are setup in the same manner. The 5 subsidiary sheets have varying amounts of data contained within them though (some only 10 or so lines whilst others in the hundreds). The problem is I need some way of populating the master sheet when the data from a certain column meets the correct criteria (i.e. contains a "Y"). The master sheet needs to copy from all of the subsidiary sheets all the data in any row where column contains a Y. Is this possible? Could someone push me in the right direction? Cheers Aus ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering of data in a master excel sheet from multiple sheets | Excel Discussion (Misc queries) | |||
copying data from master ti individual sheets | Excel Discussion (Misc queries) | |||
Copying Data from Multiple Sheets to One sheet | Excel Worksheet Functions | |||
copying data in multiple sheets | Excel Worksheet Functions | |||
Multiple text sheets into a master worksheet as you enter data | Excel Worksheet Functions |