Dynamic sheet access and reuqired sum of all the sheets in summary

H

harinsh

Active Member
Joined
Feb 7, 2012
Messages
273
Hi Team,</SPAN>
I’m looking for below requirement can anyone help me on this…
</SPAN>
I have macro which generates the various sheets (dynamic) it depends on master data volume and sometime 3 sheets or some other times it may go upto 10 sheets… In summary sheet I need to take column K:K total in each sheets (all sheets has similar formats).
</SPAN>
I want macro to get the sheets names correspondence sum total of that particular sheet….I want to leave first four sheets because it has some other data.</SPAN>
Please provide macro code for this…Thank you very much..</SPAN>
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

J
  • Locked
  • Question
Still need help on a daily summary sheet
Replies
1
Views
347
Fluff
Fluff
E
  • Locked
  • Question
VBA Macro to auto insert row into Summary sheet from other sheet as source
Replies
2
Views
466
eddorena
E
C
  • Question
VBA Macros to Copy Specific Cells Values from Multiple Sheets to Specific Cells in Summary Sheets
Replies
2
Views
321
chittunoo
C
R
  • Question
Generate dynamic templates with varying mandatory and non-mandatory fields depending on the product type chosen.
Replies
1
Views
990
RajK2005
R
N
  • Question
Multiple Dynamic row to be filter on criteria to another sheet
Replies
0
Views
820
naren_go
N

Forum statistics

Threads
1,216,084
Messages
6,128,721
Members
449,465
Latest member
TAKLAM

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top