Discussion: Calculating the meters in a warehouse

Hi, I'm currently working on a project where I'll be calculating the meters of a warehouse. A nice project that I will probably need VBA for. My idea is to translate the layout of the warehouse in Excel to square meters. Each cell will represent a specific square meter. Each cell will also receive a unique code (both rack and storage location).
What I would like to do is that I  want to calculate all running meters from storage location to storage location with the help of a VBA script. The script must also meet certain conditions (for example, the walking line may not run through racks, but pallets may be placed in succession again in the same department.

Now I'm learning VBA and I'm curious how you view this project. Do you think it is possible to calculate the meters based on the cells?

See the examples in the figures below:
Figure 1: Example of warehouse
Figure 2: Walking line in warehouse

figure I
figure II
Kind regards,

Pim