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
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
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
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
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
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
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
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
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
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
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
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
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
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!
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.
>
>
>
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é.
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
17 matches
Mail list logo