Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking spreadsheet
What I have is a master spreadsheet (wb_master) that has tabs for each day of
the month. The tabs are labeled 10-01 thru 10-31. What I would like to do, is in a seperate spreadsheet (wb_summary), is have one sheet, that will look at the value of cell (q1) on sheet1 in wb_summary, and then look at the wb_master and look for the corrosponding sheet ie 10-01, based on the value of q1 in wb_summary spreadsheet, and copy part of the specified sheet out of wb_master into wb_summary. Is this something that is possible to do? It can be a reference between the two workbooks it dose not have to be a copy. I have been able to make it work within the same workbook by using =INDIRECT ("'"&$Q$1&"'!a"&$A1) in cloumn A I have a helper column with the corresponding row number (saved a bit on typing the formula), but am looking to do this in a second workbook. Any help is greatly apprecated. This is something that I am trying to do for a charity orginization. Thanks, Mark -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200810/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking between sheets on same spreadsheet | Excel Discussion (Misc queries) | |||
Linking to another spreadsheet in a dynamic way | Excel Discussion (Misc queries) | |||
Linking a form to a spreadsheet | Excel Discussion (Misc queries) | |||
Spreadsheet Linking to Calendar | Excel Discussion (Misc queries) | |||
Linking information within a spreadsheet | Excel Discussion (Misc queries) |