i have a workbook that has worksheets for every business day of the year. i need a formula that i can put on one random worksheet that i can drag down that references the same cell on every worksheet but goes to the next business day worksheet. any thoughts? the way i get every business day is with this formula which may or may not be helpful in the creation of this formula....
Please Login or Register to view this content.
Last edited by rmb623; 03-09-2011 at 02:51 PM.
How are your worksheets named? It should be rather easy to do this knowing that, using INDIRECT.
the worsheets are named by business day......for example 8-2-10,8-3-10, ect.Originally Posted by bentleybob
How about the format in the attached? All you need is a list of dates, and it will pull in the value of a fixed cell (I used C2) from each worksheet with that date.
Perfect. Thank you.
i have exactly the same issue but the names of my sheets are hospital names i.e. Henry Dunant, Red Cross etc.
how could i transform the formula to work for my case too?
Can you upload an example of what you have and [manually] what you're looking for?
Or maybe the attached gives you enough information.
Thank you
This has saved me a lot of time!
On a side note if anyone would like to automatically create a list of sheet names.
This website has the instructions to do so
http://office.microsoft.com/en-gb/excel-help/5-tips-for-working-with-multiple-worksheets-in-excel-HA001042919.aspx
Ollie
bentleybob I know this was from 2011, but THANK YOU THANK YOU!! This saved me TONS of time!! Love this forum!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks