I am a novice and working with a data output into excel that is very "dirty" and with lots of inconsistencies preventing easy re-formatting of the data.
In the attached workbook I have a column with House #s. I need to return the Charge (Column M) corresponding to the first occurrence of Expense Code Q associated with a particular House #. Difficulties I am encountering:
1. The House Column contains a mix of (1) numbers formatted as text, with irrelevant [text] interspersed throughout the House Column
2. Spacing between columns
3. Trickiest part of the Code will be writing something that extracts the Charge associated with the first occurrence of "Q" in between identifying House #
Thank in advance you so much for your help. This website has been enormously beneficial for me as I try to learn VBA.
Bookmarks