#1
|
|||
|
|||
How to update Sheet1 from Sheet2 automatically?
I have an Excel Sheet1 with columns: FirstName, LastName, LastDatePurchased
I need to update this list with the data from another Excel Sheet2 with columns: FirstName, LastName, ProductType, LastDatePurchased This excel file is big file and source of the data, here is what I need to do. 1. Find all the rows in Sheet2 where ProductType=”Food” (other records I am not interested in) 2. Look at FirstName, LastName in Sheet2 and match with the ones in Sheet1 update LastDatePurchased in Sheet1 with the value from Sheet2 3. If there is extra rows in Sheet2, meaning not available in Sheet1 where ProductType=”Food”, I would like to add these records bottom of the Sheet1. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to Auomatically populate "Sheet2" when "Sheet1" is full | zhead | Excel | 4 | 12-11-2015 06:13 AM |
Transferring info from 1column on sheet2 to sheet1 | rogcar75 | Excel | 22 | 08-26-2014 05:07 PM |
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 | bobznkazoo | Excel | 2 | 03-27-2014 11:14 AM |
split text files to worksheets (sheet1,sheet2,sheet3 soon sheet 25) | gsrikanth | Excel Programming | 1 | 03-22-2012 11:04 PM |
How to merge two cells from sheet1 to one cell in sheet2 in next sheet | KIM SOLIS | Excel | 6 | 10-30-2011 11:14 PM |