Transfer excel data into invoice template

[mza3025]

Hello im new here but I am wondering if anyone can help me or put me in the direction of my query?

I am trying to catch up on my invoicing for my business incoming transactions. I have formatted the raw data into columns and would like a way to automatically import the name date and figures across to my invoice template to save, rather than have to manually find the data and fill it in.

is this something that can be done?

 

[arthurbr]

IMO the easiest way would be to use the MailMerge tool from MSWord linked to your Excel data.
One of many sites https://www.gmass.co/blog/mail-merge/
If you search for good info, look for the name Charles Kenyon or Macropod ( username) ( as they are mostly active on another forum I don't know if I'm allowed to post links here)

 

[dmt32]

is this something that can be done?

hi,
welcome to forum

Its perfectly possible to return a row of data from one Tab to a template in another tab using VBA

If you could share copy of your template using MrExcel Addin :XL2BB - Excel Range to BBCode or better still, place copy of your workbook with some dummy data in on a file sharing site like dropbox, makes it a little easier to create some code for your requirment

Dave

 

[mza3025]

hi,
welcome to forum

Its perfectly possible to return a row of data from one Tab to a template in another tab using VBA

If you could share copy of your template using MrExcel Addin :XL2BB - Excel Range to BBCode or better still, place copy of your workbook with some dummy data in on a file sharing site like dropbox, makes it a little easier to create some code for your requirment

Dave

Hello Dave,

thanks for your response, my invoice file is a PDF but to make things easier ive uploaded it as a word document.

invoice file

SYTC.docx

Shared with Dropbox

www.dropbox.com

excel sheet

Book1.xlsx

Shared with Dropbox

www.dropbox.com

ultimately what id like is for the following to map across and automate the creation of invoices from the data in the excel sheet to either email to myself or save to my computer

my raw data contains 300 entries so anything beats doing this manually

 

[dmt32]

I was thinking your template is a worksheet in same workbook but If you want to export records to a word document then follow the link suggested by @arthurbr

Dave

 

[mza3025]

IMO the easiest way would be to use the MailMerge tool from MSWord linked to your Excel data.
One of many sites How to Mail Merge from MS Word and Excel (Step-by-Step Guide)
If you search for good info, look for the name Charles Kenyon or Macropod ( username) ( as they are mostly active on another forum I don't know if I'm allowed to post links here)

Thank you i will look into this now!

I was thinking your template is a worksheet in same workbook but If you want to export records to a word document then follow the link suggested by @arthurbr

Dave

I tried exporting the invoice template into a worksheet however the formatting doesn’t come out correctly

 

[mza3025]

I was thinking your template is a worksheet in same workbook but If you want to export records to a word document then follow the link suggested by @arthurbr

Dave

Hello Dave

ive reupoaded my sheet to include my data and invoice in sheet 2

template on excel.xlsx

Shared with Dropbox

www.dropbox.com

is it possible to automate creation of invoices for my raw data? Ideally to export as a PDF

 

[arthurbr]

Again, MSWord has all the needed functionalities, your database staying in Excel of course