Audra Breedlove
asked on
VBA Lookup
Hello, I need assistance with a Vlookup Macro
Can you please build me two macros. The first one is just so that I can view how the a VBA lookup would look, the second one is the not show the lookup values but use them to display this dates that fall within the range
1. Please create a vba vlookup to E3 on the Employee Data to pull in OUD1 - OUD9 from the Org Unit Master. If the Org Unit is not in the list display, "OU Not listed" in column F and blanks for columns G-N. Results would look like A-N on the Employee Data tab
2. I need a macro to only display Date 1, if it fits between the >=Begin Date and <End Date. So to display Date2 if it's between Begin Date and End Date. If the Org Unit is not in the list display, "OU Not listed" in column F
Results would be A-E and Date 1 - Date 8 (not showing the OUD1 - OUD9
The Employee Master can be a shorter or much longer list
VBA-Vlookup-and-date-range-insert.xlsm
Can you please build me two macros. The first one is just so that I can view how the a VBA lookup would look, the second one is the not show the lookup values but use them to display this dates that fall within the range
1. Please create a vba vlookup to E3 on the Employee Data to pull in OUD1 - OUD9 from the Org Unit Master. If the Org Unit is not in the list display, "OU Not listed" in column F and blanks for columns G-N. Results would look like A-N on the Employee Data tab
2. I need a macro to only display Date 1, if it fits between the >=Begin Date and <End Date. So to display Date2 if it's between Begin Date and End Date. If the Org Unit is not in the list display, "OU Not listed" in column F
Results would be A-E and Date 1 - Date 8 (not showing the OUD1 - OUD9
The Employee Master can be a shorter or much longer list
VBA-Vlookup-and-date-range-insert.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER