Hey guys,
I'm new to this so will try not to sound too stupid
So I've got a worksheet with rows of cells, where I want a cell to do a specific vlookup on a preset range based on the values in other cells in that same row. Have been trying to do this with Target.offset as well a R1C1, and have it apply to a worksheet_change event, but can't quite get it right....
To give an example, heres some of the table I'm working with:
<tbody>
</tbody>
The rules are to go something like this: if Type is Labour, then Unit is HR and Item is a vlookup of the Trade on a range that gives the Item cost. Total is then just Item x Qty. Second part of what I'm wanting to do is if Type is Material, then the Work Done field would populate with a multi choice list of items specified in another range with corresponding Item values etc, and the same calculations take place. So in the end you can just fill out each row with everything that was done and/or purchased.
I'm thinking it shouldn't be too hard to do this but I just don't know some of the best formulas to use in the back end to make it work. Any help I can get from a guru in this would be great
S.
I'm new to this so will try not to sound too stupid
So I've got a worksheet with rows of cells, where I want a cell to do a specific vlookup on a preset range based on the values in other cells in that same row. Have been trying to do this with Target.offset as well a R1C1, and have it apply to a worksheet_change event, but can't quite get it right.... To give an example, heres some of the table I'm working with:
| Trade | Type | Work Done | Unit | Qty | Item | Total |
| Elec | Labour | Fix | HR | 2 | $50 | $100 |
| Fibre | Material | C345 Fibre | M2 | 1 | $110 | $110 |
| Plumb | Labour | Install | HR | 2 | $40 | $80 |
<tbody>
</tbody>
The rules are to go something like this: if Type is Labour, then Unit is HR and Item is a vlookup of the Trade on a range that gives the Item cost. Total is then just Item x Qty. Second part of what I'm wanting to do is if Type is Material, then the Work Done field would populate with a multi choice list of items specified in another range with corresponding Item values etc, and the same calculations take place. So in the end you can just fill out each row with everything that was done and/or purchased.
I'm thinking it shouldn't be too hard to do this but I just don't know some of the best formulas to use in the back end to make it work. Any help I can get from a guru in this would be great
S.
