+ Reply to Thread
Results 1 to 1 of 1

Moving Data from one excel 2016 worksheet to a excel 2010 worksheet

  1. #1
    Registered User
    Join Date
    03-01-2014
    Location
    Norwich
    MS-Off Ver
    Excel 2016
    Posts
    15

    Moving Data from one excel 2016 worksheet to a excel 2010 worksheet

    Hi hope you can help. i have 2 excel spreadsheets one in excel 2016 for home use and one a 2010 version as a work copy. i keep records of my medical condition and have the information as a table as i have pivot tables and charts to populate my dashboard. The image on the left is the 2016 version and i enter data in rows A-J when i am at home and the update macro updates my dashboard, and use the right hand version when i am at work.
    What i would like to do is update both sheets automatically but as you can imagine if i enter data in the next row it will be Jun 15 1Breakfast the my medical data. i then press the update macro which updates the 2016 version. when i go to work i would then enter the data in the 2010 version for my lunch, afternoon etc. is there a way to update both spreadsheets automatically.
    Thanks in advance.
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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