mycelium
06-27-2019, 06:18 PM
Hi all,
The data I got on hand is not presented in a standardized format.
I would like to create a VBA function to restructure the data if the condition matches.
More details can be found in the Attachment uploaded 24517.
Thanks
Ideal way of working:
Step 1: Look into Cell B2 & C2 in Data Sheet
Step 2: Match to see if any of the Invoice No. in Reference Sheet is present in B2 or C2
Step 3a: If present, make the Invoice No. row as reference and further match the company, type, date in Cell B2 / C2
Step 4a: Output the matched data onto Cell D2 in DataSheet
Step 5a: Continue to next row (Cell B3 & C3)
Step 3b: If not present, continue to next row (Cell B3 & C3)
The data I got on hand is not presented in a standardized format.
I would like to create a VBA function to restructure the data if the condition matches.
More details can be found in the Attachment uploaded 24517.
Thanks
Ideal way of working:
Step 1: Look into Cell B2 & C2 in Data Sheet
Step 2: Match to see if any of the Invoice No. in Reference Sheet is present in B2 or C2
Step 3a: If present, make the Invoice No. row as reference and further match the company, type, date in Cell B2 / C2
Step 4a: Output the matched data onto Cell D2 in DataSheet
Step 5a: Continue to next row (Cell B3 & C3)
Step 3b: If not present, continue to next row (Cell B3 & C3)