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 ...
Mr. Derek
As Mr. Chan noted - the fields and data are in one cell - if this is the case for all your worksheets (and merged cells) - it might be difficult to manage. I came up with a similar situation but with separated fields and data. Maybe you can come up with something out of it (or someone) ..
somewhat crude but I think it worked.
Hope that this may help you - somehow..
thanks
- 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..