Microsoft Excel + macro help

BenJ · 16 Jul 2011 at 16:06

Hi guys,

I need to write/record a macro which basically copies a worksheet and saves it as a new worksheet. But each time the Macro is clicked it needs to save the new sheet with a new name. Like 1 then 2, then 3 e.t.c

Anybody able to point me in the right direction???

Cheers

BenJ · 16 Jul 2011 at 19:00

by worksheet i mean exactly what you said...but instead of the macro making the next sheet in the series "Sheet1" "Sheet2" I want it to say "Order1", "Order2" e.t.c

So data in worksheet "Data" then when I click a macro it copies worksheet "Data" into "Order1", then next time I click the macro it copies "Data" into "Order2".

Are you following mate? Cheers for any help btw, much appreciated!

BenJ · 16 Jul 2011 at 21:15

Cheers buddy

BenJ · 17 Jul 2011 at 15:08

Thanks! All I need it to do now is delete columns A to D in the newly copied sheet "Order1" e.t.c

You couldn't tell me what to put for that could you??

Cheers

BenJ · 17 Jul 2011 at 15:09

Oh actually before it copies the sheet "Data" I need it to refresh the pivot table in the sheet, is that possible?

BenJ · 17 Jul 2011 at 18:23

Thanks

BenJ · 22 Jul 2011 at 20:45

Ahh been away all week. Right I want the columns deleted completely. The data range will be columns a-c in a sheet called "Menu". Yes the pivot table will need to be in the order sheets please.

Cheers

BenJ · 24 Jul 2011 at 09:38

Think it's getting a little bit confusing now so i've sent you a new workbook by mail!