Dankzy
03-23-2019, 03:13 AM
Hi I'm new to this forum and very new to VBA codeing
I'm working on a PC using Excel 2013
I'm working on a simple accounting process - By using a button I want to copy data from an "invoice" sheet into a purchase ledger (All in the same workbook) - I've sorted this ok but want the purchase ledger to have 12 worksheets Jan - Dec
On the Invoice sheet I have a drop down list to determine the month (need to do this as the month end may vary) this is in Cell L2
So at the start of my macro I want to reference L2 and then select which sheet to copy too. I've looked for a solution to this but have been unsuccessful.
I hope someone can help
Cheers Dankzy
I'm working on a PC using Excel 2013
I'm working on a simple accounting process - By using a button I want to copy data from an "invoice" sheet into a purchase ledger (All in the same workbook) - I've sorted this ok but want the purchase ledger to have 12 worksheets Jan - Dec
On the Invoice sheet I have a drop down list to determine the month (need to do this as the month end may vary) this is in Cell L2
So at the start of my macro I want to reference L2 and then select which sheet to copy too. I've looked for a solution to this but have been unsuccessful.
I hope someone can help
Cheers Dankzy