dunganbrendan
New Member
- Joined
- Aug 17, 2021
- Messages
- 7
- Office Version
- 2016
- Platform
- Windows
Hello all,
I have two tables (call them Tables B and C) full of formula calculations that interpret data submitted on a customer input sheet. The customer input sheet has its own table (call this one Table A. Right now the tables each have 500 rows and the spreadsheet is 600kb. The size is not bad but to give a template to virtually all customers would mean 2500 rows in all tables which comes out to be >1mb.
We want to start the tables at 100 rows and only expand the rows of Tables B and C to the number of rows in Table A. So as a customer is entering data into row 101, I would like a row to be added to the bottom of Tables B and C and the formulas within those tables to copy down into the new row. As mentioned, some customers have >2000 entries so their documents will be heavy. But we have many customers who have <200 entries and who would do much better with a smaller template.
Most customers pull from reports instead of doing manual data entry, so it would be best if, for example, a customer uploads 800 rows full of data into Table A, Tables B and C would automatically resize to have 800 rows with formulas.
Any help or advice is greatly appreciated! Thank you!
I have two tables (call them Tables B and C) full of formula calculations that interpret data submitted on a customer input sheet. The customer input sheet has its own table (call this one Table A. Right now the tables each have 500 rows and the spreadsheet is 600kb. The size is not bad but to give a template to virtually all customers would mean 2500 rows in all tables which comes out to be >1mb.
We want to start the tables at 100 rows and only expand the rows of Tables B and C to the number of rows in Table A. So as a customer is entering data into row 101, I would like a row to be added to the bottom of Tables B and C and the formulas within those tables to copy down into the new row. As mentioned, some customers have >2000 entries so their documents will be heavy. But we have many customers who have <200 entries and who would do much better with a smaller template.
Most customers pull from reports instead of doing manual data entry, so it would be best if, for example, a customer uploads 800 rows full of data into Table A, Tables B and C would automatically resize to have 800 rows with formulas.
Any help or advice is greatly appreciated! Thank you!