Autopopulation

[Chaddyb]

I manage projects. I have a Workbook with a master sheet i named details. I want excel to populate a sheet called savings every time i change the project status on the details sheet to Completed. is there anyway to do this?

 

[Chaddyb]

It's designed to run automatically, whenever you type the word complete into col H

Wow thanks so much it works

 

[Fluff]

Glad to help & thanks for the feedback