F
famdamly
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.
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.