Update sheets frm master

[Cpinhey]

I have a master 'all office' worksheet where all data for all offices is entered, there are 15 offices that each have a sheet containing the same data pertaining to the individual office as that on the 'all office' sheet.

Up until now I've been using a series of VLookups to update the individual office sheets. But, it is now necessary to start adding new records to the the master 'all office' spreadsheet. Is there an easy way to ensure that whatever data is entered on the 'all office' sheet is copied to the appropriate office sheet. There is a column for 'office' on all sheets.

For example, I enter a new row of data for office AA on the 'all office' master sheet. I would like the sheet for office AA to automatically update with the new additional data from the master 'all office' sheet.

Any suggestions? This can be done manually, but I figured there's no harm in asking if there is a better way.

 

[Sthrncali]

Looks like this line..

Set myRange = Worksheets("Master Sheet").Range("C[B][COLOR=red]:C[/COLOR][/B]") 'This should be the Col that contains Office Location Names.