Move Data and Create Headers

Hello All,

I was hoping someone could help me with this programming. I've been trying to tackle it for quite a while for my internship, but haven't had much luck.

In column B of the data sheet are Patient ID #. There are two other worksheets in the workbook, contingency and prescription. The first task was to move the data(Columns O and S specifically) for patients whose column E read main study correspondingly. This data would move into Worksheet ("Prescription") if Column G read 0 or Worksheet ("Contingency") if column G read 1. The code for that is below.

Please Login or Register  to view this content.

Now however a new component has been added in which I need some help with. Column B has patient IDs. Using the same criteria as above(0=prescription, 1=contingency) I need the program to take every DIFFERENT patient ID and create headers in the corresponding worksheet with the corresponding data beneath. So for example, there will be ONE header reading DL1042 tottimingtyping(column O data) and all the data corresponding to DL1042 in column O will be in the new worksheet (prescription in this case since column g is 0) it will then do a header reading DL1042 tottimingkeypad(column S data) and the same for this. It will then create headers for the next patient CB1048 and do the same thing, and so on till each patient in column b has their own header in the correct place in the other worksheets.

Any help would be greatly appreciated, I am completely stuck and my internship relies on this task!

Bests,

V

Can you attach a sample file and what the outcome looks like?