Hello!

So firstly I'd like to state that I am out of my element for what I'm trying to do and that there is more than likely a better or simpler way to approach this, but I've been trying to do this since Monday and it's just not clicking for me. If I had to guess I'd say the answer is pretty simple but I'm too zoomed into the problem to see it.

Alrighty so to explain the entire process, essentially a user will specify a source directory and target file, select which type (Open, Closed, Operational; I can't tell the distinction apart from the Open or Operational files aside from their name, but they boil down to either Open or Closed) of file is being targeted, then click "Run". The outcome should, depending on the type of file selected either:
  1. Closed: Parse the "Closed Issue" source file, adding newly closed issues into the "Closed Issues" worksheet. Afterwards, it will then parse the "Open Issues" worksheet looking for any matches in the "Issue" column. If a match is found, then it copies the details/description into the "Closed Issues" worksheet for the respective match, and finally then deletes the matched row within the "Open Issues" worksheet.
  2. Open/Operational: Parse the source file and compare against the "Closed Issues" worksheet, looking at the "Issue" column for those matches. If a match is found, skip, otherwise put the open issue from the source file into the Open issue worksheet.

Sounds straight forward enough - take files that are generated bi-weekly, copy their only worksheet into the active workbook, then parse that temporary worksheet and update the Open and Closed worksheets based on the filetype. However, at my current point, I've been copied the worksheet from the source file into a local temporary worksheet named "Temp-Processing" but I've stuck on trying to understand how iterate through the worksheet and get it into appropriate outcome (closed/open issues) worksheets. To try and keep this simple for myself I've been focusing on the "Closed Issues" with the idea that once it works for the closed issues, I can bring it up a level and then start working on other types. Unfortunately I haven't been able to get that far yet, and I've been stuck on the part I'm on now for three days.

With all of that being said I'd like to ask - Would someone be able to help me understand where the wrench in my machine is, or would someone be able to steer me in a simpler direction, as I feel like this could be done so much more simply, but it's not clear to me how?

Lastly, the attached example files contain an example issue as well, "101-Issues Galore", which shows how it would appear in a batch of new Open & Closed issues, as well as how it would be noted after the program ran successfully in "Example Tracker WB" under the "Closed Issues" sheet.

Please Login or Register  to view this content.
Example Tracker WB.xlsx
Example Open Issues.xlsx
Example Closed Issues.xlsx

Thank you in advance for any suggestions or corrections!