Forum Discussion
Consolidating data from multiple worksheets
I think it is difficult as the cell contains the title and the datum as well.
I did not have time to write a detailed VBA for you. Attached is a simplified case. Hope that you understand it and make the code for yourself. The key is to list the field in <Info> and specify the range of it. As some field contains "title", you have calculate the len of "title" and listed in the column M.
There is also another module to list all patients' sheetname.
Thank you for your reply. Unfortunately, I've never been exposed to VBA scripting so this doesn't make much sense. I've been looking at your example and trying to work it out, but I'm not comprehending it as of now.
I'm sure you're busy, but if you have any time to do the scripting on the excel file I attached, I would really appreciate it.
