close

I would like to be able to enter data on sheet 1, and also into another cell
on a different sheet with a different layout at the same time. Is this
possible? I am not too good on excel so step by step guide for idiots would
be appreciated.

Maybe just reference it
in sheet 1A1 you will enter the value

In Sheet2B4 enter this
=Sheet1!A1

Nopw sheet2B4 will always change when you change SHeet1A1You could do it with a link =sheet2!a2 or a worksheet_change event macro.

--
Don Guillett
SalesAid Software

quot;Alanquot; gt; wrote in message
...
gt;I would like to be able to enter data on sheet 1, and also into another
gt;cell
gt; on a different sheet with a different layout at the same time. Is this
gt; possible? I am not too good on excel so step by step guide for idiots
gt; would
gt; be appreciated.

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()