| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing cells and copy rows of data back to summary sheet
I need to know how to write a formula were it searches the numerous sheets
for a specific cell reference and is able to copy all the information in the ROW matching the specific cell requirements on the one sheet. For instance I am searching for "DM" on all the sheets and if it has a cell that has "DM" in it I want to return all the information in that ROW back to the summary sheet. Thank you for your time and assistance. Hope this question makes sence. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
| Summary sheet/ hide rows | Excel Worksheet Functions | |||
| Copy sheet 1 data to sheet 2 cells. | Excel Worksheet Functions | |||
| copy formula referencing sheet name to another sheet | Excel Worksheet Functions | |||
| referencing a sheet named in a cell then using data from that sheet | Excel Worksheet Functions | |||
Threaded Mode
