Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transfering information form one cell to another work sheet | Excel Worksheet Functions | |||
Help!! using sheet 1 information to change information on sheet 2 | Excel Worksheet Functions | |||
extracting totals from 1 work sheet to another work work sheet | Excel Discussion (Misc queries) | |||
GETTING SELECTED DATA FROM A WORK SHEET TO OTHER WORK SHEET | Excel Discussion (Misc queries) | |||
Populating work sheet combox with another work sheet values | Excel Discussion (Misc queries) |