I have two large workbooks with information from an organization's computer inventory. I need to update columns S, T, U, and V in workbook B if there is data in those same columns from workbook A. The rows can be matched between the workbooks based on the entries in column H.
I'm sure there's probably some handy method to do this quickly, but I'm just not that familiar with Excel. If there is no way to do this, then I guess I'll have to manually go through a few thousand rows and manually copy and paste everything. Please help? I've tried to figure out a way to use vlookup, xlookup, and match, but I'm a rookie at this and can't seem to figure it out.
I'm sure there's probably some handy method to do this quickly, but I'm just not that familiar with Excel. If there is no way to do this, then I guess I'll have to manually go through a few thousand rows and manually copy and paste everything. Please help? I've tried to figure out a way to use vlookup, xlookup, and match, but I'm a rookie at this and can't seem to figure it out.