kansopha
03-26-2015, 11:08 AM
Hello,
I'm starting with VBA and I'll need some help to write a code that will allow me to copy-paste data depending on the month of the transaction.
I have a table full of data with transactions, and I would like the code to detect and select the data for March for example, and then copy this selection to another sheet that already exist for the month of March, it will be an April sheet for April's transactions etc....
I know I can do that manually, but I have lots of data, and I was wondering if it was possible to make it faster, do you think it's possible?
I also tried a vlookup formula but it was not working...
I have attached an example of my file (Ihave more rows and columns than in the file).
Thank you very much for your help! :)13076
I'm starting with VBA and I'll need some help to write a code that will allow me to copy-paste data depending on the month of the transaction.
I have a table full of data with transactions, and I would like the code to detect and select the data for March for example, and then copy this selection to another sheet that already exist for the month of March, it will be an April sheet for April's transactions etc....
I know I can do that manually, but I have lots of data, and I was wondering if it was possible to make it faster, do you think it's possible?
I also tried a vlookup formula but it was not working...
I have attached an example of my file (Ihave more rows and columns than in the file).
Thank you very much for your help! :)13076