Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup Data on a Worksheet
Hello everyone,
I'm asking for help to solve this problem as I'm pretty sure that I'd need to programmatically get this data rather than do it with functions. I might be able to figure something out with functions but it would probably be a lot neater otherwise. What I have is a main page with peoples names in vertical columns with dates across the top to use to match the data with. I also have worksheets with those peoples names on them that store the data in more detail. What I'd like to do is get the value of one cell (the sum total) of the detail numbers. The sum is always in the same place, 8 rows down from a given date. One of the biggest problems is that my detail worksheet does not have contiguous ranges. They go from; F2:L9 , C12:L19 , C22:L29 and finally C32:K39. Those ranges encompass both the date and the sum figure I want, which is row 8 in this range. Would it be possible to figure out a way on the main summary page to look at the persons name, find the worksheet based on that persons name, match the dates and record the sum from the detail page onto the summary page? I sure as heck can't do it! :) Any help would sure be appreciated. Thanks John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup help. lookup result based on data in 2 columns | Excel Worksheet Functions | |||
Import entire row of data to other worksheet based on one lookup v | Excel Discussion (Misc queries) | |||
Lookup on worksheet | Excel Discussion (Misc queries) | |||
lookup stock symbol on worksheet and return summary data | Excel Worksheet Functions | |||
Using Index and Match functions to lookup data in another worksheet | Excel Programming |