| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup info in support sheets and enter in summary sheet
I have a workbook with a summary sheet and 7 supporting sheets. I need a
macro that will take an account number from the summary sheet, find where it is in one of 6 of the supporting tabs and return the amount corresponding to that account number to my summary sheet and put it in the specified column. Each account will occur only once in the 6 tabs, which means that each account occurs in 1 of the tabs and not in the other 5. Ideas?? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup different sheets and get the value from the sheet specified | Excel Worksheet Functions | |||
| How do I read info from different worksheets into a summary sheet? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Threaded Mode
