Hi all. Hoping all you excel experts can help with this Data matching worksheet Im trying to create.
Its actually quite similar to the "Automatically Copy New Data to Another Worksheet" tutorial but I would like it to have find,match, and copy capabilities. Picture my worksheet haing two sheets, one sheet for data entry that will get replaced with new data every month, and another sheet that stores the incoming data in the first sheet.
I want to copy the data to another worksheet but it needs to match the account code that are in the rows and need to match the dates that are in the columns. For example, in the data entry worksheet, the first column will have account codes ABC with an amount $100 and EFG with an amount of $200 for February 2020. I want a macro that will look in other worksheet and find ABC in rows and February 2020 in columns and copy and paste values $100 and find EFG and Februray and copy and paste values $200.
Is this something you all can help with? Much appreciated!