Copy/Paste based on multiple column/row criteria

CelestialMind7

New Member
Joined
Mar 29, 2019
Messages
13
Hi Guys,

I've looked for an answer to this but anything I've came across was referring to copying whole rows or columns and nothing I found pertained exactly to what I'm looking for. Here's what I'm trying to accomplish:

- I want to be able to copy a value of a cell, for a specific person, for a specific month, from one table, into a whole different workbook where I would need vba to search for that specific person in column A, and search for the matching date (month only) in a header (say row 2 for example), and paste that value into that new cell. I would need this to obviously be dynamic on both ends, meaning first and second sheet. So in an essence - vba - take the name mike smith, and the date March 2021, with a dollar value of "whatever", copy that, go to the other worksheet, find mike smith in column A, find March 2021 in row 2, go to that specific cell and paste it.

Would you guys be so kind as to give me a rough draft of the code and I could alter it from there on?

Thanks ahead,

Chris
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Forum statistics

Threads
1,136,445
Messages
5,675,900
Members
419,591
Latest member
mersanko

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top