Help with copy/paste VBA code

  • Thread starter Thread starter Thrava
  • Start date Start date
T

Thrava

Hi folks,
I have an excel workbook where different revenue scnearios
are entered and then you get a table and couple of graphs.
What I like to be able to do is:

I like to add a command button on a sheet where if
clicked, it will copy a table and couple of charts, then
paste them in an empty sheet.

Then next time the button is clicked, it will do the same
things but now pastes these in the next empty sheet.. and
so on.

how does one do this.
 
The best way to start is to record a macro whilst you do these actions.

Once done then post any queries back here
 
Back
Top