troubleshooting Question

Aggregate several small Actions (Searching, Summing etc.) into a VBA Code

Avatar of Andreas Hermle
Andreas HermleFlag for Germany asked on
Microsoft ExcelVisual Basic Classic
8 Comments1 Solution137 ViewsLast Modified:
Dear Experts:

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.

Regards, Andreas
Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros