| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with a formula pulling data from mutilple sheets
What I am trying to do:
sheet 1, C1 list the name of the business B2 is PAYROLL C2 is PREMIUM D2 is FIXED COST, A3 is THE YEAR 2003-04 A4 is THE YEAR 2004-05 A5 is THE YEAR 2005-06, SHEET 2, WHICH IS YEAR 03-04 B2 is 03 PAYROLL C2 IS THE Premium D2 is the fixed cost A3 is business A A4 is business B A5 is business C A6 is business D, SHEET 3, WHICH IS YEAR 04-05 B2 is 03 PAYROLL C2 IS THE Premium D2 is the fixed cost A3 is business A A4 is business B A5 is business C A6 is business D, What I want to be able to do is on sheet 1 type in a business name, then have the sheet pull information from years 03-04 and 04-05 with that busness name for payroll, premium, and fixed cost for thos particular years. I have not been able to create a formula that will even remotely work... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pulling data from one sheet and listing selected data in another | Excel Worksheet Functions | |||
| Pulling data from another worksheet thru a formula | Excel Discussion (Misc queries) | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| Creating a drop down list that will fill in mutilple cells.... | Excel Discussion (Misc queries) | |||
| pulling info from multiple sheets | Excel Discussion (Misc queries) | |||
Threaded Mode
