VBA code to copy data to another sheet depending on the month

**kanyarat** · 03-24-2015, 04:11 PM

Hi everybody,

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 (index n°4 in the file), it will be an April sheet (index 5) for April's transactions etc....

I know I can do that manually, but I have thousands of data, and I was wondering if it was possible to make it faster, do you think it's possible?

I have attached a "very" simplified version of my file.

Thank you very much for your help

**JieJenn** · 03-24-2015, 04:26 PM

Why not use one formula to apply across all the worksheets? I named your sheet1 data set to Data

=VLOOKUP(B$1,Data,MATCH($A2,Sheet1!$B$1:$C$1,0)+1,0)

**jindon** · 03-24-2015, 04:55 PM

VBA solution.

**kanyarat** · 03-25-2015, 03:46 PM

Sorry for the late reply... and thank you for your help!

I tried both solutions, but it's not working on my original document... Is it because I have too many columns, rows?

I've attached a new document more detailed.

Thank you again for your help, I really appreciate it!