Logical
I have some data in one spreadsheet which needs to be updated from another
spreadsheet, just in two columns out of 6. How can I do that ? For examle the top rows of Spreasheet1 are Name of Site, PV's, UU's, category, audience. The other spreadsheet has just Name of Site,PV's, UU's. I need to update Spreadhseet 1 with the data from Spreasheet 2, but still need the ( category and audience data to stay). How can I do that ? -- Thanks |
Logical
Hi Angeline
Try entering the following in cell B2 of Sheet1, then copy to C2. Copy B2:C2 down Sheet1 as far as needed =IF($A2="","",VLOOKUP($A2,Sheet2!$A:$C,COLUMN(),0) ) -- Regards Roger Govier "Angeline" wrote in message ... I have some data in one spreadsheet which needs to be updated from another spreadsheet, just in two columns out of 6. How can I do that ? For examle the top rows of Spreasheet1 are Name of Site, PV's, UU's, category, audience. The other spreadsheet has just Name of Site,PV's, UU's. I need to update Spreadhseet 1 with the data from Spreasheet 2, but still need the ( category and audience data to stay). How can I do that ? -- Thanks |
All times are GMT +1. The time now is 08:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com