MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Display info from sheet 1 in sheet 2


Posted by tony on November 13, 2001 6:54 AM

I have information (eg:month,date,etc) that i would like to pull from sheet 1 and display in sheet 2
(example:In sheet 1, the word November appears in cell a1. I would like to have cell a1 in sheet 2 automatically populated with November as soon as i type it in a1,sheet 1).

What is formula please?

Thanks,
Tony


Posted by Paul on November 13, 2001 6:58 AM

In sheet 2 A1 put =Sheet1!A1