Dukman83
06-10-2011, 03:25 AM
Hi guys, I was wondering if anyone can help me with a massive issue i'm experiencing with excel vba at the moment.
What I am trying to do is select one cell only in an invoice workbook called "Invoices Template" and determine the date that is within that cell. Once the date is determined, I would like it to copy the cell with the invoice fee and select the date's respective month worksheet, and paste it into it's respective date cell in a different workbook called "Balance Sheets". For example, the date on the invoice may be 20/09/10 (DD/MM/YY format). It would copy the invoice fee and paste it into the "Balance Sheets" "September" tab, into a cell that is designated the date of 20.
I have been trying to nut this out for a few solid days and have not been able to make it work for me,
Any help will be greatly appreciated.
P.S. Please let me know if you'd like any code specifics.
Cheers,
Alex
What I am trying to do is select one cell only in an invoice workbook called "Invoices Template" and determine the date that is within that cell. Once the date is determined, I would like it to copy the cell with the invoice fee and select the date's respective month worksheet, and paste it into it's respective date cell in a different workbook called "Balance Sheets". For example, the date on the invoice may be 20/09/10 (DD/MM/YY format). It would copy the invoice fee and paste it into the "Balance Sheets" "September" tab, into a cell that is designated the date of 20.
I have been trying to nut this out for a few solid days and have not been able to make it work for me,
Any help will be greatly appreciated.
P.S. Please let me know if you'd like any code specifics.
Cheers,
Alex