SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Strategies & Market Trends : A.I.M Users Group Bulletin Board -- Ignore unavailable to you. Want to Upgrade?


To: The Philosopher who wrote (7233)4/12/1999 6:02:00 PM
From: Dataminer1  Respond to of 18928
 
OT >>Does anybody know how I can set up a second sheet on an Excel spreadsheet so that when I add a line on the first sheet, it automatically adds the same line on the second sheet?<<

I hope I understand the question correctly....
A simple formula on the second sheet will display whatever information you enter into the corresponding cell on the first sheet.

For instance, if the first sheet is called "page1" and you want whatever you type into cell A1 to show up on the second sheet in cell X1, the formula in X1 on the second sheet would be =page1!A1

Hope this helps. If you need clarification or if I missed the boat completely, please send private mail and I will try to help.

Regards,
Bill