Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I get data from one worksheet into another exsiting worksh
Here is my case:
I already have 2 worksheets both include 2 columns: Cell & Site Name. WorkSheet A includes all the cells and site names; WorkSheet B includes only a small portion of Cells. Now what I need to do is to get the site name for each cell in worksheet B. I don't want to manually copy & paste. Is there any way to speed up? Thanx! Cell Site Name T50MB7 T73MA7 T73MA8 T73MA9 T04MV9 T04MW7 T34MK7 T34MK8 T51ME1 T51ME2 T51ME3 T04MV1 T34OR2 T34OR7 T34OR8 |
#2
|
|||
|
|||
Sabrina, you can use the VLOOKUP formula to fill in your Site Names in
Worksheet B. Example: =VLOOKUP(A2,Sheet1!$A$2:$B$5,2,FALSE) A2 would be the first Cell in Worksheet B Sheet1!$A$2:$B$5 would be the complete list (range) in Worksheet A 2 represents the column number of the data you are "calling" from Worksheet A FALSE setting allows you to get correct results if your range in Worksheet A isn't sorted in ascending order Excel's help system does a pretty good job of explaining how to use the VLOOKUP formula as does several Excel books out there. Hope this helps! -- Elisabeth "Sabrina" wrote: Here is my case: I already have 2 worksheets both include 2 columns: Cell & Site Name. WorkSheet A includes all the cells and site names; WorkSheet B includes only a small portion of Cells. Now what I need to do is to get the site name for each cell in worksheet B. I don't want to manually copy & paste. Is there any way to speed up? Thanx! Cell Site Name T50MB7 T73MA7 T73MA8 T73MA9 T04MV9 T04MW7 T34MK7 T34MK8 T51ME1 T51ME2 T51ME3 T04MV1 T34OR2 T34OR7 T34OR8 |
#3
|
|||
|
|||
Thanx, Elisabeth.
I figured it out yesterday. It works perfect! Sab. "Elisabeth" wrote: Sabrina, you can use the VLOOKUP formula to fill in your Site Names in Worksheet B. Example: =VLOOKUP(A2,Sheet1!$A$2:$B$5,2,FALSE) A2 would be the first Cell in Worksheet B Sheet1!$A$2:$B$5 would be the complete list (range) in Worksheet A 2 represents the column number of the data you are "calling" from Worksheet A FALSE setting allows you to get correct results if your range in Worksheet A isn't sorted in ascending order Excel's help system does a pretty good job of explaining how to use the VLOOKUP formula as does several Excel books out there. Hope this helps! -- Elisabeth "Sabrina" wrote: Here is my case: I already have 2 worksheets both include 2 columns: Cell & Site Name. WorkSheet A includes all the cells and site names; WorkSheet B includes only a small portion of Cells. Now what I need to do is to get the site name for each cell in worksheet B. I don't want to manually copy & paste. Is there any way to speed up? Thanx! Cell Site Name T50MB7 T73MA7 T73MA8 T73MA9 T04MV9 T04MW7 T34MK7 T34MK8 T51ME1 T51ME2 T51ME3 T04MV1 T34OR2 T34OR7 T34OR8 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
URGENT Please... new worksheet with copied formats but no data. | Excel Worksheet Functions |