to link formula between sheet

4me1956 · #1 10-15-2006, 06:07 PM

Please help
In Sheet1, C1 has a formula A1+B1, i would like the same to copy to C1 in sheet2 refering to A1 and B1 in Sheet1. Any new value of A1 or B1 in Sheet 1 should be reflected in C1 Sheet2.

Thanks

**davesexcel** · #2 10-16-2006, 04:06 AM

Code:

=Sheet1!$A$1+Sheet1!$B$1

4me1956 · #3 10-16-2006, 10:47 AM

Thanks Dave. Thats very helpful

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)