Thread: [Solved] copy a cell from 1 file to another when data changes
View Single Post
 
Old 01-20-2016, 09:06 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,344
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
I have given you two:
• An annual Find & Replace; or
• Consolidate the data into a single workbook.
The latter is the better long-term solution.

You're free to ignore the advice, but kindly don't say the answers "don't give me any kind of solution" just because what you're offered isn't exactly what you want. Wanting something doesn't automatically mean it can be done in the way you want it.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote