Hi - I am looking for a flash of inspiration if possible.
I have a spreadsheet where I need to calculate a field in the Active Row(always in the same column). This is an ongoing spreadsheet and records will be continually added and, as a consequence, the relevant field will require calculation.
For background :
There are 2 sheets - Sheet1 & Sheet2
Sheet1 contains the data
Sheet2 contains the "fixed rate info"
Sheet1 - Column "C" (3) contains the "Hours" e.g. 3 or 1.5 or 5 etc......
The Fixed rate info ( e.g. 50 per hour) is stored in Sheet2 Column "F" - Row 6
The calculation total is stored in Sheet1 - Column "E" (5) - Hours * Rate per hour.
The calculation, ideally, should take place at the time the number of hours is entered on the current row.
I am struggling to find the code I need to enter to achieve this - and also where the script needs to be placed within VBA - Sub / Private Sub / Module / Sheet etc.
You may have gathered I am new to this and trying to find my way.
Many thanks for any help anyone can give.
I have a spreadsheet where I need to calculate a field in the Active Row(always in the same column). This is an ongoing spreadsheet and records will be continually added and, as a consequence, the relevant field will require calculation.
For background :
There are 2 sheets - Sheet1 & Sheet2
Sheet1 contains the data
Sheet2 contains the "fixed rate info"
Sheet1 - Column "C" (3) contains the "Hours" e.g. 3 or 1.5 or 5 etc......
The Fixed rate info ( e.g. 50 per hour) is stored in Sheet2 Column "F" - Row 6
The calculation total is stored in Sheet1 - Column "E" (5) - Hours * Rate per hour.
The calculation, ideally, should take place at the time the number of hours is entered on the current row.
I am struggling to find the code I need to enter to achieve this - and also where the script needs to be placed within VBA - Sub / Private Sub / Module / Sheet etc.
You may have gathered I am new to this and trying to find my way.
Many thanks for any help anyone can give.
