I'm currently working on a project and part of it is creating a new scoping tool to assist myself and in the future colleagues.
We have a set of data (base rates) which are all on their own sheet, we then have a 'front page' which we have set to pull data from the set rates when numbered.
What I am trying to achieve is that we can input on the front sheet the rooms e.g
Preliminary items
Living room
Bedroom 1
Bathroom
And when these have been input it auto populates new sheets copying the set rates across so that the front page (scope) will then display all the items set across the relevant rooms.
Is this possible? If so how?
We have a set of data (base rates) which are all on their own sheet, we then have a 'front page' which we have set to pull data from the set rates when numbered.
What I am trying to achieve is that we can input on the front sheet the rooms e.g
Preliminary items
Living room
Bedroom 1
Bathroom
And when these have been input it auto populates new sheets copying the set rates across so that the front page (scope) will then display all the items set across the relevant rooms.
Is this possible? If so how?