Hi All.
I am looking for some guidance on the best foot forward. I have been working on a sheet that sorts material calculations for what feels like forever now. The jist of the sheet is thus.
Design software (for architecture) exports a set of values for each floor of a building as CSV. We have vba bring those values in to sheets labeled GF 1F 2F and so on..
I have created a set of calculations are then carried out by pulling the required values into the sheet, and and a report of each material is given on a sheet called all floors.
I have thus far, 1 set of calculations that from time to time need tweaked. i.e a materials stock size could change. This is working and i have the based this on the ground floor inputs so all the formula are =!GF "xyz ".
My first thought was to create a base calculation sheet for the ground floor, and then copy this sheet and use find and select to replace all !GF with "1F and copy the column across in the results sheet and do the same it does the next floor up. I foresee this becoming a bit of a nightmare to manage though. there are a lot of calculations, and multiplying this sheet by 5 floors of the building might get cumbersome.
I suppose i am asking, is there a better way to do this. I am not very good at VBA. I can get by with basic stuff..
Hope that is clear and as always, I appreciate any and all advice given. Screenshot of the results sheet for a some context. this shows values based on the calcs sheet GF, as that's all I have done thus far. Very excited to see the thoughts on here.
Bookmarks