Hi Folks,
I am new to the forum, but not completely new to Excel
I have a question to which I can't find an answer myself.
a workbook containing 4 sheets, all sheets have the same format, only the number of rows and the content of the cells changes.
What I would like is a new worksheet with a macro, so that when i push the button update (or whatever)
that all 4 existing worksheets are copied to the new one, without leaving blanks etc. and this even if you have previously added items to one of the 4 sheets.
Is that possible. Can someone please guide me in the right direction.
The final goal is to have 1 huge list which is composed of the 4 sheets
many thx
I am new to the forum, but not completely new to Excel
I have a question to which I can't find an answer myself.
a workbook containing 4 sheets, all sheets have the same format, only the number of rows and the content of the cells changes.
What I would like is a new worksheet with a macro, so that when i push the button update (or whatever)
that all 4 existing worksheets are copied to the new one, without leaving blanks etc. and this even if you have previously added items to one of the 4 sheets.
Is that possible. Can someone please guide me in the right direction.
The final goal is to have 1 huge list which is composed of the 4 sheets
many thx