I came across this and can probably use it, but need some additional clarification. When you put ''Select which cells you want the macro to run" Can you please clarify format? I have 7 worksheets that contain the same information, but for different people.