importing/exporting data

[helpjennifer]

I need to export data from 1 worksheet into another worksheet. When I use the "!" in the formula do I need to insert the "!" everytime I type she sheet name into the formula? Is there an easier way?

 

[shajueasow]

Welcome to the board.
You need to do so.
Otherwise just put an "=" sign in the worksheet where you need the data and then select the cell in the sheet where the data now is.
ie, if you want Sheet1!A5 value in Sheet2! B7, then put an = sign in Sheet2!B7 and select Sheet1!A5 and hit ENTER.

 

[helpjennifer]

Thanks so much!