Forum Discussion
Consolidating data from multiple worksheets
Note: I'm a Mac user but could use a PC if needed. I am trying to analyze patient satisfaction surveys and have been given an excel file. Unfortunately, the way the program exports results is not ...
press ALT F8 then run the macro
if we are to use the original worksheet of field and data in one cell -- we have to use lots of trimming of the string:
ex B7= Visit #: 55555
instead of just using Range("B7") - we have to use Right("B7",len("B7")-9) and so on...
also I noticed in your "Ideal Table" that there are data not present in the survey results and vice versa...
thanks..