Hello...I have a master workbook (Source.xls) with 8 sheets of data, covering a two year period.
Each sheet (tab) contains 1640 rows of data for one quarter of a year.
Each row in each sheet represents one physician's data for that quarter.
Each column in each sheet represents the different criteria or measures for that physician's file.
will have data for all columns.
A sample (Source.xls) of the original master workbook is attached with only 15 of the original 1640 rows shown per sheet. A
sample of a physician workbook
(Target.xls) is also attached.
The second workbook (Target.xls) has only one sheet, representing one physician.
Each row in Target.xls represents one quarter of the year.
Each column represents the same criteria as found in Source.xls for that one physician.
We need to be able to look
at each physician's file twice a year, hence the decision to create Target.xls for each physician.
I need a macro to copy each row in each sheet in Source.xls (each row represents one physician), create a new workbook with
the mnemonic of the
physician (found in B3 of Source.xls) and paste the data in the row that matches the correct quarter in Target.xls.
Depending on the physician, there may only be one quarter's worth of data in Source.xls (and Target.xls), but I still need
to see that there are
blank rows (quarters) in Target.xls for that physician.
Any help would be most appreciated.