buckyswider
New Member
- Joined
- Feb 25, 2009
- Messages
- 18
Hi all, another question where I've spent a couple hours on research but still fell a little short of my goal...
I'm doing an inventory spreadsheet for fire gear. One row per piece of equipment for different things like serial number, size, etc.
I would like to add a pushbutton control for inventory purposes. So say column C has a button control 'Inventory' or something like that. When that button is clicked/pushed (would be much easier to perform inventory on a tablet), it places the current date in the adjacent column "D". So at a glance we can tell the last time something was accounted for. Will also create a corresponding pair of columns for for a "Clean" date. (Goal would be to add conditional formatting to the date columns so we can easily tell when something has been accounted for or cleaned in a while; if it hasn't been cleaned in more than a year the cell turns red, etc.).
I also want to be able to make this a cell property- so when we add a new piece of equipment we just need to copy an existing row.
The only way I can figure out how to do it now is with an Active X control. And I can only get the date to appear in the "last clicked" cell, not a fixed point (i.e. the adjacent cell), and it also does not copy when I copy the row it is in.
is this doable? Thanks!
I'm doing an inventory spreadsheet for fire gear. One row per piece of equipment for different things like serial number, size, etc.
I would like to add a pushbutton control for inventory purposes. So say column C has a button control 'Inventory' or something like that. When that button is clicked/pushed (would be much easier to perform inventory on a tablet), it places the current date in the adjacent column "D". So at a glance we can tell the last time something was accounted for. Will also create a corresponding pair of columns for for a "Clean" date. (Goal would be to add conditional formatting to the date columns so we can easily tell when something has been accounted for or cleaned in a while; if it hasn't been cleaned in more than a year the cell turns red, etc.).
I also want to be able to make this a cell property- so when we add a new piece of equipment we just need to copy an existing row.
The only way I can figure out how to do it now is with an Active X control. And I can only get the date to appear in the "last clicked" cell, not a fixed point (i.e. the adjacent cell), and it also does not copy when I copy the row it is in.
is this doable? Thanks!