troubleshooting Question

Validations Required on Excel Spreadsheet

Avatar of Steve B
Steve BFlag for Australia asked on
Microsoft ExcelSpreadsheetsVB Script
16 Comments1 Solution676 ViewsLast Modified:
I have a spreadsheet that has had a few macros added to it by one of the amazing experts on the site.  

What I require are the following validations to occur.

In Column E, F and M it often will have different values inserted into them, so they do not need to be equal.  

Column M again will often have a separate value to column E or column F to determine the charge.  The value in Column M is based on the following factors and they are ...

1

If column C contains the letter E,

THEN

2

Column E has the value INTERNATIONAL or DOMESTIC, then the value in column M will be equal to the value in Column F and the charge will be based on the value of column F.

ELSE

3

If column F has the value of INTERNATIONAL or DOMESTIC, then the value in column M will be equal to the value in column E and the charge will be based on the value of column E.



I hope the above makes sense.

With regards to column R, T, V, X and Z, the list of values that should appear there can be found in the Worksheet "Zones + Tolls" column D and column G.


The values found or to be used are all in the worksheet "Zones + Tolls".

I hope this all makes sense.
01-Invoice-Template-blank.xls
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 16 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 16 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