Create a new workbook every week and paste picture per sheet

Ron Morris

Active Member
Joined
Oct 18, 2004
Messages
430
Hi,

This is what I had in mind but am definetely open to better solutions.

I have sent an Excel file to a customer where they can generate their own quotes based on the criteria they choose. Once they are finished, they click on a save button which will save the file by the quote number they enter onto their drive.

What I would like to do is take the quote page only and paste it into a new workbook. I would like a new workbook created each week automatically. Each quote page would represent a sheet in the workbook. I would also like the sheet to be added automatically (representing the quote).

I can handle the code for the copy/pastespecial/picture but am not sure how to do the rest or if there is a better way.

Thanks in advance.

Ron
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Anne Troy

MrExcel MVP
Joined
Feb 18, 2002
Messages
2,603
Ron: I'm checking "unanswereds". I don't understand what you're saying. Could you possibly reword it?
 

Ron Morris

Active Member
Joined
Oct 18, 2004
Messages
430
Hi,

The file I have sent the customer is 1MB. I do not want them to send me an E-mail everytime they do a quote because it is too large and takes too long to open.

I would like to just get a copy of the quote (which is on it's own tab), and copy /pastespecial as a picture into a new workbook that could be automatically created each week. Every quote would be it's own tab (sheet). I would like to have each sheet renamed as the quote number, which will be on the quote sheet.

Here's another thought: If the limit is 255 sheets per workbook, why not create a new workbook once the limit of 255 sheets is reached.

Is this even possible?

Ron
 

Watch MrExcel Video

Forum statistics

Threads
1,122,518
Messages
5,596,621
Members
414,082
Latest member
sasmita

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top