All, I have two spread sheets, on sheet 1 we have 5 columns. Column A has a the Key. Sheet two has 3 columns with column A as the Key matching sheet 1. What I'm trying to do is move information from sheet 2 (Column B and C) into column D and Column E on sheet one based on the Primary Key that is on both sheets in column A. See attachment. There are several thousand rows so an automated process would be greatly appreciated. This one is out of my scope of skills. Thanks!
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.