Same principle.
You can also type the formula:

=[WorkbookA]SheetA!A1

--
Kind regards,

Niek Otten

"rajesh" wrote in message
...
Thanks Neik,

What about transfering data a cell in a worksheet in workbook A to Work B

"Niek Otten" wrote:

Select the cell on worksheet B where you want the value.
Press the "=" key
mouse-click the tab of worksheet A and then the cell where the original
value is. Press ENTER

Ready?

--
Kind regards,

Niek Otten

"rajesh" wrote in message
...
Hello all,

I would like to transfer a calculated figure in a cell on worksheet A
to
worksheet B. I would like this done automaticaly maybe using macro or
formula
etc.. can any one URGENTLY HELP please