+ Reply to Thread
Results 1 to 2 of 2

How can I export data from an excel file to a excel template?

  1. #1
    Registered User
    Join Date
    08-03-2022
    Location
    Amsterdam
    MS-Off Ver
    365
    Posts
    1

    How can I export data from an excel file to a excel template?

    So I have a question,

    I have a xlsx file with 10+ column and every row has some data.
    3 of those columns are declaration_date, invoice_number and total_declared_amount.
    I also have a invoice template in xlsx with macros

    So I would like to export every row into a xlsx file using the invoice template.

    How can I get this done.
    Maybe some tools?

    Please help me out
    Last edited by iforit; 08-03-2022 at 10:22 PM.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: How can I export data from an excel file to a excel template?

    The easiest way will be by using a simple macro which will in a loop (row by row) take content of these cells in given row, write them to template file and save the template file us regular workbook with specified in a macro filemane (may be a name consisting of declaration date and invoice number will be a good idea).

    It's really basic macro, but if you need help with it, see the yellow banner above and attach (with all sensitive infromation removed) sample files.
    Just few rows of a source file and the template (can be amost empty with clearly marked cells which shall be filled by data from the source).
    Best Regards,

    Kaper

+ 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] Export Excel data to Word or through Excel Report Template
    By atomichybrid in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-06-2020, 03:23 AM
  2. Export data's from certain cells from excel to an existing word template
    By rayn3 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-20-2019, 04:27 AM
  3. VBA: How to export excel Data to Outlook template?
    By Alcapp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2017, 12:20 AM
  4. Export chosen data from Excel into multiple Word files, based on a given template
    By Doronshadmi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2016, 10:06 AM
  5. Export Access Query Record into decicated fields in a Excel Template File
    By JRayhan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2013, 04:38 PM
  6. Replies: 0
    Last Post: 07-06-2006, 03:25 PM
  7. [SOLVED] export excel data to a word template using a macro
    By Ross1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-25-2005, 01:06 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