Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking between sheets on same spreadsheet [email protected] Excel Discussion (Misc queries) 1 December 17th 07 10:14 PM
Linking to another spreadsheet in a dynamic way alves Excel Discussion (Misc queries) 1 December 20th 06 03:22 PM
Linking a form to a spreadsheet Matt-Sheff,UK Excel Discussion (Misc queries) 1 November 7th 06 09:52 PM
Spreadsheet Linking to Calendar KK Excel Discussion (Misc queries) 0 September 15th 06 09:13 PM
Linking information within a spreadsheet azvlr Excel Discussion (Misc queries) 4 July 21st 06 04:26 PM


All times are GMT +1. The time now is 03:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"