• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

consolidation macro

M

Manuel998

Member
Hi,

I was wondering if someone could help with a code for a template that i have. I have 95 tabs in the workbook and the desired result is to take ranges (E11:R20,E39:R48 & E66:R80) in e.g. tab Ex1 and copy those ranges in the master spreadsheet in the line below each of the ranges suggested above (see example tab). the only issue i have is some ranges vary in number of rows so it would be great if i could get a solution. Thanks in advance for your help.
 

Attachments

Manuel998
Do eg from 'Ex1' E11:R20 values copy to
'example' E21:R30 or E11:R20?
(later 'Master' would be uses instead 'example')
Would those all other 93 tabs do same (copy to 'Master')?
... if You'll run the code more than once ... the code would it as well - okay?
 
so the ranges should be the same i.e. from Ex1 E11:R20 will be in pasted in Master E11:R20. the example tab is the desired result and yes all other tabs will be feeding into the master tab(not example tab). thanks in advance.
 
Thanks Vletm. that works for now however one small tweak is there any chance to have the cell in column c66:c80 for the non staff section please?
 
Manuel998
Many times there would be some changes ...
... it would be better to write as needs as below
the desired result is to take ranges (E11:R20,E39:R48 & E66:R80)
Many time even 'minor' changes would mean a lot of extra ...
Is that fixed range or not? You ask fixed range and all other ranges are not!
... for testing again ...
 

Attachments

You must log in or register to reply here.
Back
Top