| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy rows based on cell content
I have a workbook with about 100 sheets, all formatted the same; different
information, but rows and columns are laid out the same. I would like to copy the information from rows 5 through 13 based on the contents of cell A1. There will be three choices: FWD, RWD, BOF. I would like to paste this information into 3 separate sheets, named as above. The information is updated bi-weekly, so I would like to automate this process. Any suggestions are appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy rows to new sheet based cell reference, not value | Excel Discussion (Misc queries) | |||
| Copy rows from one sheet to another based on a cell value | Excel Worksheet Functions | |||
| Copy rows from one sheet to another based on a cell value | New Users to Excel | |||
| Hide/Delete entire rows based in the content of one cell | Excel Discussion (Misc queries) | |||
| Create a report with selected rows based on the content in a cell | New Users to Excel | |||
Threaded Mode
