Dear Jitender,
Use the mail merge option in the word
On Sat, Feb 12, 2011 at 9:38 PM, Jitender kumar jk9779771...@gmail.comwrote:
Dear Excel Gurus,
Urgent help required from your part, Plz help me on the file attached.
Problem in file
Thanks in advance
Regards
Jitender
--
please Provide Macro Code...
File is Attached...
--
Looking forward to receive your kind attention.
Thanks Best Regards
M.Rashid.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
use this code in sheet 1
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If Target.Column = 1 And Target.Row = 3 Then
Sheets(2).Activate
Sheets(2).Cells(2, 1).Select
End If
End Sub
On Mon, Feb 14, 2011 at 12:48 PM, rashid memon mr.rashidme...@gmail.comwrote:
I'm not sure what your Import_fromregister macro is doing,
so I'm not sure whether the sheet name needs to be a public variable.
But this should loop through the months:
Sub Update_sheets_All()
Dim M, ShtName
For M = 1 To 12
ShtName = Format(M /1/2011, )
If
I'm still not sure what you're trying to do.
Your original data looked something like:
A;11;21;31;1
B;12;22;32;2
C;13;23;33;3
D;14;24;34;4
E;15;25;35;5
F;16;26;36;6
G;17;27;37;7
H;18;28;38;8
I;19;29;39;9
You split it into separate columns, using ; as a delimeter..
Now you're saying that you want
Let me know if you need any help.
Paul
From: Rajesh K R rajeshkainikk...@gmail.com
To: excel-macros@googlegroups.com
Sent: Sun, February 13, 2011 7:08:16 AM
Subject: Re: $$Excel-Macros$$ Insert raw based on condition in a range
Hi Paul
Thanks for the code, I
This is Off Topic (I put OT in the title)
Technically, to keep from hijacking a thread
if you wish to continue this discussion,
we ought to start a separate topic
Or take it off-line (email between the two of us)
However, since others might be interested, I'll mention it here...
You CAN load a
attached herewith rashi querry sheet. Please provide me formula and help.
--
Nemi Gandhi
98204 92963
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Hello
Whan you import data from SQL you have the query wizard and just
before it ends importing data form SQL to excel
it asks you to go directly to excel or EDIT IN MICROSOFT QUERY , if
you choose editing in microsoft query you can specify and add terms
where you specify which data from which
Dear Sir,
Formula required for nos. of sundays between two days.
e.g. if an employee has joined on 18/7/2010, how many sundays between 18/7/2010
and 31/01/2011.
Thanks Regards.
--
--
Some important links for
see if it helps
On Mon, Feb 14, 2011 at 5:15 PM, Nemi Gandhi nemigan...@gmail.com wrote:
attached herewith rashi querry sheet. Please provide me formula and help.
--
Nemi Gandhi
98204 92963
--
--
Some
start date in a1
and end date in a2
no of sundays =INT(((A2-A1)-NETWORKDAYS(A1,A2))/2)+1
On Mon, Feb 14, 2011 at 6:04 PM, N Pradhan nalini.pradha...@gmail.comwrote:
Dear Sir,
Formula required for nos. of sundays between two days.
e.g. if an employee has joined on 18/7/2010, how many
This isn't EXACTLY the same problem.
In your original post, you were selecting a range from EMP REG
and then selecting a monthly sheet and running an external macro called
Import_fromregister.
In THIS file, all you're doing is copying range B2-O200 of sheet ITEM MASTER
to each sheet.
This
Hi Paul
Thanks for reply, still I have a problem in it I copy the code u
suggested but it updated the sheet JANUARY only. why please check
once more.
Regards
Rajesh kainikkara
On 2/14/11, Paul Schreiner schreiner_p...@att.net wrote:
This isn't EXACTLY the same problem.
In your original post,
Yes exactly like you demonstrated :), sorry for my poor explanation, i can
do it if i separate first to columns, but can it be done all at the same
time?
2011/2/14 Paul Schreiner schreiner_p...@att.net
I'm still not sure what you're trying to do.
Your original data looked something like:
Check if mine is ok for you
Thanks,
Sundarvelan,
9600160150
On Mon, Feb 14, 2011 at 8:08 PM, ashish koul koul.ash...@gmail.com wrote:
see if it helps
On Mon, Feb 14, 2011 at 5:15 PM, Nemi Gandhi nemigan...@gmail.com wrote:
attached herewith rashi querry sheet. Please provide me formula
Hi all experts,
Please resolve my query by formula. sheet attached.
Regards,
Aamir Shahzad
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Hi Team,
I need a graphs in the attached file and need a formula to add the total
time spend.
Any quick help will be appreciated.
Regards,
Vin
--
--
Some important links for excel users:
1. Follow us on TWITTER for
if i seclare variable like this
dim abc
is this array or variant or something else. if array the what data type
i have code in my office (somebody else's code) where variables are declared
like this and i thought these are variants but after going through paul's mail
chain i guess those are
also pls tell me if dim abc is array then
does dim abc is equal to dim abc() ?
From: hanumant shinde hanumant_5...@yahoo.co.in
To: excel macros excel-macros@googlegroups.com
Sent: Tue, 15 February, 2011 1:38:21 AM
Subject: Array or Variant ???
if i seclare
On Tue, Feb 15, 2011 at 12:16 AM, Aamir Shahzad aamirshahza...@gmail.comwrote:
Hi all experts,
Please resolve my query by formula. sheet attached.
Regards,
Aamir Shahzad
--
--
Some important links for
In your VBA Object Explorer, you'll see
Sheet1(Name1)
Sheet2(Name2)
Sheet3(Name3)
If you delete the sheet named Name2, create a new sheet, and call the NEW
sheet Name2
It won't be:
Sheet2(Name2), it'll be:
Sheet4(Name2).
So the LIST will be:
Sheet1(Name1)
Sheet3(Name3)
Sheet4(Name4)
in VBA
Array and Variant is like saying
Is this apple Red or Peeled?
I think what you really want to know is if
Dim ABC
declares a single value variable or array.
Because, without defining a type, the default
data type is Variant. That means that:
Dim ABC
is the same as:
Dim ABC as Variant
and
Dim
Hi Paul,
I have also noticed that after deleting and creating sheets, the Sheet numbers
are out of order, and can be missing altogether. ie in a workbook of 7 sheets,
one of them may be Sheet(11), while sheets 8 and 9 are not present at all.
So, my question is, why does this line of code
I'm starting to write some code in VB (may end up as vbscript, or vb) and
would like to understand how the proper way to get all the internal
constants declared? A couple of examples might include xlDayofWeek or
vbCRLF. Do I include a header file that defines them for me?
Thank for your
How I can load a image from a url using the LoadPicture function in
userform.
Regards,
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
in editor press F2 you will get all
On Tue, Feb 15, 2011 at 11:13 AM, Jeff jeffvanderd...@gmail.com wrote:
I'm starting to write some code in VB (may end up as vbscript, or vb) and
would like to understand how the proper way to get all the internal
constants declared? A couple of examples
27 matches
Mail list logo