njfeathe85
New Member
- Joined
- Aug 23, 2011
- Messages
- 9
Hi
I have a spreadsheet that produces invoices and then tracks them for me (with regards how long i've been waiting for it to be paid etc). At the moment I click on "Invoice New" sheet and then click on 'Create New Invoice' Button which runs a VBA Form that I use to populate the invoice template. It finds the address by using a VLookup and it fills the other information into the Invoice. I then use a macro to print the document and save it as a PDF. I then have to go to the other sheet "Invoices" where I have lots of different formulas running and hidden in the background to essentially provide me with the following details:
Date invoice due after 30 Days
Date invocie due based on clients usual payment times
How much Tax to save
How much to put away for tax
Amount left after deductions.
I also use conditional formatting to determine if the invoice is waiting, overdue or ultimately when I enter paid, it I can visually see that it has been paid by the fact it all turns green.
What I want to happen is that when print the invoice by running the print macro, it will find go to the "Invoices" sheet, match the invoice number (As I have them already written in but if it is better to copy them in then thats fine), then copy the Date, Client and Total invoice cost. The formulas I have in the sheet do the rest of the work for me.
This information is then a fixed record. (This rules out using linked cells etc as the data changes on every invoice).
I was wondering about looking down the route of finding the first empty cell in each column and copying the data from the Invoice sheet?
I look forward to your replies.
Cheers
I have a spreadsheet that produces invoices and then tracks them for me (with regards how long i've been waiting for it to be paid etc). At the moment I click on "Invoice New" sheet and then click on 'Create New Invoice' Button which runs a VBA Form that I use to populate the invoice template. It finds the address by using a VLookup and it fills the other information into the Invoice. I then use a macro to print the document and save it as a PDF. I then have to go to the other sheet "Invoices" where I have lots of different formulas running and hidden in the background to essentially provide me with the following details:
Date invoice due after 30 Days
Date invocie due based on clients usual payment times
How much Tax to save
How much to put away for tax
Amount left after deductions.
I also use conditional formatting to determine if the invoice is waiting, overdue or ultimately when I enter paid, it I can visually see that it has been paid by the fact it all turns green.
What I want to happen is that when print the invoice by running the print macro, it will find go to the "Invoices" sheet, match the invoice number (As I have them already written in but if it is better to copy them in then thats fine), then copy the Date, Client and Total invoice cost. The formulas I have in the sheet do the rest of the work for me.
This information is then a fixed record. (This rules out using linked cells etc as the data changes on every invoice).
I was wondering about looking down the route of finding the first empty cell in each column and copying the data from the Invoice sheet?
I look forward to your replies.
Cheers
