cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Wed, Nov 26, 2014 at 11:36 AM, Ganesh N wrote:
> Thanks bro!!
>
> On Wed, Nov 26, 2014 at 10:45 AM, Vaibhav Joshi wrote:
>
>> hi
>>
>> when you multiply by 1, xl converts it to date.
>>
>> Try this in excel,
Dear son nguyen,
PFA
Regards,
Ganesh N
On Wed, Nov 26, 2014 at 10:03 AM, Ganesh N wrote:
> Dear son nguyen,
>
> Before putting the my formula just have sort in start time.
>
> Regards,
> Ganesh N
>
> On Wed, Nov 26, 2014 at 10:01 AM, Ganesh N wrote:
>
>> Dear son nguyen,
>>
>> Try this formul
Thanks bro!!
On Wed, Nov 26, 2014 at 10:45 AM, Vaibhav Joshi wrote:
> hi
>
> when you multiply by 1, xl converts it to date.
>
> Try this in excel, put this formula cell E2 =DATE(20&RIGHT(D2,2),3,31),
> now goto format cell & change date format to dd/mmm/yy or any other format,
> result wont cha
hi
when you multiply by 1, xl converts it to date.
Try this in excel, put this formula cell E2 =DATE(20&RIGHT(D2,2),3,31), now
goto format cell & change date format to dd/mmm/yy or any other format,
result wont change.
Now in next celll put formula =E2*1 & now goto format cell & change date
form
Dear son nguyen,
Before putting the my formula just have sort in start time.
Regards,
Ganesh N
On Wed, Nov 26, 2014 at 10:01 AM, Ganesh N wrote:
> Dear son nguyen,
>
> Try this formula... Let me know if you have any concern.
>
> Thanks & Regards,
> Ganesh N
>
> On Tue, Nov 25, 2014 at 7:07 PM,
Dear son nguyen,
Try this formula... Let me know if you have any concern.
Thanks & Regards,
Ganesh N
On Tue, Nov 25, 2014 at 7:07 PM, Paul Schreiner
wrote:
> Can you send me a sample file?
>
> Otherwise, I'll probably spend far too much time trying to recreate
> something that doesn't apply to
Hi Paul,
I'm sorry as my past explain isn't clear for you.Please see enclosed file
and hope that i'll receive excellent solution of all of you.
Thanks a lot
Son
2014-11-25 20:37 GMT+07:00 Paul Schreiner :
> Can you send me a sample file?
>
> Otherwise, I'll probably spend far too much time try
Thanks Vaibhav ji,
Got it. But can you pls explain how this works =DATE(20&RIGHT(D2,2),3,31)*1
Thanks a lot!
Regards,
Ganesh N
On Tue, Nov 25, 2014 at 8:17 PM, Vaibhav Joshi wrote:
> hi
>
> check this...
>
> In blue i have given formula using helper columns & in yellow its direct
> one..
>
> C
Can anyone please have a look?
Lax
On Tuesday, November 25, 2014 8:52:45 PM UTC+5:30, Laxmanan M wrote:
>
> Can anyone please have a look as I have done with the code.Need help on
> the amendment part as am fearing that code will break if I make amendment
> with out getting guidance from the ex
Can anyone please have a look as I have done with the code.Need help on the
amendment part as am fearing that code will break if I make amendment with out
getting guidance from the experts here.
Lax
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:
hi
check this...
In blue i have given formula using helper columns & in yellow its direct
one..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Fri, Nov 21, 2014 at 4:50 PM, Ganesh N wrote:
> Dear Mandeep,
>
> Please see the header I mean the financial y
Dear Paul!
Thank you so much for your kind help!
i don't have any experience with macros...
the columns are "Child's Name" and "B-Day" (the ones in English
Client 1: https://www.dropbox.com/s/xxuu1520hpqpu56/Client1.png?dl=0
Client 2: https://www.dropbox.com/s/d9qyqmk5mdivovv/Client2.png?dl=0
Army
Can you send me a sample file?
Otherwise, I'll probably spend far too much time trying to recreate something
that doesn't apply to your situation.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you c
it sounds like you need SPECIFIC help.
That is, you need a macro that looks at your specific file and manages the
records.
In order to do something like that, I'd need some sample info.
otherwise, my macro will be looking at columns that don't exist, or are
something else, in your file.
If you
OK, here's an approach:
The concept is this:
you only have to identify ONE cell in the row, then use the
.EntireRow.Select
method.
You recognized that you could use:
Range(1:1,3:3,5:5)
but you could also use:
Range("A1,A3,A5").EntireRow.Select
So, the trick here is to somehow create an array
thank you so much Paul!
but i will need a bit more explanations because I am very new to using
excel on this level :)
the columns are "Name" and "B-Day"
i open one worksheet for each client with his personal information. among
this info i have kids (if any) names and their b-days.
i need to collect
Hi
Try this...
You need to mention your actual sheet names & work book name along with
path in VB module..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Tue, Nov 25, 2014 at 1:02 PM, Sara Lee wrote:
> I have a excel file which has 3 tabs by name A,B
What experience do you have with VBA?
What columns contain the data?
what makes the record "unique"
Here's what I would do:
Copy the first sheet to make the "Summary" page.
then use:
Option Explicit
Sub UniqueNames()
Dim sCnt As Integer
Dim rCnt As Integer
Dim R As Integer
D
Sheet required !!
On Tuesday, November 25, 2014 5:49:28 PM UTC+5:30, Maria Carmel wrote:
>
> Hello,
> i need help with creating a "name and b-day" list that accumulates data ()
> from different worksheets of one excel file.
> new worksheets added constantly with the same columns (among them name
I'm sure there's more information that you're not telling us.
What column has the "Chas" data?
is "Chas" the same column in all tabs? or does the macro have to locate it?
I created two files with the mentioned sheet names and put about 1000 random
numbers in each sheet.
Then I created the fo
Hello,
i need help with creating a "name and b-day" list that accumulates data ()
from different worksheets of one excel file.
new worksheets added constantly with the same columns (among them names and
b-days)
i need that all the new data from new worksheets will be added to the same
one "name
Thanks Paul, thanks for your code I got another one :)
Sub ProcessFiles()
Dim Filename, Pathname As String
Dim wb As Workbook
Pathname = "C:\Users\pc\Desktop\nov\NOV 01ST TO 19TH\"
Filename = Dir(Pathname & "*.xlsx")
Do While Filename <> ""
Workbooks.Open (P
PLs have a look anyone?
Lax
On Tuesday, November 25, 2014 3:45:17 PM UTC+5:30, Laxmanan M wrote:
> Dear Anil,
>
> I have attached 2 attachments in the first post of the same thread.one
> macro file and another one word document.please have a look in the same
> post.
>
> Kind regards,
> Lax
It worked fine for me, until I found a file that had an "issue".
you could try something like:
Sub ProcessFiles()
Dim fso, fld, fc, f
Dim fldr, ext
On Error GoTo BadExit
Set fso = CreateObject("Scripting.FileSystemObject")
fldr = "C:\temp\vba\"
If (fso.folderexists(fldr)
Dear Paul,
Thank you same as working properly.
Thanks & Regards,
Sriram.
On Tue, Nov 25, 2014 at 5:04 PM, Paul Schreiner
wrote:
> Do you mean like:
> =IF(AND(C5>1.1,C8>1.1),0.8,C10/C4)
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the m
Dear Sriram,
find the attached file.
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Tuesday, November 25, 2014 4:52:28 PM UTC+5:30, sriram ji wrote:
>
> Dear Guru's
>
> If Forecast Deviation & Answere
Do you mean like:
=IF(AND(C5>1.1,C8>1.1),0.8,C10/C4)
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
Don't worry I am not imposing this code on you to handle. I just want an
idea for doing this. This is about to highlight some rows data with the
help of conditional formatting. numerous of files reside in directory. I
want to iterate each file with the help of code which is working correctly.
Dear Guru's
If Forecast Deviation & Answered on forecast is >= 110% it must shown as
"80%" or else Answered with TH / Net call Offered. Please Help me.
[image: Inline image 1]
Thanks & Reargds,
Sriram
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N
Dear Sriram,
Update your existing 2003 version excel file to 2007 by using convert
option in ribbon so that you can do vlookup. Image attached for your
reference.
Please feel free to contact for more information.
On Mon, Nov 24, 2014 at 10:16 PM, Paul Schreiner
wrote:
> I suspect the issue you
Sub ProcessFiles()
Dim Filename, Pathname As String
Dim wb As Workbook
Pathname = "C:\Users\pc\Desktop\nov\NOV 01ST TO 19TH\"
Filename = Dir(Pathname & "*.xlsx")
Do While Filename <> ""
Workbooks.Open (Pathname & Filename)
Filename = Dir()
Loop
En
Dear Anil,
I have attached 2 attachments in the first post of the same thread.one macro
file and another one word document.please have a look in the same post.
Kind regards,
Lax
--
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 F
Does anyone has another code except this to loop files in folder and
perform operation on that file. ?? this code is correct but i want
different one.
Sub ListFiles()
Dim bookList As Workbook
Dim mergeObj As Object, dirObj As Object, filesObj As Object, everyObj As
Object
Application.ScreenUp
Dear Laxmanan,
attachment is not there
On Tue, Nov 25, 2014 at 12:32 PM, Laxmanan M wrote:
> can any one pls?
> On Monday, November 24, 2014 7:44:09 PM UTC+5:30, Laxmanan M wrote:
>>
>> Hi All,
>>
>> I have done with the macro code for the Vendor file validation.But i need
>> to make some amen
this is using mod function...
Sub SelectRows3X_2()
Dim r As Range
Dim c As Range, rng As Range, lRng As Range
Set r = Cells(1, 1)
Set lRng = Range("A" & Rows.Count).End(xlUp)
Set rng = Range(r.Address, lRng.Address)
'Debug.Print rng.Address
For Each c In rng
If c.Row Mod 3 = 1 Then
Set r = Union(r
Vabz you were absolutely correct. One thing i appreciate you can easily
understand the point of view of the query.
On Tuesday, November 25, 2014 1:49:32 PM UTC+5:30, Vabz wrote:
>
> I didnt get you?, do you want it without help of code?
>
> +
> *I did not do this for you. God is here working
I didnt get you?, do you want it without help of code?
+
*I did not do this for you. God is here working through me for you.*
On Tue, Nov 25, 2014 at 12:51 PM, Mandeep Baluja
wrote:
> I just want to know whether it's is possible with the help of code or not.
> I can achieve the same with th
37 matches
Mail list logo