Replace cell value in one spreadsheet with cell value in another spreadsheet
Posted on 2011-03-17
I have a sheet called Master Census that holds a master census of our patients and then I have another sheet that holds addendums for the month for the patients. Both sheets have columns Patient Name and Contract Amount. The patient name column of the addendum sheet uses the named range Patient_Census from the Master Census page to create a validation drop down list.
If the patient is on the addendums sheet I want to be able to copy/replace the cell value for Contract Amount on the master census sheet to the cell value for Contract Amount on the addendums sheet through use of a Macro for that patient.