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 rockerna...@gmail.com
wrote:
I just want to know whether it's is possible with the help of code or not.
I can
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
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,
Dear Laxmanan,
attachment is not there
On Tue, Nov 25, 2014 at 12:32 PM, Laxmanan M laxflyflow...@gmail.com 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
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
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
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
End Sub
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 schreiner_p...@att.net
wrote:
I
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:OW)
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.
Do you mean like:
=IF(AND(C51.1,C81.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
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 Answered on
Dear Paul,
Thank you same as working properly.
Thanks Regards,
Sriram.
On Tue, Nov 25, 2014 at 5:04 PM, Paul Schreiner schreiner_p...@att.net
wrote:
Do you mean like:
=IF(AND(C51.1,C81.1),0.8,C10/C4)
*Paul*
-
*“Do all the good you can,By
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))
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
--
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 (Pathname
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
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
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 names
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
Dim
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 lee.sar...@gmail.com wrote:
I have a excel file which has
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
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
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
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
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:
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 ganeshg...@gmail.com wrote:
Dear Mandeep,
Please see the header I
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
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
Thanks Vaibhav ji,
Got it. But can you pls explain how this works =DATE(20RIGHT(D2,2),3,31)*1
Thanks a lot!
Regards,
Ganesh N
On Tue, Nov 25, 2014 at 8:17 PM, Vaibhav Joshi v...@vabs.in wrote:
hi
check this...
In blue i have given formula using helper columns in yellow its direct
one..
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 schreiner_p...@att.net:
Can you send me a sample file?
Otherwise, I'll probably spend
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 schreiner_p...@att.net
wrote:
Can you send me a sample file?
Otherwise, I'll probably spend far too much time trying to recreate
something
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 ganeshg...@gmail.com wrote:
Dear son nguyen,
Try this formula... Let me know if you have any concern.
Thanks Regards,
Ganesh N
On Tue, Nov 25, 2014
hi
when you multiply by 1, xl converts it to date.
Try this in excel, put this formula cell E2 =DATE(20RIGHT(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
format
Thanks bro!!
On Wed, Nov 26, 2014 at 10:45 AM, Vaibhav Joshi v...@vabs.in wrote:
hi
when you multiply by 1, xl converts it to date.
Try this in excel, put this formula cell E2 =DATE(20RIGHT(D2,2),3,31),
now goto format cell change date format to dd/mmm/yy or any other format,
result wont
Dear son nguyen,
PFA
Regards,
Ganesh N
On Wed, Nov 26, 2014 at 10:03 AM, Ganesh N ganeshg...@gmail.com 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 ganeshg...@gmail.com wrote:
Dear son
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 ganeshg...@gmail.com wrote:
Thanks bro!!
On Wed, Nov 26, 2014 at 10:45 AM, Vaibhav Joshi v...@vabs.in wrote:
hi
when you multiply by 1, xl converts it to date.
37 matches
Mail list logo