software

I am trying to take information from one spreadsheet to another. After using
quot;=A1quot; on one spreadsheet and the code being put on the second spreadsheet,
how do you get the information to actually quot;mergequot; to the second worksheet?

Don't enter =A1.
On the second sheet, enter the = sign. Do not hit ENTER yet. Mouse-click the tab of the other sheet and then click cell A1. Then
hit ENTER.

--
Kind regards,

Niek Otten

quot;plittlequot; gt; wrote in message news
|I am trying to take information from one spreadsheet to another. After using
| quot;=A1quot; on one spreadsheet and the code being put on the second spreadsheet,
| how do you get the information to actually quot;mergequot; to the second worksheet?
If you refer to the A1 cell in the 1st spreadsheet that number will change in
spreadsheet 2 when it changes in spreadsheet 1. If you want to just take the
that value and not have it change you will have to copy and 'paste
special'...'paste as values' . Depending on how complex and how many of
these cells you need to do this for you could record a simple macro to help
automate this.

quot;plittlequot; wrote:

gt; I am trying to take information from one spreadsheet to another. After using
gt; quot;=A1quot; on one spreadsheet and the code being put on the second spreadsheet,
gt; how do you get the information to actually quot;mergequot; to the second worksheet?

I have the codes done properly on both spreadsheets but do not understand how
to get the information to transfer over. There are three columns coming from
an eight column spreadsheet. I do not know how to do the paste special or
paste as values either. Thank you for your help

quot;Tim Mquot; wrote:

gt; If you refer to the A1 cell in the 1st spreadsheet that number will change in
gt; spreadsheet 2 when it changes in spreadsheet 1. If you want to just take the
gt; that value and not have it change you will have to copy and 'paste
gt; special'...'paste as values' . Depending on how complex and how many of
gt; these cells you need to do this for you could record a simple macro to help
gt; automate this.
gt;
gt; quot;plittlequot; wrote:
gt;
gt; gt; I am trying to take information from one spreadsheet to another. After using
gt; gt; quot;=A1quot; on one spreadsheet and the code being put on the second spreadsheet,
gt; gt; how do you get the information to actually quot;mergequot; to the second worksheet?