Excellearn56
New Member
- Joined
- Nov 21, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello,
I have a data set in sheet 1. In column D there is an ID number, and associated name in column E (highlighted yellow). I would like to create a VBA code to copy this ID and name into column T and U for the associated PO number in column A, up to the next blank cell in column A, then select the next ID number from column D and associated name in column E, and copy those into column T and U for their associated PO number in column A. Repeat this process until there is no more IDs.
I have attached an image of example data set and layout of the sheet.
Thank you!
I have a data set in sheet 1. In column D there is an ID number, and associated name in column E (highlighted yellow). I would like to create a VBA code to copy this ID and name into column T and U for the associated PO number in column A, up to the next blank cell in column A, then select the next ID number from column D and associated name in column E, and copy those into column T and U for their associated PO number in column A. Repeat this process until there is no more IDs.
I have attached an image of example data set and layout of the sheet.
Thank you!