pulling data from one worksheet onto another

[Guest]

Hi just wondering if anyone knows if there is an easy way to pull information
from 3 cells on one worksheet into a singe cell on another worksheet?
wondering if I should use a macro or cell formula?
thanks

 

[Guest]

Hi Paul,

Not very sure if your cells contain text or numbers or both. Here's how you
can do this
Assuming the cells are A1, B1 and C1 on Sheet1 and you want them to be
clubed in cell A1 on Sheet2. Type the below formula in cell A1 on Sheet2

=Sheet1!A1 &" "& Sheet1!B1 &" "& Sheet1!C1

& is used to join the srings. I have just added extra space between the
strings.
You refer to cells as <sheet name>!<cell address> for eaxmple Sheet1!A1

Hope this helps!!

 

[Guest]

thanks it worked!
--
Paul G
Software engineer.

Hi Paul,

Not very sure if your cells contain text or numbers or both. Here's how you
can do this
Assuming the cells are A1, B1 and C1 on Sheet1 and you want them to be
clubed in cell A1 on Sheet2. Type the below formula in cell A1 on Sheet2

=Sheet1!A1 &" "& Sheet1!B1 &" "& Sheet1!C1

& is used to join the srings. I have just added extra space between the
strings.
You refer to cells as <sheet name>!<cell address> for eaxmple Sheet1!A1

Hope this helps!!

--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!