Re: $$Excel-Macros$$ Re: Delete As per criteria

2013-05-08 Thread Chaya
Thanks Abhishek , it is perfect deleting all the row as per cireria. Regards, Chaya On Thu, May 9, 2013 at 12:08 PM, Abhishek Jain wrote: > Attached. > > On Thu, May 9, 2013 at 11:58 AM, Chaya wrote: > >> Dear Abhishek, >> >>I have a query for deleting entire row as per criteria basis. e

$$Excel-Macros$$ Re: Delete As per criteria

2013-05-08 Thread Abhishek Jain
Attached. On Thu, May 9, 2013 at 11:58 AM, Chaya wrote: > Dear Abhishek, > >I have a query for deleting entire row as per criteria basis. example > where ever there is word called "Total", the entire row should be deleted. > > Please help, i have attached my file. please find. > > Many tnx

Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer

2013-05-08 Thread Mathan
Hi David/Anil, We are trying to upload the excel file through excel vba. The files are from common shared folder not on the local drive. I hope this helps, However, I will share the screenshot by tonight. Thanks for your time. Thanks On Thu, May 9, 2013 at 10:11 AM, David Grugeon wrote: > I

Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer

2013-05-08 Thread David Grugeon
IN particular we need to know what type of file is it that you want to "Upload". Is it an internet file like .html, .asp .php etc or is it an excel XLS file, xlsm, xlsb, etc. or perhaps a different type. Then we need to know if there is an internet server running on the site where the file is loc

Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer

2013-05-08 Thread अनिल नारायण गवली
Dear Manthan, Pls Elaborate More with Eg. Warm Regards, Gawli Anil On Thu, May 9, 2013 at 2:26 AM, Mathan wrote: > Hi Experts, > > I'm trying to upload a file from shared folder (directory) to the internet > explorer. > > Need a VBA code to do this. Could anyone help me on this? > > Thanks i

$$Excel-Macros$$ Re: Critical Query..........

2013-05-08 Thread अनिल नारायण गवली
Dear Kuldeep, Pl find attachment. Warm Regards, Gawli Anil. On Wed, May 8, 2013 at 7:37 PM, Kuldeep Singh wrote: > Hi Experts, > > I have a query, if sheet name is similar, how can create a hyperlink. > query is attached. > > I want to via VBA. > > Regards, > Kuldeep > > -- > You received this

Re: $$Excel-Macros$$ Merge cell To Repeat cell value

2013-05-08 Thread Chaya
Dear Abhishek, Sorry for the late reply. Yes, the solution provided to me its perfectly working. thank you. Regards, Chaya On Wed, May 8, 2013 at 6:57 PM, Abhishek Jain wrote: > Here. > > On Wed, May 8, 2013 at 6:23 PM, Chaya wrote: > >> Dear Experts >> >>I have a

Re: $$Excel-Macros$$ Merge cell To Repeat cell value

2013-05-08 Thread Prafull Jadhav
Dear Abhishekji, Can you provide the code with comments ... On Wed, May 8, 2013 at 6:57 PM, Abhishek Jain wrote: > Here. > > > On Wed, May 8, 2013 at 6:23 PM, Chaya wrote: > >> Dear Experts >> >>I have a query where the sheets have a huge number of merged >> cells. Now i want to r

Re: $$Excel-Macros$$ Help plz

2013-05-08 Thread अनिल नारायण गवली
Dear Sajid, Pl Elaborate more on this. didn't understood. Pl give eg. in the attachment. Warm Regards, Gawli Anil On Wed, May 8, 2013 at 6:23 PM, SAJID MEMON wrote: > Dear Anil sir, > I have seen attachment file, Thanx for responce me. but it's not my > solution. My problem is if database s

$$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer

2013-05-08 Thread Mathan
Hi Experts, I'm trying to upload a file from shared folder (directory) to the internet explorer. Need a VBA code to do this. Could anyone help me on this? Thanks in advance. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Face

Re: $$Excel-Macros$$ Need City in Blanck Coloume.

2013-05-08 Thread David Grugeon
Priti, You are absolutely right. It is up to the person who raised the query to test sugestested solutions and respond. If it is not working to say in what respect it is not working, If it is working to acknowledge that. Regards David Grugeon On 8 May 2013 22:16, priti verma wrote: > Dear

Re: $$Excel-Macros$$ Critical Query..........

2013-05-08 Thread ashish koul
=HYPERLINK("#'"&A2&"'!a1","Click Here to Visit " & A2) On Wed, May 8, 2013 at 7:37 PM, Kuldeep Singh wrote: > Hi Experts, > > I have a query, if sheet name is similar, how can create a hyperlink. > query is attached. > > I want to via VBA. > > Regards, > Kuldeep > > -- > Are you =EXP(E:RT) or =N

$$Excel-Macros$$ Critical Query..........

2013-05-08 Thread Kuldeep Singh
Hi Experts, I have a query, if sheet name is similar, how can create a hyperlink. query is attached. I want to via VBA. Regards, Kuldeep -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.

Re: $$Excel-Macros$$ Merge cell To Repeat cell value

2013-05-08 Thread Abhishek Jain
Here. On Wed, May 8, 2013 at 6:23 PM, Chaya wrote: > Dear Experts > >I have a query where the sheets have a huge number of merged > cells. Now i want to remove all the merged cell and transform into its > corresponding names for entire active sheets. > Can it be done with

$$Excel-Macros$$ Merge cell To Repeat cell value

2013-05-08 Thread Chaya
Dear Experts I have a query where the sheets have a huge number of merged cells. Now i want to remove all the merged cell and transform into its corresponding names for entire active sheets. Can it be done with formula or macros. Please find the attachment, i have elabr

RE: $$Excel-Macros$$ Help plz

2013-05-08 Thread SAJID MEMON
Dear Anil sir, I have seen attachment file, Thanx for responce me. but it's not my solution. My problem is if database sheet's cell text are links with hyperlink, that same hyperlink should access from home sheet. (Give the code about hyperlinks)Awaiting your reply . Sajid Date: Tue, 7 May 2013

Re: $$Excel-Macros$$ Need City in Blanck Coloume.

2013-05-08 Thread priti verma
and one more thing "best solutions" with no acknowledgement whatsoever" On Wed, May 8, 2013 at 5:46 PM, priti verma wrote: > Dear Sant Ram, > > You may note that in the original query there was nothing related to the > sorting and I tried to apply a different and simple approach which works > w

Re: $$Excel-Macros$$ Need City in Blanck Coloume.

2013-05-08 Thread priti verma
Dear Sant Ram, You may note that in the original query there was nothing related to the sorting and I tried to apply a different and simple approach which works without the sorting so the solution is not "inoperable" and if the data is not sorted, it is not "temporary" also. You can find problems

Re: $$Excel-Macros$$ Need City in Blanck Coloume.

2013-05-08 Thread priti verma
Thanks for your suggestion, i know what i need to do .. On Wed, May 8, 2013 at 5:05 PM, Sant Ram wrote: > Exactly Priti you are right but your formula is not working ... as i > observe that you are just want increase your post count .. > > in this group we will try to provide top best solu

Re: $$Excel-Macros$$ Need City in Blanck Coloume.

2013-05-08 Thread Sant Ram
Exactly Priti you are right but your formula is not working ... as i observe that you are just want increase your post count .. in this group we will try to provide top best solution not a temporary solution I totally agree with sunny... On Wed, May 8, 2013 at 5:04 PM, Sant Ram wrote: > Exa

Re: $$Excel-Macros$$ Need City in Blanck Coloume.

2013-05-08 Thread Sant Ram
Exactly Priti you are right but your formula is not working ... as i observe that you are just want increase your post count .. in we will provide top best solution not a temporary solution I totally agree with sunny... On Wed, May 8, 2013 at 11:26 AM, priti verma wrote: > Hi Sunnny , > somet

Re: $$Excel-Macros$$ Highting number

2013-05-08 Thread Abhishek Jain
Updated attached. On Wed, May 8, 2013 at 12:33 PM, Chaya wrote: > Abhishek sir, > >The second solution provided to me is fine but- > firstly - if i put 2 then all the number greater than 2 will mark as red, > again while putting 5 than it will also mark as red as well 2 also, > >genera

Re: $$Excel-Macros$$ Highting number

2013-05-08 Thread Chaya
Abhishek sir, The second solution provided to me is fine but- firstly - if i put 2 then all the number greater than 2 will mark as red, again while putting 5 than it will also mark as red as well 2 also, generally only 5 should be mark as red not 2 while putting 5 in M2 cells. Hope you un