Hi,
I have inherited some workbooks/worksheets & having a personal crash course in Excel, to amend these to my needs, I am using Excel 7 !!! One area where I am stuck:-
I have one workbook with 2 worksheets. The first worksheet is formatted as my Companies invoice, the second worksheet contains the data to complete the invoice (1 row per Customer).
I select whichever Customer (using the Customer Number) I want from the data worksheet & copy & paste the Customer Number to the invoice worksheet. The remainder of the invoice is then populated (using Vlookup commands, matching on Customer Number) & pulling all corresponding data from the data worksheet.
I then run a macro using a Control Key, which actions a few other functions & finishing with printing of the invoice.
I now want to recognise which Customers have had their invoice printed when looking back at the data worksheet.
I have added a column in the data worksheet called "printed" & currently manually insert the word "yes" for the Customers invoice as each one is printed, but I am sure there could be a way to automate this?
As a specification, I want to add a function to the print invoice macro, that would use the Customer Number being printed on the current invoice, find & match the corresponding Customer Number in my data worksheet & for that same Customer (i.e on that same row), insert the word "yes" in the "printed" column.
I have been looking at the Excel commands available & struggling, I am expecting perhaps a combination of commands and can they run within a macro ?!?!!?
Would really appreciate any help or direction on this.
Many Thanks
Bookmarks