the problem i am having now is
I want to copy data from several invoices (found in workbooks on diectory) to the main database
I used record macro to get started but how can I
amend the macro to have it do the same (copy fields) for each invoice & paste it in the proper row in the database
i would like to do this for every invoice
i want it to insert the data in the appropriate row so as to have an updated data
I have made a template for the invoice so the accountant can use & its meant to help me with the macros.
everytime there is an nivoice he will use the template & add the data then save it on the directory
I have my master database & want to update the data from several invoices to my master sheet
where can I start
thanks for any help