I would like to create a "Export Data" button to export information from my "Calculations" sheet to my "Summary" sheet, and fill out the table.
Calculations - Sheet One
Green fields support data entry
Orange fields are formula cells
White fields are simply units of measurement
Reset Calc button simply resets Green Fields
I would like to export the data from the green and orange fields in the "Calculations" sheet into the "Summary" sheet and fill out the certain fields as highlighted. I have filled out the cells with the cell number that it needs to be populated from the "Calculations" sheet. I also would like it to add the unit of measurement to the result, if we can add that to the code?
I also have numerous calculations to add to the table, so I have to export/reset/export the results into the Summary Table to then be able to print out a spreadsheet of results. So I need to be able to export to the table and then have it export new calculations below the previous calculated results. I dont know if there can be a code to simply 'insert data at next blank cell'? I have added a "Antenna Number" data entry cell in my calculation sheet, in the hope that it may help this problem -
eg: Enter data "Antenna Number 1" > Export Data > Data is filled in rows 3 and 4 for Antenna 1
"Antenna Number 2" > Export Data > Data is filled in rows 5 and 6 for Antenna 2 and so on
*another idea might be to export data to the summary sheet, and then insert 2 new rows, so it essentially exports into the "same" 2 rows, but the data just gets bumped down.
Finally I will then add a "Reset All" button to clear calculations and summary sheets with a confirmation before doing so, but this should be easy enough.
Thank You
Calc Sheet.png
Summary Sheet.png
Bookmarks