can I create macros

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

Guys and Gals,

I hope I am in the right room. First I create worksheets about four times a
week. These are very basic. I take the last and then copy and paste into a
new document. Only problem here is that I have to put the headers and
footers back in place. Is there a way to create a macro to do this for me?
I just want to be able to open a macro file that puts this in? I know it
can be done like with AutoCad but I am not sure about excel. Any help would
be appreciated.

Brad Wilson
(e-mail address removed)
 
It sounds like you do a copy|paste of the cells on the worksheet.

How about rightclicking on the existing worksheet's tab
select "Move or copy"
(check the Copy box at the bottom)
make the "to book" a new workbook.

When you copy the whole sheet, the headers will come with it.

If you need a macro, you can record one when you do it manually.
 
Back
Top