LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 161
Default Mirror data in two sheets

I want the data in Sheet1 and Sheet2 to mirror
each other, but only in the range of A1:C10.

So, if someone types "apple" on Sheet1 in cell A1,
I want "apple" to automatically populate cell A1
in Sheet2 (or vice versa).

How can this be achieved? (I hope this doesn't
create an infinite loop situation where data constantly
gets copied back and forth between both sheets)





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
synchronizing mutiple sheets to mirror the previous data FEMoore Excel Discussion (Misc queries) 0 October 10th 10 03:49 PM
Sheets that mirror each other.... Robert Crandal Excel Programming 2 December 23rd 09 10:16 AM
Problem with sheets that mirror each other Robert Crandal Excel Programming 10 December 12th 09 03:46 PM
sheets that mirror each other Robert Crandal Excel Programming 8 December 5th 09 01:54 PM
How do you mirror data and formatting in Excel '03 Jorg Excel Worksheet Functions 1 August 1st 07 03:36 PM


All times are GMT +1. The time now is 08:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"