Muthukumar Rajaram
New Member
Good day everyone,
I have a set of data where a combination (product/location/batch number) reoccurs. When I extend the dataset with latest information (number of days left to sell for a batch), I need to get the comment based on my notes from the last time I had reviewed the combination.
Example:
Feb-23 notes
A-xyz-123 - Will be sold to Costco by mid April
Mar-23 notes
A-xyz-123 - comments section is blank (because I didn’t have time
In April-23, when I paste the combination 100 Rows below the above, I need the comment from Feb-23 “Will be sold to Costco by mid April” to appear against this.
Hope this makes sense.
Thanks for your help.
Cheers
I have a set of data where a combination (product/location/batch number) reoccurs. When I extend the dataset with latest information (number of days left to sell for a batch), I need to get the comment based on my notes from the last time I had reviewed the combination.
Example:
Feb-23 notes
A-xyz-123 - Will be sold to Costco by mid April
Mar-23 notes
A-xyz-123 - comments section is blank (because I didn’t have time
In April-23, when I paste the combination 100 Rows below the above, I need the comment from Feb-23 “Will be sold to Costco by mid April” to appear against this.
Hope this makes sense.
Thanks for your help.
Cheers