Excel

[plutosgirl]

Stupid question...

How do I copy multiple books without having to hit move/copy, move to end, and create copy 10 times?

 

[plutosgirl]

If you just did it you would have been done by now

I did 8 while I was waiting on your answer. I need more. You gonna tell me? :imagestor

 

[chipshot]

I'm not exactly sure what you are referring to with the move/copy noise but you can copy and paste multiple cells by just selecting them, copying, then pasting.

 

[plutosgirl]

I'm not exactly sure what you are referring to with the move/copy noise but you can copy and paste multiple cells by just selecting them, copying, then pasting.

I want to copy an entire worksheet, ie....make 20 copies of one worksheet in one workbook and date them at the bottom. All sheets will have the format and formulas I want on them but I need an entire workbook dedicated monthly and need to name the sheets by date.

If I right click on the tab at the bottom, I can copy it, but I want to copy several and Im not sure how.

 

[chipshot]

I've never done it but I'm sure you could write some kind of VBA macro. Are you familiar with macros and how you can record them allowing you to view the code that is used to execute the functions you perform when you use the visual interface?

 

[chipshot]

you can also select the entire worksheet by clicking the extreme top left column header

 

[plutosgirl]

I've never done it but I'm sure you could write some kind of VBA macro. Are you familiar with macros and how you can record them allowing you to view the code that is used to execute the functions you perform when you use the visual interface?

You lost me at V.

But thanks for trying to help. I found the girl who sent me the sheet has some formulas wrong actually, so if I had spent all that time to copy them I would be pissed.

 

[plutosgirl]

I think maybe Im just stewpid.

 

[chipshot]

you might need a Toe Kick Saw

 

[plutosgirl]

you might need a Toe Kick Saw

You know where to get one?