cell contents from one page to another

Microsoft Microsoft excel 2007 full vers...
June 14, 2010 at 21:03:21
Specs: Windows XP
A friend would like to be able to automatically have cell contents from one page be entered in cells on another page. As simply as possible how is this done.

See More: cell contents from one page to another

Report •


#1
June 14, 2010 at 21:27:03
Try this:

On sheet 2, cell A1 enter the formula: =Sheet1!A1

On sheet 1, cell A1 enter text string ABCDEF

What ever you enter in Cell A1 on Sheet 1
will automatically appear in Cell A1 on Sheet 2

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question