Hello Experts!
I have a spreadsheet that is exported from a non-excel program as a single sheet .xls. I need specific data from this xls. The issues are as follows:
The exported xls is the result of user input, so the below items CANNOT be assumed as being located consistently
1. The data (Numbers) I need are blended with text symbols (1099 ft², 118' 8", 26.67 lin. ft. , etc).
2. I need all these numbers converted to their decimal values (Feet), and all the non-numerical crap deleted.
3. I need to locate each iterance of POOL(*) and determine Sq Ft and Perimeter ft. these values, if more than 1, are kept separate
4. need SPA(*) sq ft and perim. there could be multiple spa entries. Sq ft and perim. kept separate
5. need STEP/BENCH(*) lin. ft. in decimal form, of course, and each iterance of STEP/BENCH added together. There could be many (STEP/BENCH01, STEP/BENCH02, etc)
6. need DECK(*) sq feet added together. There could be many iterations
7. need to search for "Reverse Negative Edge, with lineal distance
8. need to search for "Reverse Forward Edge, with lineal distance
9. need to search for "spillover, with lineal distance.
The whole process is as follows:
User exports attached file from non MS Office program, in all its glory;
User locates said exported file from within elaborate excel 2016 .xlsm (64bit) application (VBA)
User then imports results into various forms/etc. I got that part.
Thank you in advance!
Bookmarks