Avatar of Simon Allaway
Simon Allaway
Flag for United Kingdom of Great Britain and Northern Ireland asked on

Create a automated invoice using Excel Data

Hi All
I am trying to create a automatic invoice using excel.  On the forth tab is the invoice- when I select the invoice number (N3) I want it to automatically fill the client name(D11)  enter the date from range (f21) and enter the date to range(h21) and enter the unit price (i21)

The data sources is on tab 3 (MCL Totals)

I have been playing with VLOOKUP but cant quite get the syntax right.  Been trying for about 3 hours now and going mad so any help would be so great.  was using http://www.excel-easy.com/examples/automated-invoice.html as a guide if this resource helps anyone.

Cheers

Simon
Postage-Spreadsheet-2014.xlsx
Microsoft Excel

Avatar of undefined
Last Comment
Naresh Patel

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Naresh Patel

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Simon Allaway

ASKER
Hi ITjockey

Many thanks for the above works like a dream.  I do have one question for you.  The actual invoice is there a way that I can automatically generate separate file based on the information in the invoice sheet which is automatically saved to the right client folder on the network and print automatically?  Would this be some sort of script or a macro?  What would be awesome if I could some how automate the entire process so that it runs 4 times a year automatically producing the separate xls file for each invoice and print it off thus removing the human element and reducing errors etc.

Regards

Simon
Simon Allaway

ASKER
Just so you know at the moment I am having to select the invoice then print to pdf for each invoice.
Naresh Patel

Mr.cybersi,

Yes it is possible via VBA Script but i am new born baby in VBA Script. So i would suggest you may ask new question if you satisfied with what you ask for in your very first post or just press request attention button.Request Attention Button.
Thanks
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes