Creating copy of a workbook from a specific cell value, copying data, save in a folder

frostinheart

New Member
Joined
Apr 10, 2020
Messages
1
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Hi everybody,

Been reading and learning alot from here through the years, thank you very much for all the support.

This time i couldn't figure out how to fix this issue, or find a better solution, i'll try to explain what i'm trying to do;

I have a main workbook that shows every delivery, based on item names and their unique delivery numbers. After every delivery, i'm preparing some kind of invoices to send my clients with this quantities and it contains unique number of this delivery. All the items have specific prices (prices are not included in this list) and i have different kind of invoices for each of those products in a different folder. For example in c:\sales invoices folder, i have templates for product a b c d and e. They use the same template but their names are ''D56040 PRoduct A Sales invoice'' or ''D56039 Product B Sales invoice''.
1586495610067.png


I'm trying to create some kind of macro with shortcut, to be able to create a copy of relevant workbook, rename it with the selected delivery number and item name -> open the workbook and copy the unique delivery number in a specific cell then save and close + convert to pdf when executed. After this number is entered, the workbook will automatically merge the data from my main workbook with the formulas i created. I'm hoping this solution will save me lots of time.

For example under c:\sales invoices folder there is ''D56040 PRoduct A Sales invoice'' workbook. I would like to eouble click Cell F6 which is ''D56042'' to execute the macro, it will create a copy of the workbook ''d56040 PRoduct A Sales invoice'' (by checking it's product name probably) rename it as'' D56042 PRoduct A Sales invoice' copy the F6 cell value ''d56042'' into the new workbook's specific cell then save and close + convert to pdf.

IS such thing possible? I'm waiting for your thoughts and maybe more suitable solutions. Maybe not to keep different product invoices with the same templates but create one template and merge all data from a specific point???

Thank you very much from now.
Regards to all Excel gurus
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

AlphaFrog

MrExcel MVP
Joined
Sep 2, 2009
Messages
16,358

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
50,995
Office Version
  1. 365
Platform
  1. Windows
@frostinheart

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,974
Messages
5,575,305
Members
412,654
Latest member
dibison18
Top