| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW DO I program one worksheet to get info from another?
I am trying to setup a worksheet that grabs information from cells on another
worksheet. I have set up two worksheets that keep track of different information. I want to transfer information from one cell in worksheet one to another cell in worksheet two...and I can't seem to figure it out... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HOW DO I program one worksheet to get info from another?
One way:
Use Copy and Paste Special | Paste Link Regards Trevor "kenny" wrote in message ... I am trying to setup a worksheet that grabs information from cells on another worksheet. I have set up two worksheets that keep track of different information. I want to transfer information from one cell in worksheet one to another cell in worksheet two...and I can't seem to figure it out... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HOW DO I program one worksheet to get info from another?
You can put the sheet name in a formula to refer to another
sheet. For example, in A1 on sheet1, use =Sheet2!A1 to return the contents of A1 on sheet2. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "kenny" wrote in message ... I am trying to setup a worksheet that grabs information from cells on another worksheet. I have set up two worksheets that keep track of different information. I want to transfer information from one cell in worksheet one to another cell in worksheet two...and I can't seem to figure it out... |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HOW DO I program one worksheet to get info from another?
I can't figure out what the formula is....
"Chip Pearson" wrote: You can put the sheet name in a formula to refer to another sheet. For example, in A1 on sheet1, use =Sheet2!A1 to return the contents of A1 on sheet2. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "kenny" wrote in message ... I am trying to setup a worksheet that grabs information from cells on another worksheet. I have set up two worksheets that keep track of different information. I want to transfer information from one cell in worksheet one to another cell in worksheet two...and I can't seem to figure it out... |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HOW DO I program one worksheet to get info from another?
go to the destination sheet.
click in the cell where you want the results type and equal sign (=) no go to the source cell in the other worksheet and click in it. hit the return key the formula should be entered for you. -- Regards, Tom Ogilvy "kenny" wrote in message ... I can't figure out what the formula is.... "Chip Pearson" wrote: You can put the sheet name in a formula to refer to another sheet. For example, in A1 on sheet1, use =Sheet2!A1 to return the contents of A1 on sheet2. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "kenny" wrote in message ... I am trying to setup a worksheet that grabs information from cells on another worksheet. I have set up two worksheets that keep track of different information. I want to transfer information from one cell in worksheet one to another cell in worksheet two...and I can't seem to figure it out... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying info from worksheet to worksheet if info matches | Excel Worksheet Functions | |||
| Copied info from Excel worksheet, but pasted info won't work in fo | Excel Discussion (Misc queries) | |||
| How do I use info from an excel program and make file labels? | Setting up and Configuration of Excel | |||
| program new worksheet | Excel Programming | |||
| Repost: Looking for info on how to program a userform to use filters | Excel Programming | |||
Linear Mode
