lookup
Hello
i'm not sure which function i should use. column A has numbers from 5000 to 5999 column B i have put a "x" in the cell of the row i wish to populate the other worksheet column C last name column D first name and so on in the other worksheet i would like to populate only the row that have the "x" in the cell i would also like to populate only certain column of that row in that new spreadsheet thank you JY |
lookup
Apply Autofilter to column B and select x from the filter pull-down.
Then highlight the visible data (just the columns you want to take) and click <copy then <paste this into the new worksheet. Hope this helps. Pete On Nov 13, 9:40*am, jy wrote: Hello i'm not sure which function i should use. column A has numbers from 5000 to 5999 column B i have put a "x" in the cell of the row i wish to populate the other worksheet column C last name column D first name and so on in the other worksheet i would like to populate only the row that have the "x" in the cell i would also like to populate only certain column of that row in that new spreadsheet thank you JY |
lookup
Hi JY
Let's say you are in sheet 1, that the x is in column B1 and the column you want to populate is F, go now to where you want that information enter the formula as follow =IF(Sheet1!B2="x",Sheet1!F2,"") "jy" wrote: Hello i'm not sure which function i should use. column A has numbers from 5000 to 5999 column B i have put a "x" in the cell of the row i wish to populate the other worksheet column C last name column D first name and so on in the other worksheet i would like to populate only the row that have the "x" in the cell i would also like to populate only certain column of that row in that new spreadsheet thank you JY |
All times are GMT +1. The time now is 08:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com