glockgal42
New Member
- Joined
- Dec 15, 2016
- Messages
- 5
So I have three sheets "Yard", "Available spaces", and "Yard configurations"
If cells in Column K of "Yard configurations" equals Yes, and Cells in column B in "Yard configurations" equals ParkingLocation then use text in Column C of "Yard configurations" to find the same text in column A of "Yard" and count the blanks in column B of "Yard"
Then once the data is collected, put the number in a specific cell on "Available spaces"
Can anyone help lead me in the correct direction?
If cells in Column K of "Yard configurations" equals Yes, and Cells in column B in "Yard configurations" equals ParkingLocation then use text in Column C of "Yard configurations" to find the same text in column A of "Yard" and count the blanks in column B of "Yard"
Then once the data is collected, put the number in a specific cell on "Available spaces"
Can anyone help lead me in the correct direction?