I have what I call a job database that contains all kinds of job data about various projects. Each job has a number assigned to it that corresponds with the row it's in. I want to have various screens which allows the user to view a list that automatically changes based on what stage each job is in. For example if it is a new job the status would be"job lead" Then an icon, text box or whatever would be on the "job lead screen" When the user schedules a meeting with the client. That icon or text box would disappear from the job lead screen and would be on the "to meet screen" After the user meets with the client, the icon would move on to the "to review" screen and so on.

I was thinking of using another separate worksheet to have the phases or statuses across the columns and when a user completes a phase they press a button that runs a macro that advances the progression. Naturally the order of progression would be contingent on various circumstances and options chosen. The job icon needs to be a macro to return the original job number so that relevant job data for that phase can be rotated into cells on a screen set up to aid the user in carrying out the next step in the series.

So I guess my question is simply, how do I make a macro that creates a button(icon) that has a macro that grabs the currently loaded job # from a cell so that when that button is pressed it will recall that job #The rest of the macro I could probably figure out.

I doubt I'm making any sense to anyone.

I'm just in over my head. Any help would be appreciated.