troubleshooting Question

Offset Variables in Formulas Excel Macro VBA 2010

Avatar of kev-griggs
kev-griggsFlag for Afghanistan asked on
Microsoft ExcelSpreadsheetsVB Script
9 Comments1 Solution438 ViewsLast Modified:
Hi,

I have an excel spreadsheet (see attached) where I need to loop through each row looking at the value in 'G' (starting at G4).

What I would like it to do is monitor the times taken in the 6 different sections, so based on the entry in there (i.e. 'G1') look to the values on Sheet 2 (in column A), match it, and put the date in column X minus the relevant amount of days in each column.

For Example, because cell G4 = 'G1', the value for L4 (Panels) will be X4 -1-1-7-5-6-10 (all the sections on sheet 2 corresponding to G1, and then M4 (In Rig) will be X4 -1-1-7-5-6 but not the 10 as the panels takes 10 days according to the test values in sheet 2.

Lastly, I only want this to be applied if the values in L,M,N,O,V and W are blank (as we will replace with percentages when they are in the relevant sections and X's when they are completed and moved on).


Would be grateful for any pointers, I have attempted an offset and a loop method but this hasn't been successful.

Regards,
Ben
Test.xlsm
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 9 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 9 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