Re: $$Excel-Macros$$ Fw: Split Workbook into Multiple Worksheets

2012-07-18 Thread LAKSHMAN PRASAD
Awaited for your reply...  I have attached sample file   Lakshman Prasad       - Forwarded Message - From: dguillett1 To: LAKSHMAN PRASAD Sent: Thursday, July 12, 2012 5:37 PM Subject: Re: Split Workbook into Multiple Worksheets If you decide to hire me to do this @ $75 hour

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

2012-07-18 Thread amar takale
Dear all Can you please help me to find out Boys & girls Rank (Regarding Marks) If they failed then can not count their rank.Can I got this formula Thank you very much for the support you all have been providing. Amar On Wed, Jul 18, 2012 at 6:56 PM, dguillett1 wrote: > See sumproduct formul

$$Excel-Macros$$ AUTO: Sharon Hutchison is out of the office (returning 23/07/2012)

2012-07-18 Thread Sharon Hutchison
I am out of the office until 23/07/2012. Any queries please contact x54455 Note: This is an automated response to your message "$$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 7 Messages in 6 Topics" sent on 19/7/2012 1:10:45 AM. This is the only notification you will receive whi

Re: $$Excel-Macros$$ urgent need for java/flex developer

2012-07-18 Thread NOORAIN ANSARI
Dear Ayush, Please ban it.. On Thu, Jul 19, 2012 at 3:27 AM, uma sindhu wrote: > Hi, > > > > Hope you are doing good!!! > > > > We have an Urgent need Java/Flex developer with one of our client. Please > go through the job description and let me know your interest. If you are > interested plea

Re: $$Excel-Macros$$ Re: How to learn/understand INDEX, INDIRECT, FIND, MATCH, OFFSET functions?

2012-07-18 Thread Indrajit $nai
Thanks buddy. On Wed, Jul 18, 2012 at 10:55 PM, Prince Dubey wrote: > Hi Indrajit, > > I thing this site will help you > http://www.ozgrid.com/ > regards > prince dubey > > On Wednesday, July 18, 2012 3:09:11 AM UTC+5:30, Bullet wrote: >> >> Hi All, >> >> Tell me some easiest way to learn/un

Re: $$Excel-Macros$$ ?????????????

2012-07-18 Thread NOORAIN ANSARI
Dear Anirut, Send your query in English Version. On Wed, Jul 18, 2012 at 10:06 PM, ANIRUT KOSAYAMAS wrote: > ?? > ?? code ?? recode ( find ) > > Cells.Find(What:="A", After:=ActiveCell, LookIn:= _ > xlFormulas, LookAt:=xlPa

$$Excel-Macros$$ Re: How to learn/understand INDEX, INDIRECT, FIND, MATCH, OFFSET functions?

2012-07-18 Thread Prince Dubey
Hi Indrajit, I thing this site will help you http://www.ozgrid.com/ regards prince dubey On Wednesday, July 18, 2012 3:09:11 AM UTC+5:30, Bullet wrote: > > Hi All, > > Tell me some easiest way to learn/understand INDEX, INDIRECT, FIND, MATCH, > OFFSET functions. > > Thanks in advance. > > --

$$Excel-Macros$$ ?????????????

2012-07-18 Thread ANIRUT KOSAYAMAS
?? ?? code ?? recode ( find ) Cells.Find(What:="A", After:=ActiveCell, LookIn:= _ xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _ xlNext, MatchCase:=False, Searchformat:=False).A

$$Excel-Macros$$ testmail

2012-07-18 Thread ANIRUT KOSAYAMAS
-- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the

Re: $$Excel-Macros$$ Put items numbers to a BOQ

2012-07-18 Thread NOORAIN ANSARI
Dear Dilan, Please more explain. On Wed, Jul 18, 2012 at 1:23 PM, Dilan De Silva wrote: > Dear friends, > > I'm looking a macro to put items numbers to a BOQ. My requirements as > below. > > If Quantity = " " then > Item nr = "" > Else > For page 1 to last page > Item nr should be a letter (S

Re: $$Excel-Macros$$ How to learn/understand INDEX, INDIRECT, FIND, MATCH, OFFSET functions?

2012-07-18 Thread Indrajit $nai
Thanks to everyone.but can you send me some example file with the attachment. On Wed, Jul 18, 2012 at 4:34 PM, pankaj sangotra wrote: > Go to techonthenet website, it will surely help u out buddy > On Jul 18, 2012 3:09 AM, "Indrajit $nai" wrote: > >> Hi All, >> >> Tell me some easiest way

$$Excel-Macros$$ Help needed !!!

2012-07-18 Thread Shaikh Iqbal
Dear Exports, Please find attached a file & help for formula. Regards, Iqbal Shaikh -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Ad

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

2012-07-18 Thread dguillett1
See sumproduct formulas in attached. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: group birle Sent: Wednesday, July 18, 2012 7:47 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl che

Re: $$Excel-Macros$$ Need Urgent Help on If statement

2012-07-18 Thread ponnusamy paramasivan
On 7/4/12, NOORAIN ANSARI wrote: > Dear Mangesh, > > Please put it in Module after press Alt+F11. > Then we can use it under Activeworkbook. > > > On Wed, Jul 4, 2012 at 8:06 PM, Mangesh Vimay > wrote: > >> Thanks Noorain Where should I put this code. I mean in module or any >> the place to run th

Re: $$Excel-Macros$$ Put items numbers to a BOQ

2012-07-18 Thread dguillett1
ALWAYS provide an example of your desires. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Dilan De Silva Sent: Wednesday, July 18, 2012 2:53 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Put items numbers to a BOQ Dear friends, I'm lookin

$$Excel-Macros$$ VBA Converter for Office 2010

2012-07-18 Thread Hilary Lomotey
I'm getting the following error when trying to run an add-in in Office 2010 Opening the VBA project in this file requires a component that is not currently installed. The file will be opened without the VBA project. For more information, search Office.com for "VBA converters" pls can someone h

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

2012-07-18 Thread group birle
check this On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल wrote: > Dear all, > > Can you please help me to find out the total number of boy and girl ? I > used countif for their grade and it worked. However, for girl and boy > seggregation it isnot working. > > Thank you very much for the suppo

$$Excel-Macros$$ Code for combining PDF files thru VBA

2012-07-18 Thread Prashant Pawle
Dear Team, Kindly help on Code for combining multiple PDF files thru VBA regards, Prashant -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need A

Re: $$Excel-Macros$$ How to learn/understand INDEX, INDIRECT, FIND, MATCH, OFFSET functions?

2012-07-18 Thread pankaj sangotra
Go to techonthenet website, it will surely help u out buddy On Jul 18, 2012 3:09 AM, "Indrajit $nai" wrote: > Hi All, > > Tell me some easiest way to learn/understand INDEX, INDIRECT, FIND, MATCH, > OFFSET functions. > > Thanks in advance. > > -- > Indrajit > > Disclaimer: > This electronic mess

Re: $$Excel-Macros$$ How to learn/understand INDEX, INDIRECT, FIND, MATCH, OFFSET functions?

2012-07-18 Thread Ojemeni Uzoma
Ojemeni Uzoma | Call 08060700717 -Original Message- From: NOORAIN ANSARI Sender: excel-macros@googlegroups.com Date: Wed, 18 Jul 2012 15:02:35 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to learn/understand INDEX, INDIRECT, FIND, MATCH, OFFSET functio

Re: $$Excel-Macros$$ How to learn/understand INDEX, INDIRECT, FIND, MATCH, OFFSET functions?

2012-07-18 Thread NOORAIN ANSARI
Dear Indrajit, Please visit on http://www.cpearson.com/excel/ArrayFormulas.aspx there are a lots of good example of Index,Indirect and offset, You can learn many things from here. On Wed, Jul 18, 2012 at 3:09 AM, Indrajit $nai wrote: > Hi All, > > Tell me some easiest way to learn/understand

$$Excel-Macros$$ Put items numbers to a BOQ

2012-07-18 Thread Dilan De Silva
Dear friends, I'm looking a macro to put items numbers to a BOQ. My requirements as below. If Quantity = " " then Item nr = "" Else For page 1 to last page Item nr should be a letter (Starting from A on each page and if reached to Z within a page, next nrs should be AA, AB….). End See the atta