How to take information from one work sheet to another?
What do you need to do to have Excel look at one workbook and if there is
something in a cell to have it take the cell before it too show the name in the other workbook? What I need to do is to take a list of names some goes with one group and others to a different one. But the names are in one list. So if it looks at the cells to the end of the names and it finds a X then it will take that name in front of the X to the other worksheet, and followers that all the way down the list. Can someone give me some ideas where to begin to make this happen?? Thank you |
How to take information from one work sheet to another?
Hi Yesyes,
One way... If you have 2 workbooks, the first with the list of names and the 2nd with the list you want to pull out (those with an "x") you might try this: Assuming the list of names is in Workbook1 (book1), spreadsheet 1 (sheet1), column A, and the "x" is in column B, in the 2nd workbook put in, say, column A =if('[book1.xls]Sheet1'!b1="x",'[book1.xls]Sheet1'!a1,"") Drag it down the same amount as the list on workbook 1. You can then filter out the spaces. Let me know if this helps. Squeaky "yesyes5" wrote: What do you need to do to have Excel look at one workbook and if there is something in a cell to have it take the cell before it too show the name in the other workbook? What I need to do is to take a list of names some goes with one group and others to a different one. But the names are in one list. So if it looks at the cells to the end of the names and it finds a X then it will take that name in front of the X to the other worksheet, and followers that all the way down the list. Can someone give me some ideas where to begin to make this happen?? Thank you |
All times are GMT +1. The time now is 10:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com