View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
Posts: 833
Default transfer cell value from 1 sheet to another without copy/paste?

EXCEL 2007

Try this:-

1. In Sheet1 cell A1 I type (for example):-

hello

2. In Sheet2 cell A1 I type:-

=Sheet1!A1

This pulls in the word:-

hello

- from Sheet1 cell A1.

There are other ways to do this.

If my comments have helped please hit Yes.

Thanks.



"sbmiller" wrote:

I need to enter a value 1 time and have it appear on additional sheets,
without copying and pasting to other sheets. Please help. I'm trying to