Looking for advice / recommendations

[ipbr21054]

Hi,
I have a worksheet that I enter data into each month.
At the end of the month I would like to make a copy of the page or the values entered into it then clear the cells & start over again for the next month.

The required advice is how should I go about creating a copy / saving a copy etc.

I like the ease of the way it works so a button press would then do what’s required it respect of the saved copy.
This saved copies are then printed later
So maybe save a range to a word doc or pdf ?

What do you advise.
Thanks. Thanks to

 

[ipbr21054]

That has now saved as expected.
JULY 2019

Many thanks

 

[Jaafar Tribak]

That has now saved as expected.
JULY 2019

Many thanks

Glad you got this sorted out and thanks for the feedback.

Regards.

 

[ipbr21054]

Would you mind taking a quick look at this please.
https://www.mrexcel.com/forum/excel-questions/1103950-can-you-check-my-code-please.html#post5309272

Post 1

All working fine until i recorded a macro and add it to the existing working code which now has issues.

All i require it the ranges mentioned to have ALL Borders applied.
This extra piece of code that was added is shown in red.

If i remove the red part it runs fine so its something ive entered incorrectly

 

[Jaafar Tribak]

Hi ipbr21054

I am afraid, I will be logging off shortly but I'll take a look at it later on.

Regards.

 

[ipbr21054]

No problem & thanks for todays help