If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
import data from one worksheet to another
I have a worksheet with 3 columns. I need to pull data to
another sheet. For example if sheet1!b3=cat i need to pull sheet1!b1 to sheet2!a1, sheet1!b2 to sheet2!a2 and so on. Thanks for the help! |
#2
|
|||
|
|||
import data from one worksheet to another
Put this in A1 Sheet2
=IF(Sheet1!$B$3="cat",Sheet1!B1,"") copy down to A2 -- Regards, Peo Sjoblom "ckeel" wrote in message ... I have a worksheet with 3 columns. I need to pull data to another sheet. For example if sheet1!b3=cat i need to pull sheet1!b1 to sheet2!a1, sheet1!b2 to sheet2!a2 and so on. Thanks for the help! |
Thread Tools | |
Display Modes | |
|
|