This may be simple, but I cannot figure it out.
- On worksheet one, I have 3 columns of data in columns A, B and C.
- There are about 2600 rows of data in these columns.
- Column A in these rows all contain serial numbers
- On worksheet two, I have 3 columns for potential data in columns A,B and C.
- In the rows in column A of worksheet two, I will type in one of the serial numbers that is already in one of the cells in column A on worksheet one.
- When I type in that serial number in column A, I would like the data in columns B and C, in the same row as that serial number in worksheet one, to automatically populate columns B and C in the row that I just typed the serial number in worksheet two.
These serial numbers are for items that will arrive at different times. After the data automatically populates B and C, I will put the date it arrives in column D. The data in columns B and C are long strings of alphanumerics. I know they are correct in worksheet one, I want to make sure they stay that way in worksheet two. Thanks in advance for any help you may be able to give me.
Bookmarks