| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling data from another worksheet thru a formula
Here's my scenario...
Files A,B,C, etc. have a job name and bid amount in same cell on each file. File X needs to pull the job names and bid amounts if cell B3 from each File is equal to a "T" and add it to a list of job names and bids so I can total the bids. How can I do this?? Thanks in advance. TLee |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pulling data from another worksheet thru a formula
Without using code, the only way I can think to do it would be to
reference each file regardless of T value, then filter for T values or use a SUMIF calculation on the summary sheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I delete data in worksheet, but not the associated formula | Excel Worksheet Functions | |||
| Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
| Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
