Results 1 to 8 of 8

Create button to Export cell Data to new table.

Threaded View

  1. #1
    Registered User
    Join Date
    07-18-2016
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    7

    Create button to Export cell Data to new table.

    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
    Attached Files Attached Files
    Last edited by balsac; 04-01-2018 at 04:58 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Log in website, navigate trough menu, insert data, click button, export table
    By 323428 in forum Excel Programming / VBA / Macros
    Replies: 38
    Last Post: 10-21-2017, 06:51 PM
  2. Trying to Export Data to another Worksheet with Button
    By njr522 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-15-2014, 06:23 PM
  3. [SOLVED] Create button to save cell data to workbook header
    By tailz in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-28-2013, 07:06 AM
  4. Replies: 1
    Last Post: 09-08-2012, 04:04 PM
  5. Export Excel data into Access table - overwrite table data
    By Jonsocks in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-08-2012, 12:05 PM
  6. Create a new table from the main table when user press Enter button
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2010, 05:08 AM
  7. Export data from Excel to Word doc using button
    By starkjr in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-13-2010, 11:29 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1