Re: $$Excel-Macros$$ Price Download from NSE - Urgent

2012-02-19 Thread airen
Hi Priyanka, Can you give me the link from where I can download this Odin. I tried it on net but unable to find it out. Thanks Akhilesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help,

$$Excel-Macros$$ Help with code please.

2012-02-19 Thread Bob
I almost have the code the way I need it. BUT I want it to Find everything within in the same Workbook, not just on the Index Worksheet. Thanks in advance!!! Private Sub CommandButton1_Click() Dim IndividualSearch As String IndividualSearch = InputBox(What's the part number you're looking for?,

Re: $$Excel-Macros$$ RE: Mr. Don I am really really really thankful to u for help!

2012-02-19 Thread dguillett1
Glad to help. Noorain’s also worked just fine using formulas. I prefer using macros for this Don Guillett SalesAid Software dguille...@gmail.com From: Mohammed Muneer Sent: Saturday, February 18, 2012 10:04 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ RE: Mr. Don I am

Re: $$Excel-Macros$$ Conditional formatting

2012-02-19 Thread PRAVESH KUMAR
Hi, Please Help. On Sat, Feb 18, 2012 at 12:38 PM, PRAVESH KUMAR praveshkash...@gmail.comwrote: HI, Please help...for conditional formatting PFA attached file Thanks Pravesh Kashyap -- FORUM RULES (986+ members already BANNED for

Re: $$Excel-Macros$$ Help with code please.

2012-02-19 Thread dguillett1
If you are saying you want to look for it on all sheets you can wrap in a loop for each ws in worksheets ws.Select Cells.Find(What:=IndividualSearch, LookIn:=xlValues,LookAt:=xlWhole).Activate next ws Or, are you saying there could be more than ONE hit?? BTW you don't need to select to work

Re: $$Excel-Macros$$ I Macros tutorial software need

2012-02-19 Thread NOORAIN ANSARI
Dear vijay, IMacro is a software you can learn it through study material. But i can't say any thing regarding good future. On Sun, Feb 19, 2012 at 12:22 AM, vijayajith VA vijayajith...@gmail.comwrote: Hi, Is thr good future in learning Imacros? Thanks On Fri, Feb 17, 2012 at 11:12 PM,

Re: $$Excel-Macros$$ Conditional formatting

2012-02-19 Thread Excel_Lover
Dear, Hope you are stuck in blank cells formatting, this can be done as follows, In Excel 2007, Conditional formatting = Highlight Cell Rules = Equal to, type formula =(not just ) On Sun, Feb 19, 2012 at 4:41 PM, PRAVESH KUMAR praveshkash...@gmail.comwrote: Hi, Please

Re: $$Excel-Macros$$ how to find a text in a folder

2012-02-19 Thread raghu gr
Sir, Sir some error in line, Set a = wk.Cells.Find(What:=* ThisWorkbook.Sheets(File Names).Range(c2).Value *, After:=wk.Cells(1, 1), _ LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, _ SearchDirection:=xlNext, MatchCase:=False) pls help me. Thank you Raghu -- FORUM RULES (986+

Re: $$Excel-Macros$$ Conditional formatting

2012-02-19 Thread Excel_Lover
Sorry,The formula should be = (with a space) like this, as there is formulas in your sheet. On Sun, Feb 19, 2012 at 9:08 PM, Excel_Lover idforex...@gmail.com wrote: Dear, Hope you are stuck in blank cells formatting, this can be done as follows, In Excel 2007, Conditional formatting =

Re: $$Excel-Macros$$ I Macros tutorial software need

2012-02-19 Thread Maries
http://wiki.imacros.net/Main_Page On Sun, Feb 19, 2012 at 8:46 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear vijay, IMacro is a software you can learn it through study material. But i can't say any thing regarding good future. On Sun, Feb 19, 2012 at 12:22 AM, vijayajith VA

$$Excel-Macros$$ search via macro like excel

2012-02-19 Thread Prajakt Pande
Dear all, Roll on codes are maximum 8 digits, I want to search via roll on codes, at least 4 digits, Where ever it matches with sequence, need to update the other information in respective field, with next and previous option, If “Roll on code” is not available then search via NAME. Sheet

$$Excel-Macros$$ Update Data in Excel sheets from Master file

2012-02-19 Thread Prasad Gadgil
*Dear Friends,* I am having data in master sheet wish to different sheets based on Name of the party as and when i update master sheet* Thanks Regards* *Prasad Gadgil* Cell: 9819442088 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor

Re: $$Excel-Macros$$ combo box or list box help

2012-02-19 Thread Prajakt Pande
Dear Noorain, Thnak for your help On Feb 16, 9:12 pm, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Prajakt, Please see attached sheet with explanation. On Thu, Feb 16, 2012 at 5:04 PM, Prajakt Pande prajakt.pa...@gmail.comwrote: Dear, Good job, can you tell me how you made

$$Excel-Macros$$ Hi, Friends I have a ?

2012-02-19 Thread Mohammed Muneer
How to merge the Multiple Macro's in single program? If my data is like this: (with Filter buttons are on): (filtering process taken up in anyway with the help of the Cell reference (or) Button. Its u r choice). Ename Start Date End Date Hours wor Tot pay Ded Net pay

$$Excel-Macros$$ Hi, Friend I have a ? (I did not express properly in my previous mail - so let us have it right now)....

2012-02-19 Thread Mohammed Muneer
How to merge the Multiple Macro's in single program? My question is little jovial - but still it is trying to learn some thing from u masters. Thanx anyway This is only an example, that I put it here to show u exactly what I want u to help me for. ( in fact, I need the logic - How

Re: $$Excel-Macros$$ search via macro like excel

2012-02-19 Thread Maries
PFA. *Formula - =INDEX(B2:B21,MATCH(TRUE,VALUE(RIGHT(A2:A21,4))=H12,0))* On Sun, Feb 19, 2012 at 12:15 PM, Prajakt Pande prajakt.pa...@gmail.comwrote: Dear all, Roll on codes are maximum 8 digits, I want to search via roll on codes, at least 4 digits, Where ever it matches with sequence,