I wonder whether some expert could help me write this VBA code.
If F8 of the 'TecData' worksheet of the currently open workbook = "" Then exit sub
If F8 of the 'TecData' worksheet <> "", Then grab the contents of F29 of the'TechData' worksheet and search that cell contents in Row 5 of the Worksheet 'Workshop'.
If that Search Term is not found in Row 5 of the worksheet 'Workshop', a MsgBox 'Date not found' is to pop up and the macro is to exit
If the Search Term is found in Row 5 of the worksheet 'Workshop', select that cell and perform the following intersection action …
=OFFSET($A$1,ROW(A24)-1,COLUMN('Cell Reference of the previously Selected Cell')-1)
The cell of that intersection action is to be selected (Lets call this cell 'Intersection Cell')
Grab the cell contents of F8 of the 'TecData' worksheet and add (summing up) that figure to the cell contents of the Intersection Cell (Worksheet 'Workshop')
Help is much appreciated. Thank you very much in advance.