+ Reply to Thread
Results 1 to 3 of 3

Add Values in column And change Values in another column vs .find match function? 2007

  1. #1
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Add Values in column And change Values in another column vs .find match function? 2007

    Good morning,

    I will try to explain this best to my knowledge. I have a worksheet that will work as a report. This report will be based on Contracts. In one file (Physical) I can have multiple contracts. All linked to the same file number.

    Example if file number 1234-45678 as 2 contracts then my code will automatically add the information required, adding 2 contracts for file number 1234-45678.
    Therefore my initial row 5 (Example only) will add a new row underneath and will add the following information:

    A5-1234-45678 B5-002 C5-1234-45678/001/HS
    A6-1234-45678 B6-002 C6-1234-45678/002/HS

    So my column A will always be the same linking the 2 contracts. 1234-45678/001/HS and 1234-45678/002/HS belong to file number 1234-45678.

    If I need to make an amendment, in house an amendment is to make modification to a contract. In my column B I will always have the amount of contracts. In the example above the amount for Contracts is 002.

    If I make an amendment and the reason of the amendment is a Termination, therefore cancelling one contract to create another one, I need to be able to change all information in my Column B vs All information from Column A. So for Example:

    If
    A5-1234-45678 B5-002 C5-1234-45678/001/HS
    A6-1234-45678 B6-002 C6-1234-45678/002/HS
    And I need to make the above modification then I need to add another Contract but change all information from my Column B (Made in a userform, already establish). So the above example will become:

    A5-1234-45678 B5-003 C5-1234-45678/001/HS
    A6-1234-45678 B6-003 C6-1234-45678/002/HS/T01 < - - - this line will be deleted
    A7-1234-45678 B6-003 C6-1234-45678/003/HS

    I have included a Demo with some userform to see what I need. You will see that when you add a number in Column M.

    I only need this code to finally complete this Workbook...

    Demo.xlsm

    Please let me know if I am not being clear or would need me to provide additional Information. I have cut down on my workbook as it is to big to post complete workbook plus would take 3 full page to explain to full process.

  2. #2
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Re: Add Values in column And change Values in another column vs .find match function? 2007

    Forgot to mentionned after clicking Add just select "YES" to all msgbox.

  3. #3
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Re: Add Values in column And change Values in another column vs .find match function? 2007

    New version without password:

    Demo.xlsm

+ 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. How do i find the max of two values from index match max of a column
    By mohaymin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-09-2013, 02:04 PM
  2. How to find a column match and paste values
    By dwx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-02-2013, 12:56 PM
  3. Excel 2010 vba to find values in a column and change it
    By dearnemo385 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-17-2012, 12:17 PM
  4. How can I find duplicate values in a column and then change the value of a cell?
    By Excelcod in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-06-2011, 02:59 PM
  5. [SOLVED] How to find the largest change of values in a column
    By Ravager in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-11-2006, 02:05 PM

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