Forum Discussion
Re: How do Count how many shapes are on a sheet?
you are welcome. you can post your excel here if you want to.
5 Replies
Hello again on thank you very much for your help.
As you come see we are trying to do some architectural work in an Excel sheet. We were supposed to be using AutoCAD but as we are full supporters of Excel we are trying to do it for the first time in this worksheet.
We are trying to measure in each floor how many items are we going to use so that it could be linked to another sheet were prices per item with give us the amount of material used.
When we tried to count the shapes it is a bit difficult for us to distinguish how many items per flat we do need. If you look into columns K&L you can have an idea of what we are trying to measure exactly. I wonder if you could help us to obtain in column M the number of items per floor.
All the best!
- Hi juan,
I looked at your file and if you have used the built-in Excel shapes or at least your objects were drawings and not picture, then what you have asked was easy.
Now, the complication starts when your objects are not drawing/shapes but they are picture objects and hence we cannot identify them by object type based on how it looks.
If you are willing to work with non-picture objects, then I can write some function that can count based on each room next to the each icon.Dear friend,
I hope you are fine. we have reviewed the excel to assign shapes to all items we would like to count instead of mixing images and shapes. Even though some of them are still marked with an image. The image will serve to guide us from a visual point of view. However the shapes can give us an idea of how many items will have to count.
It would be fantastic if we could make a macro that counts the items per floor. We have tried to do the plans separated so that the surface could be the limited for each floor.
In columns K and L you have the shapes that we would like to count.
Please feel free to send us any suggestion that could facilitate the macro to be made. Also if you just make an example for the first floor, we could copy it for the following floor just changing the area to be counted.
Thank you very much in advance, Juan
