Stat Sheet

[jgarth]

I'm creating a stat sheet that automatically populates transactions for employees, and they can update status. The issue I'm running into is when they are selecting that the file is completed, I can't get a macro to detect which ones are done and which ones aren't to clear them out of the que. What type of macro/vb would I need to write to get this outcome.

Thanks.

 

[goldfish]

Hi Jgarth, Welcome to the Boards!

Sorry no one has answered you question sooner, but they are probably having the same problems I have in understanding specifically what your desired outcome is. Can you describe the layout of your sheet? Which cells have the Status? What value represents ones that "are not done"? What action do you want to happen when a when a status is update? Do you want it to hide that row? Or delete that row? Do you want this to happen immediatly after the status has been updated (like a change event macro) or when the user hits a button? or when the spreadsheet is closed? or saved?

This sounds quite possible I just don't know how to answer you any better with the amount of information you've given.

~Gold Fish