+ Reply to Thread
Results 1 to 8 of 8

Create button to Export cell Data to new table.

  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.

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,082

    Re: Create button to Export cell Data to new table.

    I can't promise a working solution but it would be easier to help if you could attach a copy of the file instead of pictures. This would make it easier to test a possible solution.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

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

    Re: Create button to Export cell Data to new table.

    Have added a copy of the file to the original post. Thanks.

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,082

    Re: Create button to Export cell Data to new table.

    What is the password to unprotect the "Calculations" sheet.

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

    Re: Create button to Export cell Data to new table.

    You shouldn't need to change the calculations sheet, if you would like to test it for data entry/ export, simply enter numbers into the green fields and the rest will be populated.

  6. #6
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,082

    Re: Create button to Export cell Data to new table.

    Assign the macro in Module2 of the attached file to the "Export Data" button.
    Attached Files Attached Files

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

    Re: Create button to Export cell Data to new table.

    Hahahaha that is amazing, thank you so much Mumps, I'll have to review your code to see how you did that. Amazing! Thanks again.

    Also figured out I can add the units of measurement in Cell Formating Options. Custom - Eg 0.00 "m". Makes things a little easier code wise.
    Last edited by balsac; 04-02-2018 at 09:00 PM.

  8. #8
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,082

    Re: Create button to Export cell Data to new table.

    You are very welcome.

+ Reply to Thread

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