New to VBA and struggling...
Here is what I need:
If text in row 1, column G (Shot2), then insert row below and copy text from row 1, columns A thru C (Patient1, Name, Demographic) to Row 2, columns A thru C, cut text from row 1, column G thru column I and paste to Row 2, columns D thru F
Here's a graphical representation of the starting layout:
Patient1, Name, Demographic, Shot1, Record, MMDDYYYY, Shot2, Record, MMDDYYYY, Shot3, Record, MMDDYYYY
Patient2, Name, Demographic, Shot1, Record, MMDDYYYY
Patient3, Name, Demographic, Shot1, Record, MMDDYYYY, Shot2, Record, MMDDYYYY
Here's what I need (A single shot record per row with patient info repeated until the next new patient):
Patient1, Name, Demographic, Shot1, Record, YYYYMMDD
Patient1, Name, Demographic, Shot2, Record, YYYYMMDD
Patient1, Name, Demographic, Shot3, Record, YYYYMMDD
Patient2, Name, Demographic, Shot1, Record, YYYYMMDD
Patient3, Name, Demographic, Shot1, Record, YYYYMMDD
Patient3, Name, Demographic, Shot2, Record, YYYYMMDD
I'm sure for experienced VBAers this is simple code but for a newbie, it's an hours long, frustrating, self-teaching endeavor. Many, many thanks in advance!