Bouchard17
02-23-2020, 10:53 AM
Hi all,
im new the land of VBA coding and only really learnt the absolute basics so far.
every month i have to analyse data in a worksheet that contains 13 tabs (One for each branch/Office). Each tab has the data laid out in the same way (Same headers) with some cells locked to avoid users overwriting the formula's.
Im looking for a macro to combine all the worksheets into one new worksheet which will make my analysis easier. rather than creating multiple pivots for each branch.
Any Helps is appreciated. :)
Amy
im new the land of VBA coding and only really learnt the absolute basics so far.
every month i have to analyse data in a worksheet that contains 13 tabs (One for each branch/Office). Each tab has the data laid out in the same way (Same headers) with some cells locked to avoid users overwriting the formula's.
Im looking for a macro to combine all the worksheets into one new worksheet which will make my analysis easier. rather than creating multiple pivots for each branch.
Any Helps is appreciated. :)
Amy