Hi, I am trying to prepare a summary sheet from information that is contained across various other tabs on the same cell each time. I have tried using SUMIF but cannot get this to work. The tabs will be the names of 100+ countries and the summary should be able to list these country names and the various bits of data in their respective worksheets.
Initially I want to be able to pull the start and end dates automatically and then other info such as the team names, hours posted etc.
Many thanks.
Last edited by Robwaters1512; 11-08-2011 at 12:27 PM.
C4: =INDIRECT("'" & $B4 & "'!B3")
D4: =INDIRECT("'" & $B4 & "'!B4")
Copy those down...
You'll need to adjust the dates on the other sheets to match the same year.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
That's great, thanks!
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks