+ 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
    Stoke on Trent
    MS-Off Ver
    Excel 2019
    Posts
    31

    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)

Similar Threads

  1. Excel 2010 how show data from another worksheet if value matches
    By pattpatt1988 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-28-2018, 06:34 AM
  2. Moving average extends beyond data - Excel 2016
    By pratto in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 06-12-2016, 12:40 AM
  3. Replies: 23
    Last Post: 12-29-2015, 05:02 PM
  4. Trying to copy an entire worksheet into a new worksheet in Excel 2010
    By pglufkin in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-15-2014, 08:44 AM
  5. Excel 2010 Macro to copy worksheet, update formula and rename worksheet
    By madmak0203 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2012, 09:18 PM
  6. Importing data from an Excel 2010 worksheet into a Word 2010 form.
    By Kuriakos in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2012, 02:49 PM

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