+ Reply to Thread
Results 1 to 3 of 3

Insert text to one file, remove that text from equivalent column in another file?

  1. #1
    Registered User
    Join Date
    08-13-2013
    Location
    Trondheim, Norway
    MS-Off Ver
    Excel 2010
    Posts
    2

    Insert text to one file, remove that text from equivalent column in another file?

    Hi forum

    Got a slight problem; I am making a "worker-plan", where you should be able to write a name on one file and have it updated (removed) from the equivalent columns on another file automatically. Here's an example with two separate projects:

    Project 1 before and after changes:
    Attachment 257366
    Attachment 257367

    Project 2 before and after changes:
    Attachment 257368
    Attachment 257369

    You can see here how I intended it to work. When one worker is moved from Project 1 to Project 2, that worker should also be removed from those weeks in Project 1. The previous worker from Project 2 should also be removed from those weeks (in Project 2).

    Are there any formulas that can make this work automatically? All week numbers will belong to the same columns in all files.

    Edit: There are 30 files that should be syncronized, not just two..
    I could also gather all files into one file with sheets, instead of having seperate files.
    Last edited by w0rmsqwert; 08-13-2013 at 08:33 AM.

  2. #2
    Forum Contributor
    Join Date
    08-14-2013
    Location
    Here and there
    MS-Off Ver
    Excel 2010
    Posts
    376

    Re: Insert text to one file, remove that text from equivalent column in another file?

    When I click on your attachments a new page opens saying your attachments are 'invalid' - please try to rectify this.
    Cheers,

  3. #3
    Registered User
    Join Date
    08-13-2013
    Location
    Trondheim, Norway
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Insert text to one file, remove that text from equivalent column in another file?

    Thank you, I'll try again;

    Project 1 before and after:
    Project 1 - before.jpg
    Project 1 - after.jpg

    Project 2 before and after:
    Project 2 - before.jpg
    Project 2 - after.jpg

+ 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. Replies: 1
    Last Post: 02-23-2013, 08:36 AM
  2. looping, Open text file, copy text, close text file
    By jwilds1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-18-2009, 05:12 PM
  3. Remove (") from a text file
    By tido in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-25-2009, 07:55 PM
  4. Macro to copy a column data to flat file or text file
    By vinaynagasani in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-01-2009, 10:56 AM
  5. Convert Each column of an excel file to new text file
    By ggalex in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-30-2007, 09:35 AM

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