That is an interesting approach, i wasnt sure how to do it that wayOriginally Posted by OBP
I havent really thought about a way to do this. I was manually typing it in when doing it in excel.What about the First rows of the Summary, the Hospital etc, where do they come from?
These files are coming from different hospitals which use different conventions. The files also have different column headings because they are from different facilities. I have done 3 of these so far and with each one the column headings and filenames have been different.I fogot to ask, what format is the original data in when you want to Import it and what sort of naming convention do the files have.
The while thing might as well be automated if possible.