Results 1 to 4 of 4
  1. #1
    Little Mike is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    May 2016
    Location
    Hookerton, NC
    Posts
    2

    Question Moving data between sheets in the same workbook

    I have a workbook with seven sheets. Is it possible to have data that has been entered into a specific cell, say on sheet 2, automatically fill a cell on cell 7? I know I can cut and paste, which is what I've been doing, but there has to be a better way, isn't there?

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    you've asked an excel question in an access forum, so a bit confused on what you are asking. In excel you would just have a formula in another sheet which refers to the cell on sheet 2 - e.g.

    =sheet2!A1

  3. #3
    Little Mike is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    May 2016
    Location
    Hookerton, NC
    Posts
    2
    Quote Originally Posted by Ajax View Post
    you've asked an excel question in an access forum, so a bit confused on what you are asking. In excel you would just have a formula in another sheet which refers to the cell on sheet 2 - e.g.

    =sheet2!A1
    I apologise Ajax, I thought? I was in the correct forum. Thank you for your reply.

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    so long as you have your answer!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 10-15-2014, 12:30 PM
  2. Replies: 1
    Last Post: 08-08-2013, 03:54 PM
  3. Replies: 1
    Last Post: 02-03-2013, 11:25 PM
  4. Replies: 2
    Last Post: 08-14-2012, 04:24 AM
  5. Exporting Queries to Excel Sheets, 1 Student per Workbook
    By StudentTeacher in forum Programming
    Replies: 8
    Last Post: 09-02-2010, 11:48 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums