+ Reply to Thread
Results 1 to 2 of 2

Adding and deleting to a list from two different workbooks.

  1. #1
    Forum Contributor
    Join Date
    05-20-2013
    Location
    Ann Arbor, MI
    MS-Off Ver
    Excel 2010
    Posts
    255

    Adding and deleting to a list from two different workbooks.

    Hello,

    So I have two workbooks that I am using. They both contain sheets that are for 'READ ONLY' purposes, but can only be changed from macros.
    I have one workbook that is only accessible to certain users and another workbook accessible to other users. I currently have a macro that adds and deletes to a certain column in the read only sheet by unprotecting it and then protecting it. Is there a way to add and delete to both workbooks whenever an item is added from either workbook?

    Here is the code that I am using just for the macro to add to the workbook in which it belongs to:
    Please Login or Register  to view this content.
    and the code to delete items:
    Please Login or Register  to view this content.
    This code belongs to my work book: "data"

    and I want it to sync with my other work book "MillSteel-Reports"

    I have attached the workbooks:

    Passwords for the read only sheets are "123steel"
    and password for the MillSteel-Report Workbook is "steel123"

    My question might not be too clear, so my apologies in advance

    Please Help
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    05-20-2013
    Location
    Ann Arbor, MI
    MS-Off Ver
    Excel 2010
    Posts
    255

    Re: Adding and deleting to a list from two different workbooks.

    BUMP- no responses.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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