I may not have explained what I need properly so here goes now, I have quickly went through all of these links, they a far more complex than for what I need and the samples mostly deal with clumping categories together and still create lots of pages. I only wish to work with one page and be ab and a fele to print one page holding a few different records/rows (maxium of sixteen records/rows on one daily running sheet really), I basically recieve extracted bed records and ward/room location of patients that's gets sent to me in excel.csv, I then pre-run a personal macro to clean up the data and rid of the unwanted (as you do).
So, all I wish to be able to do is put the extracted data onto 1X A4 piece of paper which has columns on it in a similar layout of our ward (plan view). This will be updated everyday from a new .CSV, it has to show who's and why they are there and in rare cases some of the rooms are empty, so I need to be able to skip the empty ones. 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. So this is the issue that i need direction with, to add to this the vba or code needs to somehow find the corresponding wing/room number and then insert the patients name into the next field 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
but Patients come and go daily
CSV Data for test/Merge purposes:
Room | Sname | Address | Illness | ArrivalDate |
C1 | Smith | Brisbane | O'Brien | 1/1/2001 |
C6 | Jones | Mt Gambier | Cleary | 1/2/2001 |
C5 | White | Launceston | Maher | 1/3/2001 |
D5 | Brown | Wodonga | Palmer | 1/4/2001 |
D2 | Green, J | Perth | Wark | |
<tbody>
</tbody>
Shame, I can't upload the word doc , so below is my attempted paste from word.
West Wing P/Name D Ward P/Name EastWing
D4
| VACANT |
| Brown
| D5
|
A/Date | NULL | | 1/4/2001 | A/Date |
D3
| VACANT | | VACANT | D6
|
A/Date | | | | A/Date |
D2
| Green, J | | VACANT | D7 |
A/Date | | | | A/Date |
D1 | VACANT | | VACANT | D8
|
A/Date | | | | A/Date |
| C Ward West | | C Ward East | |
C4 | VACANT | | | C5
|
A/Date | | | | A/Date
|
C3 | VACANT | | Jones | C6 |
A/Date | NULL | | 1/2/2001 | A/Date |
| | | | |
C2 | VACANT | | VACANT | C7 |
A/Date | NULL | | NULL | A/Date |
C1 | Smith | | VACANT | C8 |
A/Date | NULL | | NULL | A/Date |
<tbody>
</tbody>