+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Registered User
    Join Date
    03-26-2017
    Location
    turkey
    MS-Off Ver
    office 2016
    Posts
    12

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

    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. Column A: Date, Column B: ITEM NAME, Column C: Pallet No, Column D: Pallet Size, Column E: Quantity, Column F: Delivery No. ,

    After each delivery, i'm preparing some kind of invoices to send my clients with this quantities and it contains unique number (Data in Column F)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''. (D56040 is the data in Column F, PRoduct B is the data in Column B, and Sales invoice is the fixed tag)

    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 double 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
    Last edited by frostinheart; 04-10-2020 at 02:35 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

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

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    I will add it for you this time as you are new.Please read the forum rules you seem to have skipped

    https://www.mrexcel.com/board/thread...older.1130281/

  3. #3
    Registered User
    Join Date
    03-26-2017
    Location
    turkey
    MS-Off Ver
    office 2016
    Posts
    12

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

    Thank you very much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copy Active Sheet and Save as specific name on cell value in current folder
    By markharris2004 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-21-2019, 09:50 PM
  2. Copying Data to a new workbook and save to a specific folder
    By bambino86 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-05-2017, 10:31 PM
  3. Replies: 2
    Last Post: 04-13-2017, 08:25 AM
  4. [SOLVED] macro to copy from a closed workbook on a desktop folder and save specific amended sheet
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-16-2017, 08:56 AM
  5. How to copy Sheet to a new workbook and save to a specific folder
    By moxman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-15-2014, 07:43 PM
  6. Button to save workbook, with value in specific cell (H5), in a specific folder
    By markeeny in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2014, 01:15 PM
  7. Save entire workbook as copy in specific folder with VBA
    By cychua in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-01-2012, 08:35 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1