Data Compile

[rizmomin]

Attach is the excel sheet for referance.

Data Sheet contains all required data.

Need Macros as follows

Macro#1
Needs to use data from "Data" Sheet and compile in Monthly summary sheet as follows.
Eg : Sum of all Count65 column(D) for Jan 07 from "Data" sheet and enter in at B5 in Montly Summary Sheet.
Sum of all Sales Commission column for Jan 07 from "Data" Sheet and enter at C5 in Monthly Summary Sheet.
Similary for column D,E,F,G


Macro#2 needs to use data from "Data" Sheet and compile as in Clinic_Monthly summary sheet.

EXactly as in Macro 1 above and inthe format shown in Clinic_Monthly Summary Sheet...


Help is always aprreciated...

Please let me know if you have any questions..

Thank You in advance

Riz Momin

[Leith Ross]

Hello Riz,

I have been working on your problem. The results from the macros I wrote aren't working correctly. They run fine in VBA, but no UDF will work in Excel. Did you have some problems with this workbook before you posted it?

Sincerely,
Leith Ross

[rizmomin]

No i did not have any problems at all....

Riz

[rylo]

Riz

Don't need macros for this - can all be done with functions. Refer to the attached file.

rylo

[rizmomin]

Thank you very much ..this should work for me....


Riz Momin

[rizmomin]

Thank you for your help...
i need 1 more small help...i have attached sheet...

Look at Monthly Summary Tab...what i need is formula for Sum of Count65 for Jan06,Feb06, and so on
for Evershine and Rapidcare (these are the companies doing the work for us) from "Data" Sheet.

Please let me know if you have any questions....

Riz Momin

[rizmomin]

Never mind i figured out....

Thank U

Riz Momin

[rylo]

Riz

Glad you could work it out.

rylo