Is there anyway I can autolink my 31 worksheets to go on one composite worksheet without going through each one and linking them to my composite?
worksheet.png
Is there anyway I can autolink my 31 worksheets to go on one composite worksheet without going through each one and linking them to my composite?
worksheet.png
Last edited by zmurray; 09-01-2015 at 02:29 AM. Reason: attached spreadsheet
are you trying to add all of them together?
ie all cell E6 from sheet 1 to 31
if so you can use 3D reference sum
Formula:Please Login or Register to view this content.
example here
http://www.excel-easy.com/examples/3d-reference.html
Last edited by humdingaling; 09-01-2015 at 02:41 AM.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
No, so when I type in something on E6 on 1 to 31, it will appear on the composite tab worksheet.
Last edited by zmurray; 09-01-2015 at 02:57 AM.
This will give you what you want....
=INDEX(INDIRECT("'"&INT((COLUMN()-5)/12)+1&"'!E6:P20"),MATCH($A3,INDIRECT("'"&INT((COLUMN()-5)/12)+1&"'!A6:A20"),0),MATCH(E$2,INDIRECT("'"&INT((COLUMN()-5)/12)+1&"'!E5:P5"),0))
Copy that down and across
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you soooo much!
you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)
I was searching for the similar thing.. thanks
meus, im happy it helped, thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks