Finding information between two cells

Hi,

The problem I have is that I have auditors checking every location in a warehouse and recording this as a from / to location figure. I need Excel to read between these two ranges and record the locations concerned as checked on another sheet!

More information on the attached.

Thanks in advance.

Dave

Your location ranges include letters. You would need to provide an explanation of exactly how these rows progress so that we could create a formula to check this.

Originally Posted by flex

Your location ranges include letters. You would need to provide an explanation of exactly how these rows progress so that we could create a formula to check this.

Each aisle (1-60) starts 050 (aisle no. of two digits from 04 - 60) (01 A01 - HO2 60 A01 - H60).

Example: 050 04 05 F02

Hope this helps

Regards
Dave