Re: $$Excel-Macros$$ Replace formulas with values

2014-01-17 Thread Mukesh Kumar
Ashish ji, this code is working on column C only not on column E which also contains formula. As I have said earlier that user form is required which asks for range of cells first where to apply macro? Any help in this regards will be helpful to me. On Sat, Jan 18, 2014 at 12:50 PM, ashish koul

Re: $$Excel-Macros$$ Highlightning spesific cell based on paired value (row-coloumn) compared other table in other sheet

2014-01-17 Thread ashish koul
can you share the sample file On Fri, Jan 17, 2014 at 12:38 PM, Muhammad Hanif Fahyuananto < zetta4e...@gmail.com> wrote: > First, I have 2 worksheet which the first one contain the main table and > the second one contain the report table. > The report is generated from value in 2 coloumns in ma

Re: $$Excel-Macros$$ Replace formulas with values

2014-01-17 Thread ashish koul
Sub test() Dim i As Long For i = 2 To Range("a65356").End(xlUp).Row Range("c" & i).ClearContents Range("c" & i).Formula = "=" & Range("a" & i).Value & "*" & Range("b" & i).Value Next End Sub On Sat, Jan 18, 2014 at 12:24 PM, Mukesh Kumar wrote: > Hi Experts, > > I need your help. My requir

Re: $$Excel-Macros$$ Reinitialising data sheets everytime data on sheet1 is processed in a loop.

2014-01-17 Thread ashish koul
can you share a sample file with exact requirement On Sat, Jan 18, 2014 at 12:30 PM, Shailesh Tupe wrote: > Hi > > I have a list of criteria with which I filter column d and sets up data > for further processing. I keep sheet1 data untouched but copy it to Sheet > 2, 3, 4, 5, 6, 7, filter sheets

$$Excel-Macros$$ Reinitialising data sheets everytime data on sheet1 is processed in a loop.

2014-01-17 Thread Shailesh Tupe
Hi I have a list of criteria with which I filter column d and sets up data for further processing. I keep sheet1 data untouched but copy it to Sheet 2, 3, 4, 5, 6, 7, filter sheets 2, 4 & 6 and copy data to sheets 3, 5 & 7, process filtered data and put data in sheet 8. This I do for each crite

$$Excel-Macros$$ Replace formulas with values

2014-01-17 Thread Mukesh Kumar
Hi Experts, I need your help. My requirement is that I want to replace cell addresses with their respective values (*paste special not required as it will replace whole formula with values)*, e.g. let's say that the formula of cell C2 is =A1+B1, where A1 = 10 and B1 = 20, then I would like to cha

$$Excel-Macros$$ Re: copy file via vba

2014-01-17 Thread pmyk
Try this : [code] Private Sub cmdCopyTextFileToAnotherTextFile_Click() FileCopy "D:\data\sample1.txt", "D:\data\sample2.txt" End Sub [/code] -- 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://ww

RE: $$Excel-Macros$$ batch file Query

2014-01-17 Thread gargee singh
Hello Paul, Thanks for your help with this , this has been more than just helpful. This was exactly what i needed. regarding the 3rd point , i am aware that RUN is an excel Application method and not appropriate for a subroutine name, but i was so tired of not being able to run the batch file

$$Excel-Macros$$ wanna halp in conditional icon set

2014-01-17 Thread Dhaval Shah ( Ahd )
Hello friends I want help in conditional icon set . pls refer attached sheet -- 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.facebook.com/discussexcel FORUM RULES 1) Use conc

$$Excel-Macros$$ Re: Introduce Yourself !!

2014-01-17 Thread Shailesh Tupe
Hi! I am Shailesh Tupe, staying at Pune. I use excel a lot and have developed a liking for macros due to saving of time and make calculations more interesting. As most people do in India, I too love cricket. Thanks & best regard, Shailesh tupe On Saturday, June 9, 2012 12:51:59 AM UTC+5:3

Re: $$Excel-Macros$$ Re: VBA Excel : comment filtrer des données différentes via deux command buttons sans les annuler?

2014-01-17 Thread Ricardo®
Bonjour Mademoiselle Marie, Suivez le fichier joint. S'il vous plaît voir si c'est ce que vous avez besoin; gracieusement Basole. 2014/1/17 marie levrault > Bonjour! > > Alors mon doc est en PJ! > > J'espère que je suis claire dedans :-) > > Merci à vous! > > > > On Fri, Jan 17, 2014 a

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 17 Messages in 9 Topics

2014-01-17 Thread sameera kumarasingha
Dear experts, Can any one help me to write a formula to convert hijra date in to Gregorian date. sameera On Fri, Jan 17, 2014 at 5:04 AM, wrote: > Today's Topic Summary > > Group: http://groups.google.com/group/excel-macros/topics > >- PICK THE PRICES BASING ON START DATE<#1439d67b332

Re: $$Excel-Macros$$ PICK THE PRICES BASING ON START DATE

2014-01-17 Thread Grkrishna Naidu
Greate Ravinder ji thanks a lot RADHA KRISHNA G. On Fri, Jan 17, 2014 at 11:36 AM, Ravinder wrote: > PFA > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Grkrishna Naidu > *Sent:* Thursday, January 16, 2014 9:45 PM > *To:* excel-macros@goog

Re: $$Excel-Macros$$ Re: VBA Excel : comment filtrer des données différentes via deux command buttons sans les annuler?

2014-01-17 Thread Ricardo®
bonjour Mariey, pourrait partager votre feuille de calcul avec des données fictives et aussi comme un exemple du résultat désiré? Merci. 2014/1/17 > Bonjour itware2008, > > J'ai finalement trouvé la solution! > Par contre, je bute face à un autre problème. Peut-être pourriez-vous > m'aider!

Re: $$Excel-Macros$$ Re: VBA Excel : comment filtrer des données différentes via deux command buttons sans les annuler?

2014-01-17 Thread marie levrault
Bonjour! Alors mon doc est en PJ! J'espère que je suis claire dedans :-) Merci à vous! On Fri, Jan 17, 2014 at 4:39 PM, Ricardo® wrote: > bonjour Mariey, > > pourrait partager votre feuille de calcul avec des données fictives et > aussi comme un exemple du résultat désiré? > > Merci. > > >

$$Excel-Macros$$ Re: VBA Excel : comment filtrer des données différentes via deux command buttons sans les annuler?

2014-01-17 Thread marie . levrault
Bonjour itware2008, J'ai finalement trouvé la solution! Par contre, je bute face à un autre problème. Peut-être pourriez-vous m'aider! J'ai créé une zone de liste déroulante à sélection multiple. J'aimerais qu'en sélectionnant plusieurs items, ces derniers apparaissent dans des cellules à côté.

$$Excel-Macros$$ Re: VBA Excel : comment filtrer des données différentes via deux command buttons sans les annuler?

2014-01-17 Thread itware2008
Bonjour, Vous pouvez envoyer un exemple de ce que vous voulez, et le code VBA que vous utilisez? Merci, Vândalo Domingo, 5 de Janeiro de 2014 17:57:50 UTC, marie.l...@gmail.com escreveu: > > Bonjour > > Je souhaiterais sur un même tableau filtrer à partir de deux > commandbuttons des données