| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pulling data from one worksheet onto another
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 -- Paul G Software engineer. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
pulling data from one worksheet onto another
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!! "Paul" wrote: 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 -- Paul G Software engineer. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
pulling data from one worksheet onto another
thanks it worked!
-- Paul G Software engineer. "Pranav Vaidya" wrote: 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!! "Paul" wrote: 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 -- Paul G Software engineer. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling data into today's worksheet from yesterday's worksheet | Excel Discussion (Misc queries) | |||
| Pulling data through to another worksheet | New Users to Excel | |||
| Pulling data from one worksheet to another | Excel Programming | |||
| Pulling data from one worksheet to another | Excel Worksheet Functions | |||
| Pulling data from different worksheet | Excel Programming | |||
Hybrid Mode
