R
Rob P
Hi there, I have over 100 tabs with assorted data
I want to create a summary on one tab
I am having problems writing a macro to copy the data from each tab
onto the summary page
I want to include each tab name on the summary sheet in column A with
the date accross the row starting in Column B
i have written the loop - but am struggling to include the each tab
name
any ideas? many thanks
I want to create a summary on one tab
I am having problems writing a macro to copy the data from each tab
onto the summary page
I want to include each tab name on the summary sheet in column A with
the date accross the row starting in Column B
i have written the loop - but am struggling to include the each tab
name
any ideas? many thanks