Deleting some text from two different sheet .find

[Excelnoub]

Good day,
Hope this will make sense. I have 3 sheets. When I double click on my column A vs. a project number, to find the same project number on my Report sheet and to delete “Left, Len (-2)” on the report sheet then copy the same text (without the “Left, Len (-2)). I have created an example on the workbook.

If ActiveCell.Row (“A”) is double click then search for the same in Report sheet and delete the “/”(letter).
Else copy the ActiveCell.Row (“A”) + “Left, Len (-2)” to my Contract sheet and clear the ActiveCell.Row in my Evaluation Sheet.

The code is already in place within my workbook Sheet Evaluation under frm3. But it’s the “Left, Len (-2)” that I have trouble with.

If someone could help me or take a look I would appreciate it.


Test1.xlsm

[tigeravatar]

Excelnoub,

Change this line:

Please Login or Register  to view this content.

to be this instead:

Please Login or Register  to view this content.

[Excelnoub]

I replaced it and nothing... The "/" + Letter (Letter = A to Z) doesn't delete.

If Activecell.Row "A" = Test01/A then the transfer needs to delete the /A so that the text only reads Test01.

[tigeravatar]

You want to delete the "/A" in the cell itself on sheet 'Evaluation' ?

[Excelnoub]

No the /A in the Evaluation will be deleted... My workbook is based on row transfer from one sheet to the other. All transfer must match (.find method) to my Report Sheet. If I delete the /A from my Evaluation sheet then transfer I will not find the Matching project in my report. Therefore I need to Find the matching Text in my Report then remove the /A or /"Letter" from my evaluation sheet and my Report Sheet then my other code can continue.

If my Report sheet has Text08/H that will mean that in my Evaluation sheet there is the same project number. I need to Remove the /H from my Evaluation sheet but also look in my ActiveCell.Row "A" and remove the /H from Text08/H project.

Therefore the rest of the code can match the project number when I do my transfer.

Hope this is clear. In my workbook attached there is an example of what it needs to do. The main code is already there. I also have the clear code but needed to deleted it to size up my file on here.

[tigeravatar]

Excelnoub,

I'm not really following you at all. In any case, you can easily get everything before the / by using:

Please Login or Register  to view this content.

You should be able to use that where you need it to accomplish what you need to do

[Excelnoub]

Thank you Tigeravatar,

Here is what I was trying to do... Found my code in another code that I had:

Please Login or Register  to view this content.