| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically pulling specific data into a separate spreadsheet
I have a master spreadsheet that has information on 12 different facilities.
I want to set up 12 separate spreadsheets for each individual facility that will automatically pull certain columns of information from the master sheet into the new sheet when a new row for that facility is added. So I am thinking the formula should have something like : IF A4:A200=FacilityA pull info to FacilityA Spreadsheet , IF A4:A200=FacilityB pull info to Facility B Spreadsheet |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling Data that falls within a specific date range? | Excel Worksheet Functions | |||
| Pulling specific data from a sheet | Excel Discussion (Misc queries) | |||
| pulling data automatically from one spreadsheet to another | Excel Worksheet Functions | |||
| pulling data from one file to another automatically | Excel Discussion (Misc queries) | |||
| How do I automatically open a spreadsheet in a specific worksheet? | Excel Discussion (Misc queries) | |||
Linear Mode
