Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting data
Hi, new here. I'm hoping some of you can help me out on this problem i have. I have one summary worksheet displaying data from 10 other worksheets. The summary will display daily stock movements. The other 10 worksheets containing the individual part's daily movement. The problem i have is: how do I select the data of the day i want from each of the 10 worksheets to be displayed in the summary worksheet? Eg. Today's (3/8/2006) Part A movement is selected and displayed in the summary. Tomorrow, Part A movement is again selected and displayed in the summary. Difference though is that in the individual part worksheet, data from 3/8/2006 and subsequently must be retained. Thanks a whole lot. -- cyc ------------------------------------------------------------------------ cyc's Profile: http://www.excelforum.com/member.php...o&userid=37047 View this thread: http://www.excelforum.com/showthread...hreadid=567760 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting data
Use VLOOKUP formulas to extract the correct information from the various sheets onto the summary
sheet. Key the VLOOKUP to the date. For example, if this table is on sheet1, columns A and B: Date Value 1/8/2006 100 2/8/2006 101 3/8/2006 102 use =VLOOKUP(TODAY(),Sheet1!A:B,2,FALSE) to return 102 and for the other sheets: =VLOOKUP(TODAY(),Sheet2!A:B,2,FALSE) =VLOOKUP(TODAY(),Sheet3!A:B,2,FALSE) =VLOOKUP(TODAY(),Sheet4!A:B,2,FALSE) etc.... HTH, Bernie MS Excel MVP "cyc" wrote in message ... Hi, new here. I'm hoping some of you can help me out on this problem i have. I have one summary worksheet displaying data from 10 other worksheets. The summary will display daily stock movements. The other 10 worksheets containing the individual part's daily movement. The problem i have is: how do I select the data of the day i want from each of the 10 worksheets to be displayed in the summary worksheet? Eg. Today's (3/8/2006) Part A movement is selected and displayed in the summary. Tomorrow, Part A movement is again selected and displayed in the summary. Difference though is that in the individual part worksheet, data from 3/8/2006 and subsequently must be retained. Thanks a whole lot. -- cyc ------------------------------------------------------------------------ cyc's Profile: http://www.excelforum.com/member.php...o&userid=37047 View this thread: http://www.excelforum.com/showthread...hreadid=567760 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trouble with selecting multiple ranges of data | Excel Worksheet Functions | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Help! Selecting data according to date range | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel |