Populate a cell based on conditions of other cells w/out putting a formula in the cel

Umm ok I think I have stumped you. So am I to vague? Is it possible?

Well I have never used VBA but I am at a point with Ecell that I want to learn more. Is there a place I should go to learn more, do you have any sugestions? So basically I can be comfortable with that.

You could definitely use a macro to autopopulate a cell with a variable default, depending on precedents - what we would need to do is create a macro which fires when the last cell before your key cell is populated - assuming that all other precedents were populated, we could then perform a calculation in the VBA to spit a value out onto your key cell.

This would:
Break Excel's undo functionality
Be unpredictable if your precedents weren't right
Require an uploaded example, showing the precedents (highlighting "last to be populated"), the output target and the logic of the precedent combinations and the equivalent output

CC

Data Validation won’t work in this case.
The reason I am trying this is because they forget to input the data because they go hand in hand If the employee's craft is Operator then they get Truck Rent, or if they are the Welder Foreman they get Weld Rig pay, but this information must be there when it gets to payroll because they don't care if it is standard, if the information isn't there then they don't pay it.
There are a few more standard upgrades but in the same column there could be other upgrades for different crafts. Depending on the day the crew and the upgrades could be different. So it is impossible to write an IF formula in the cells because that wouldn't allow them to type the other not so standard upgrades.
I like the VBA option I just need to do some more reading. I was hoping to get some help making it work for now while I learn a little more. The other option is to reformat the form to add an additional column only for rig and truck upgrades but that would be redundant and hard to read.
I suppose it isn't easy to understand when you haven't seen the form, but there is a lot of data in about as small of an area as possible. I don't think I can cram one more bit of information in it.
If anyone wants a copy of the form to have a crack at improving it let me know I will be happy to give you a shot.

Thank you for the suggestion though I appreciate it.

Ok I removed all of the personnel information such as names but those aren't important, I also removed the heading information to keep myself out of trouble, however most of the boxes in the heading normally contain critical info for accounting. The yellow highlighted area is where I would like to have the upgrade information if the green highlighted area meets certain criteria:

If the green area is "Operator" the yellow should be "Truck Rent"
If the green area is "Welder Foreman", "Welder Steward", or "Lead Welder" the yellow area should be "Weld Rig".

Of course any other improvements wouldn't hurt my feelings.
Thank you for looking at this!

Hi Dustin,

Although we prefer people to read the rules first... it's uncommon for someone to get picked up on the rules twice and not be a <insert appropriate expletive> - fair play.

This code needs to be inserted in the workbook code:
Alt+F11
There's a file-explorer-type view on the left - identify your workbook (in bold) within this, there are several sheets ((Sheet1) Monday, (Sheet 2) Tuesday ..etc) underneath is the workbook (ThisWorkbook) - double click it
paste code in there

Please Login or Register  to view this content.

Now test it.

Undo function is gone - this is an almost unavoidable manifestation of sheet-change macros (and avoiding it is such a monumental catastrophe of an endeavour I'm not even going to imagine you will ask me to explain it)

You can ignore the "unpredictable" comment - the situation is v. simple so it won't be a problem.

You mentioned you wanted to learn more so I have commented the code fairly heavily (very heavily for me...)

CC

OK I am a (Incert Expletive) because I can't seem to get it to work. I hit alt f11 double clicked this workbook and pasted it into the dialog box when I go back to the workbook it isn't in the list of macros to use. So I tried to create one using the name you put at the top then patsing it into the box minus the name and it will try to run it but gives me errors. am I doing this wrong?

Um... yes

If you look at the top of the code, you'll see it says:

Please Login or Register  to view this content.

Amongst other things, the private means it won't show up in your list
More to the point, Workbook_SheetChange is a special kind of macro, an on event macro, which fires automatically when something happens - in this case, when something changes on the sheet - if you read your first post, that's exactly what you asked for!

So...

I'd start with a clean version (not sure what you may have changed in the VBA) - follow the instructions again (you seemed to get that part fine). Then, where I said "Now test it." I meant, go to any of your "Work day" sheets, and type one of the job roles into a cell in A8:A30.

CC

Woot-
It works. Sorry I didn't get why it wasn't showing up, thank you for the education, You ROCK. This will save me some minor headaches in the future. Wow for something so simple you think it wouldn't take such a complicated effort to make sure these guys get paid right. Thank you again.

Hi, I used this code for another application and am wanting to make a couple of changes to apply to my workbook.... Instead of "Truck Rent" or "Weld Rig", I want it to pull the the data verbatim from another cell in the same row. Is this possible?