MrExcel.com - Your One Stop for Excel Tips & Solutions

Help With MS Excel 2000

Posted by Aaron on May 03, 2001 10:44 AM

I am trying make an entry on sheet one and the information automatically be entered on the second, third, fourth, and fifth sheet without having to have to copy and paste to each sheet. if you know how to do this function please help.

Aaron

Posted by JooBoe on May 03, 2001 10:49 AM

let say u want to make A1 in sheet1 appear in
A1 in sheet2


go to sheet2..in cell A1..type =..then go to
sheet1..click to cell A1..the enter

Posted by Gregc on May 03, 2001 11:59 AM

You can hit ctrl and then select the sheet tabs of the sheets you want the information to be duplicated on and then type what you want on sheet1 and the values will appear in the same cell on all the highlighted sheets.

GREG