I basically export bed records and ward/room location of patients to a excel.csv, I then pre-run a personal macro to clean up the data and rid of the unwanted.
I need a way of Merging the contents from a csv (Max of 16 records) on any given day and put them onto one A4 page word page containing columns within, I only wish to work with one page and be to print that one page holding a these records onto a daily running sheet really

So, I wish to be able to put the extracted data onto 1X A4 piece of paper which has columns already which is laid out in similar way to our ward (plan view).

This will be updated regularly from a newly extracted.CSV from our main patient intake system, this will help greatly so as at a glance staff/doctors in a hurry can look at this sheet and see where a patient is and are. Note: not all of the rooms are filled in some cases some of the rooms are empty, so I need to be able to skip the empty rooms. The thing is when I try the basic mail merge wizard with ms word, I can't get the data all on one sheet, it produces lots of sheets for each row of data(which is what is purpose for I know) but I am not looking to generate lots of letters for each record. I just would rather get on with work rather than cutting and pasting names each time a patient moves on or changes rooms. So this is the issue that i need direction with, to somehow find the corresponding wing/room number and then insert the patients name into the correct room number to the right (or left) of the depending on which side of the corridor they are in.



The room numbers never change C1-8 & D1-8
samples attached csv and test doc

Attached Files

	WardX.docx (41.7 KB, 13 views)
	TestMergeData.xls (16.5 KB, 11 views)

Cross-posted at: http://www.mrexcel.com/forum/excel-q...ml#post4493572

For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]