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.
Bookmarks