Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup Values in different sheets
Hi all, I have a workbook that has a variable amount of worksheets, each
named with a date. These worksheets contain downloads of all all parts delivered by part number, there can be more than one entry. The first sheet is a summary sheet. In this sheet i have the part numbers in column "A" that i need to investigate, I need to scan through sheet 1 for the each of the numbers in column A and add up the parts deliverd and place the total in column "C" next to the relevant part number. I would also like to use the sheet name as the column header. It do this for all the part numbers in the Summary sheet in column "A". Then i would like to go to the next sheet and put the totals in column "D". I have tried to piece together some code but just get horribly lost, any help would be greatly appreciated. Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i wish to lookup values in column A, & add adjacent values in colu | Excel Discussion (Misc queries) | |||
hiding zero values on all sheets & by default on new sheets | Excel Worksheet Functions | |||
Sum values in multiple sheets using Lookup to find a text match | Excel Worksheet Functions | |||
Lookup values in multipul sheets and show value in another sheet | Excel Worksheet Functions | |||
Lookup multiple values on multiple sheets | Excel Programming |