Hello,
First of all I am not quite sure how to use the Input.xlsx workbook and Sheet1 from it without inputting it in the VBA.
I was thinking of ActiveWorkbook and ActiveSheet, I think it might work, though the code is ran from Code.xlsm
The code has multiple functionalities than have to be tweaked
1) It Deletes the Rows where there are duplicates. This is a bit wrong, as I would have wanted to make it delete the rows if it finds duplicates on columns A&C.
Such as scanning columns A&C and
So far, it deletes the entire row if at least 1 duplicate cell is found on columns A:F
2) It is trying to look for a keyword and based on the results it should copy the offsets in the Input.xlsx file on Sheet1, columns G:K (the keyword should not be case sensitive).
The problem is that it stops after the first result is encountered and if I expand the range of the Offset.Value result, it keeps pasting the same value everywhere.
3) After 1) and 2) are done it should copy the values from columns G:K in a .txt file with the output similar to the one found in attachments.
Below, I attached all the items from the above Key.
Thank you very much in advance, it is appreciated.
Bookmarks