+ Reply to Thread
Results 1 to 2 of 2

update details on one tab from another tab in same book

  1. #1
    Registered User
    Join Date
    02-29-2012
    Location
    UK, Newcastle
    MS-Off Ver
    Office 365
    Posts
    97

    update details on one tab from another tab in same book

    Hi I have a spreadsheet that has many cells to be updated by different departments. The full spreadsheet is in the final tab(sheet). I would like to create several other tabs which will be specific to each department. For example cells A to H will be completed by department X. I was hoping I could simply copy cells A to H from the main sheet to the sheet specific to department X and then apply some kind of link whereby all the data added on sheet X would copy to the main sheet. I would do the same for each department and then once working somehow make the main sheet read only with each department having a password for their own sheet thus only them being able to update. Any help in achieving this would be greatly appreciated.

  2. #2
    Registered User
    Join Date
    02-29-2012
    Location
    UK, Newcastle
    MS-Off Ver
    Office 365
    Posts
    97

    oops why does my issue say solved

    Can not remove solved status on above problem

+ 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