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
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