EntireRow.Insert with conditions vs a match VB code

Good evening everyone,
Stuck on a ready troubling code and can't think of how in the hell I will complete this... I have a workbook of 400kb therefore I deleted some information only for this purpose.

Quick story: I have created this report that will allow my users to insert and track each files (projects) in one excel workbook while maintaining delivery dates and status of the files. Each files has its own process and the goal is to mimic an in house system that we have. So far so good . I have completed my workbook. Now because people have demanded more functions I am stuck at the following. From just drop down selection to userform selection for more "user friendly"

Process: Like I said all files has its own flow...meaning not all files will move one by one, some will stay in a Sheet longer than the other. This depends of the time frame of the user. Blah blah... now on the evaluation stage of the file, IF a file needs to be reposted, as we call a re-tender, it need to ba added some functions.

The main goal is that every step of the way all transfer is made be looking in my Report Sheet and transferring the information that needs to be transfer... this said IE: File number 1234 needs to be retendered. So the user will double click in column A where the selected file that needs to be retendered and a userform will pop up with command buttons. The one to select is re-tender.
When the user select Re-Tender the code needs to look in my Report sheet vs the same file number, so 1234 and insert a new row underneath that one while offsetting all the information from that selected row A to X (Activecell.row method).

Step two will be to go back in my Evaluation sheet and in a input msg ask the user to enter the letter of the re-tender. This process the user will know. For this test write any letter. Once ok is selected it will copy the info from that row (column A and B) to the Merx sheet but will add a /”letter” to the end of the file number IE: 1234/A but also need to update the new inserted row from my Report sheet by adding a /A also to 1234.

I kind of have the code. But I don’t have the offset information.

The hole workbook is based on matching for sheets 1,2,3 and 4 to my sheet report(sheet5) therefore if I add any information in the previous sheet (1,2, 3 or 4) it will generate a matching error because the file number doesn’t exist in my report...

Workbook included with example... Double click on column A (Any file number) for the userform to show. Then Select “re-tender”. It will then ask you to enter a letter... enter any letter from A to Z.

Requisition number is IE: 1234 in the workbook I have named them Test01.



Testdata.xlsm

P.S: I can up load the full workbook and add the codes from each sheets but that will mean I will need to explain the hole process and that could take a long time lol


Hope someone can help me with this...

Thank you,

Excelnoub

Forgot a couple of info lol holy crap it is so easy to explain in my head but when you try to explain it on a forum lol Lost in descriptions...

I will try to add a clearer explanation (better version)

With an updated workbook...

Nothing yet... Trying on some codes but they don't seem to work

This uses the .Find method instead of the Match function.

Please Login or Register  to view this content.

Wow...

You are one hell of a genius HAHAHA Thanks' allot now I have to change all of my workbook to adjust your coding HAHAHA

AlphaFrog you are one hell of a coder... I was being sarcastic with the changing the hole workbook but I think I will check your code learn it and try to change my worksheet as I have more coding like this that will be more complicated... Was using the Application Match as it was what I knew...

Dude you rock...

Excelnoub

You're welcome.