Leith Ross
Forum Moderator

Leith,
I have some old posts that need to be marked as solved. Will you please do that for me? Here are the links:
http://www.excelforum.com/excel-prog...ml#post2640020
http://www.excelforum.com/excel-prog...ml#post2617323
http://www.excelforum.com/excel-prog...ml#post2640061
http://www.excelforum.com/excel-prog...ml#post2640071

Would you please mark the thread below as closed. Yours is the only moderator name I remembered off the top of my head. I no longer have the edit option on the original post. Thank you!
http://www.excelforum.com/excel-prog...one-entry.html

Hi leith,

Just wondering if you had any update on the post of the web queries with drop down menus.

let me know..

can you please delete my last post I answered on the post
Re: Filling up and Emailing an Outlook Template from values in an Excel file
i didn't mean to answer this I was trying to write on my own post and accidently pasted this --please delete the post..

Hello Leith Ross,

I am facing problem in receiving a solution for my thread. I didnt' got any help so for my thread, Can u help me to solve my problem? my thread is under the name of kmsoni in excel programming. please help. thanks. i wrote this message because i didn't got any help from users, please pardon me. thanks.

Dear Leith,

You seem like a color count hero ;-). In post http://www.excelforum.com/excel-prog...ml#post2605411 you helped Greed perfectly.

I have a similar problem, it would be great if you could help me with it.

1) Key issue: I need Excel to count the number of cells that meet Criteria A (text), Criteria B (text) and Criteria C (red color).

I tried to do this with:
=Countifs (range “column A”, Criteria A “text”, range “column B”, Criteria B “text”, range “column C”, Criteria C color red).

For Criteria C I however do not know which formula to use to get the criteria “red cell”. I would not like to add additional columns, everything should be in one formula.
I tried all, but nothing worked. I run the color module by Chip Pearson, but this gave an error message.

Hope you’ll be able to provide me with the answer…
Many thanks!

Alinda

the data that I need to transpose in whole genome array data, if that helps any so that I can use Partek instead of GeneSpring.

Hi Ross tried your transpose macro, I get a run-time error '1004' and am too stupid to work it out, it referes me back to line:

Set DstRng = DstRng.Offset(R + C, 0)

right at the end can you help?

Hi Leith

Posted question in anothers posters thread
http://www.excelforum.com/excel-prog...ltiple-ws.html

Hi Leith

Another poster asking a question in someone elses thread