M
murkaboris
Hello:
I'm trying to write a macro that would pull data from the raw data file into
a preformatted workbook with multiple sheets. Normally a pivot table would
work but bcs each sales person has their own worksheet I need to capture the
data on separate worksheets and thought macro would be able to do it instead
of me doing copy-paste from a pivot into the worksheets.
Here is the format of the pivot:
Territory Id Account Name (English) Modality Competitor 1 Total
100507 Mc Donough District Hospital RAD Philips 450000
100600 Stephenville Med / Surg Clinic Mammo Hologic (Lorad) 350000
100603 Anson General Hospital CT Toshiba 385000
Diagnostic Management Group CT Third Party 43000
Harris Methodist - Fort Worth MR Hitachi 900000
Palo Pinto General Hospital RAD Shimadzu 38900
Radiology Associates of Tarrant County R&F Third Party 265000
100604 Grace Medical Center R&F None 280000
Medical Arts Hospital MR Siemens 618000
Nuc Used Equipment Vendor 210000
San Angelo Community Medical Center Nuc Philips 200000
Is there a way to write a macro that would return this data by looking up
the specific Territory ID and then pulling the data into the following format:
Account Name (English) Modality Total Competitor 1
Mc Donough District Hospital RAD 450000 Philips
Stephenville Med / Surg Clinic Mammo 350000 Hologic (Lorad)
Anson General Hospital CT 385000 Toshiba
Diagnostic Management Group CT 43000 Third Party
Harris Methodist - Fort Worth MR 900000 Hitachi
Palo Pinto General Hospital RAD 38900 Shimadzu
Radiology Associates of Tarrant R&F 265000 Third Party
Grace Medical Center R&F 280000 None
Is this possible?
Thank you.
Monika
I'm trying to write a macro that would pull data from the raw data file into
a preformatted workbook with multiple sheets. Normally a pivot table would
work but bcs each sales person has their own worksheet I need to capture the
data on separate worksheets and thought macro would be able to do it instead
of me doing copy-paste from a pivot into the worksheets.
Here is the format of the pivot:
Territory Id Account Name (English) Modality Competitor 1 Total
100507 Mc Donough District Hospital RAD Philips 450000
100600 Stephenville Med / Surg Clinic Mammo Hologic (Lorad) 350000
100603 Anson General Hospital CT Toshiba 385000
Diagnostic Management Group CT Third Party 43000
Harris Methodist - Fort Worth MR Hitachi 900000
Palo Pinto General Hospital RAD Shimadzu 38900
Radiology Associates of Tarrant County R&F Third Party 265000
100604 Grace Medical Center R&F None 280000
Medical Arts Hospital MR Siemens 618000
Nuc Used Equipment Vendor 210000
San Angelo Community Medical Center Nuc Philips 200000
Is there a way to write a macro that would return this data by looking up
the specific Territory ID and then pulling the data into the following format:
Account Name (English) Modality Total Competitor 1
Mc Donough District Hospital RAD 450000 Philips
Stephenville Med / Surg Clinic Mammo 350000 Hologic (Lorad)
Anson General Hospital CT 385000 Toshiba
Diagnostic Management Group CT 43000 Third Party
Harris Methodist - Fort Worth MR 900000 Hitachi
Palo Pinto General Hospital RAD 38900 Shimadzu
Radiology Associates of Tarrant R&F 265000 Third Party
Grace Medical Center R&F 280000 None
Is this possible?
Thank you.
Monika