After "=A1" what do you do next?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to take information from one spreadsheet to another. After using
"=A1" on one spreadsheet and the code being put on the second spreadsheet,
how do you get the information to actually "merge" 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

|I am trying to take information from one spreadsheet to another. After using
| "=A1" on one spreadsheet and the code being put on the second spreadsheet,
| how do you get the information to actually "merge" 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.
 
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
 
Back
Top