Jason Link
New Member
- Joined
- Aug 27, 2018
- Messages
- 2
I am trying to write a macro in order to do the following:
In one workbook, I want to search for data from another workbook and return a value based on the ID # if certain criteria is met.
IE: If it says Melanie Jackson or Hector Hernandez in the October column, I want it to return this value (Melanie Jackson or Hector Hernandez October). If it says no review, I want the macro to look to September and return what I just mentioned. I basically want to keep track of the last time something was reviewed and by whom from a master spreadsheet to individual spreadsheets. I don't know if this can even be done, but it seems like a complex thing of vlookups, IF statements and more. Thank you.
<colgroup><col width="51" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1820;">
<col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3100;">
<col width="85" style="width: 64pt; mso-width-source: userset; mso-width-alt: 3015;">
<col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3100;" span="2">
<tbody>
</tbody>
<colgroup><col width="51" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1820;"><colgroup><col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3100;"><colgroup><col width="85" style="width: 64pt; mso-width-source: userset; mso-width-alt: 3015;"><colgroup><col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3100;" span="2"><tbody>
</tbody>
In one workbook, I want to search for data from another workbook and return a value based on the ID # if certain criteria is met.
IE: If it says Melanie Jackson or Hector Hernandez in the October column, I want it to return this value (Melanie Jackson or Hector Hernandez October). If it says no review, I want the macro to look to September and return what I just mentioned. I basically want to keep track of the last time something was reviewed and by whom from a master spreadsheet to individual spreadsheets. I don't know if this can even be done, but it seems like a complex thing of vlookups, IF statements and more. Thank you.
ID# | July | August | September | October |
2007 | Melanie Jackson | No review | No review | Melanie Jackson |
2044 | Melanie Jackson | No review | No review | Hector Hernandez |
2067 | No Review | No review | Melanie Jackson | No review |
2070 | Melanie Jackson | No review | No review | Melanie Jackson |
2111 | Hector Hernandez | No review | No review | Melanie Jackson |
<colgroup><col width="51" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1820;"><colgroup><col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3100;"><colgroup><col width="85" style="width: 64pt; mso-width-source: userset; mso-width-alt: 3015;"><colgroup><col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3100;" span="2"><tbody>
</tbody>