Congratulations to our new Gurus

Last edited by JBeaucaire; 12-09-2013 at 12:24 PM.

If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]

Click * below if this answer helped

Advanced Excel Techniques: http://excelxor.com/

Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

...enjoy -funny parrots-

Regards

Fotis.

-This is my Greek whisper to Europe.

--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

Advanced Excel Techniques: http://excelxor.com/

--KISS(Keep it simple Stupid)

--Bring them back.

---See about Acropolis of Athens.

--Visit Greece.

Alan עַם יִשְׂרָאֵל חַי


Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

You can't do one thing. XLAdept

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"

1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you

Regards
Ford

Biff
Microsoft MVP Excel
Keep It Simple Stupid

Let's Go Pens. We Want The Cup.

If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved

If the suggestion helps you, then Click *below to Add Reputation

John

If you have issues with Code I've provided, I appreciate your feedback.

In the event Code provided resolves your issue, please mark your Thread as SOLVED.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

"Unless otherwise stated all my comments are directed at OP"

Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code

how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito

how to say no convincingly

most important thing you need
Martin Wilson: SPV
and RSMBC

Please consider:

Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

Trevor Shuttleworth - Retired Excel/VBA Consultant

I dream of a better world where chickens can cross the road without having their motives questioned

'Being unapologetic means never having to say you're sorry' John Cooper Clarke

I think people forget the word "THANK YOU!!!!" Do you still know it???

There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

Regards,
Vladimir

Thanks, if you have clicked on the * and added our rep.

If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

"Contentment is not the fulfillment of what you want, but the realization of what you already have."

Tips & Tutorials I Compiled | How to Get Quick & Good Answers

Life's a spreadsheet, Excel!
Say thanks, Click *