How to create and populate sheets based upon cell values in master sheet?

[mezzopiano1423]

Hello all, this is my first post, thanks in advance for helping me out!

I have VERY little experience with VBA, yet I have been told it is the best solution to my problem, which is:

PROBLEM: I frequently work with raw data output for ~40 different doctors and various columns of data (DOB, gender, diagnosis code, etc.). There is typically tens of thousands of lines of output for these 40 doctors, which I need to distribute to them. This involves copying and pasting the data into 40 different sheets. It's very time consuming.

DESIRED SOLUTION: Rather than copy and paste the sorted output into new sheets for each doctor, I would like to run a macro that creates new sheets that contains all of the data in the columns located in the master sheet based upon the cell values in column A, which would contain the doctor name.

For example:
PROVIDER NAME PATIENT NAME DIAGNOSIS
Dr. A J. Doe1 493.1
Dr. A J. Doe2 493.0
Dr. A J. Doe5 250.0
Dr. A J. Doe4 250.01
Dr. B J. Doe5 493.1
Dr. B J. Doe6 493.0
Dr. C J. Doe7 250.0
Dr. C J. Doe8 250.01

Since these doctors would each have hundreds/thousands of lines of output, it would be great if I could run a macro to save me some 'mouse mileage'!

If you can give me a hand with this, I would really appreciate it! Keep in mind, I'm very new to VBA so including the simplest of steps would be fantastic.

Thanks!

[alansidman]

Are you familiar with Access. This is a perfect application to run the reports you need by building a query and exporting the results to Excel. If that is not an option for you, then consider using MS Query which is a built in feature of Excel. Here is a tutorial on how you could use MS Query to get the results you need.

http://www.exceluser.com/explore/msquery1_1.htm