+ Reply to Thread
Results 1 to 2 of 2

linked sheets update both ways

  1. 10-21-2008, 05:34 PM #1
    sharronbrowne
    sharronbrowne is offline
    Registered User
    Join Date
    10-12-2008
    Location
    wgtn
    Posts
    15

    linked sheets update both ways

    Is it possible to have 2 sheets in the same workbook that will update the data both ways.

    For instance:

    My Monday sheet having all the data for all staff hours, and My Sharron Sheet having only the data for Sharrons hours.

    If I edit the data on the Monday sheet it will show up in the Sharron sheet and if I edit the data in the Sharron sheet it will show up in the Monday sheet.

    Or should I create a form that shows the Sharron Data with the source being the Monday, Tuesday, Wednesday, Thursday, Friday Sheets? So that the form will enable me to see just Sharrons data on each of the Monday, Tuesday, Wednesday, Thursday, Friday sheets.
    Reply With QuoteRegister To Reply
  2. 10-22-2008, 04:51 AM #2
    EdMac
    EdMac is offline
    Forum Contributor EdMac's Avatar
    Join Date
    01-23-2006
    Location
    Exeter, UK
    MS-Off Ver
    2003
    Posts
    1,264
    Hi Sharron,

    You can't get it to work both ways, I'm afraid - you will have to find another solution.

    If you post an example of what you want to achieve, we may be able to help.
    Ed
    _____________________________
    Always learning, but never enough!
    _____________________________
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1