I very much need some help with my current project as my knowledge of excel is limited.

I have been asked to create a spreadsheet for a survey.

I have a dropdown table where the surveyor can choose from each column, however, I need the sheet to insert the formulated rows as per the sites number of power points i.e. Site 1 has 45 points so will need 45 rows inserted automatically to be completed.  Site 2 has 13 point so 13 rows and so on.

I also need the number of points to be quite high depending on building size so could go into the hundreds.

I also need a total at the bottom of one of the columns.

As the table above shows, the total AP’s for this particular site is 63 which is a v lookup of a job number.  I need 63 rows then inserted as per row 2.  Row 1 shows the information already selected that the surveyor will choose from the dropdowns.

Is this possible?

Many thanks

Nicki

​I very much need some help with my current project as my knowledge of excel is limited. I have been asked to create a spreadsheet for a survey. I have a dropdown table where the surveyor can choose from each column, however, I need the sheet to insert the formulated rows as per the sites number of power points i.e. Site 1 has 45 points so will need 45 rows inserted automatically to be completed.  Site 2 has 13 point so 13 rows and so on.I also need the number of points to be quite high depending on building size so could go into the hundreds.I also need a total at the bottom of one of the columns.As the table above shows, the total AP’s for this particular site is 63 which is a v lookup of a job number.  I need 63 rows then inserted as per row 2.  Row 1 shows the information already selected that the surveyor will choose from the dropdowns. Is this possible?Many thanksNicki  Read More

​