Hi Everyone
Wondering if you can help I am trying to create a consolidate button
I have a summary tab called 'Summary' and trying to consolidate number of worksheets in the same file into one
I want it to be able to clear the summary and then copy and paste info from worksheet 1,2,3,4,5,6 etc. into summary from where the first row of info starts from after header which is like on row 8 and then up to the point there is info and then move to next work sheet - the worksheets all have different levels of info in rows so its being able to pick that up.
does anyone have a VBA i can use
Thanks
Wondering if you can help I am trying to create a consolidate button
I have a summary tab called 'Summary' and trying to consolidate number of worksheets in the same file into one
I want it to be able to clear the summary and then copy and paste info from worksheet 1,2,3,4,5,6 etc. into summary from where the first row of info starts from after header which is like on row 8 and then up to the point there is info and then move to next work sheet - the worksheets all have different levels of info in rows so its being able to pick that up.
does anyone have a VBA i can use
Thanks