Ok I need help again too.....
I have a very archaic way of invoicing but it works and one day I will get up with the 2000's and install quicken/myob but for the minute it is excel and it works.
So I have a couple of hundred excel sheets.
What I need to do is get excel to pull certain cells from each sheet and paste them into a new worksheet.
So I have an invoice with the:
Clients Name lets say (A1)
Description (A3)
Date it was invoiced (H1)
Total Price (H30)
How do I make excel pull A1, A3, H1 and H30 and paste it into a line on a new worksheet and make it do it to the other few hundred and paste it to the same sheet on a new line?
I thought I may be able to use Apple Automator but I have no idea how to use that program.
Cheers
|