Please see attached file
By Chilexcel
2011/5/10 Rajesh K R
> Hi Experts
> Pls check the attached file and tell me how to consolidate date month wise.
>
> Regards
>
> Rajesh Kainikkara
>
> --
>
> --
> Some importan
check the attachemnt
see if it helps
On Wed, May 11, 2011 at 2:08 AM, Rajesh K R wrote:
> Hi Experts
> Pls check the attached file and tell me how to consolidate date month wise.
>
> Regards
>
> Rajesh Kainikkara
>
> --
>
> -
Hi Experts
Pls check the attached file and tell me how to consolidate date month wise.
Regards
Rajesh Kainikkara
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http:
to find total ---
=INDEX($C$12:$K$12,0,MATCH($N$2,$C$2:$K$2,0))
On Tue, May 10, 2011 at 5:39 PM, Rohan Young wrote:
> Thanks Ashish Ji,
>
> as i knew that i will got the answer first from your side, but 1 more
> thing if i do not have column A (skilled & unskilled type), in that
>
i would like say thanks for new tips for me i haven't tried it as if
now i am doing it through formula "IF" itself however to automate this
work if possible could help me to write a macro.
On 5/10/11, ashish koul wrote:
> see if it helps
>
> On Tue, May 10, 2011 at 12:13 PM, Born to Win wrote:
Thanks Ashish Ji,
as i knew that i will got the answer first from your side, but 1 more thing
if i do not have column A (skilled & unskilled type), in that situation what
is the formula?
please reply
Thanks & Regds
ROHAN
On Tue, May 10, 2011 at 5:16 PM, ashish koul wrote:
> =SUMPRODUCT(--($
Dear Mr. Rohan,
Please check the attached file (formula in red font), if it fulfills your
needs.
Regards,
ZAFAR IQBAL
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rohan Young
Sent: Tuesday, May 10, 2011 8:48 AM
To: excel-macros@googlegroups.com
S
http://akoul.blogspot.com/search/label/Sending%20a%20Range%20as%20attachment%20in%20mail%20though%20Excel%20VBA
try this if it helps
On Mon, May 9, 2011 at 9:20 AM, sreekanth m wrote:
> Dear All,
>
> I am attaching an Excel with some hypothetical data.
>
> Please help me to :
>
>- Take
attach the sample file
On Mon, May 9, 2011 at 7:21 PM, vinu wrote:
> Hello team,
>
> Could you please help me for the below scenario:
>
> Need a code to copy paste column data under one column and keep the
> same description.
>
> A B C
>
>bangmysore
>
> jan 645
change sheet3 name as out and tun the macro
Sub swa()
Dim i, SW, swa As Long
SW = Sheets("input").Range("A65356").End(xlUp).Row
For i = 2 To Sheets("input").Range("b6").End(xlToRight).Column
Sheets("input").Activate
Sheets("input").Range("a8:a" & SW).Copy
swa = Sheets("out").Range("b65356"
Hi pramod,
its good you have joined this group.. First of all try to record macro and
understand abt Excel Object and Their Property.. you can take help from
Ozgrid.com and MrExcel.com.. these are very Good To Learn Excel vba..
On Tue, May 10, 2011 at 1:00 AM, pramod kumar
wrote:
> Dear Friends,
try this
type:--
n4= =SUMPRODUCT(--($A$3:$A$11=M4)*($C$2:$K$2=$N$2),($C$3:$K$11))
n5= =SUMPRODUCT(--($A$3:$A$11=M5)*($C$2:$K$2=$N$2),($C$3:$K$11))
On Tue, May 10, 2011 at 11:17 AM, Rohan Young wrote:
> Dear Experts,
>
> Daily updation of the status according to skilled & unskilled type l
Hi
Thanks for the file, nice work. But what I am require the program has
to remember all the sheets
in the order I opened them. I think it may require to make a log file
to record the opened sheets so it can go back the reverse order.it is
not just for go back but I want to make a code which copy p
Hi Group,
I want to learn Excel VBA, Can you please provide any coaching center
in Hyderabad..
Please do the needful,
Naresh V
Analyst
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
Dear Friends,
I want to learn Excel macro ( VBA ) .so please tell me how to start VBA.
Please help.
--
Regards,
Pramod Kumar
Technocare Solution(TCS)
Rudrapur
+91 9927033573
E-Mail:-kumar.pramod03i...@gmail.com
--
-
Hello Group,
I need to insert a new row and column with relative
reference. can you please provide visual basic code for this... PLease
put two command buttons
Main objective is:
Iam having sheet with few records of data. I want to
insert a row and column wher
Dear Experts,
Daily updation of the status according to skilled & unskilled type labour, I
need a total sum of skilled & unskilled if I change the date only. because
total sum of these diff. criteria is use in some other different formats.
Sample file attached (for better understanding)
thanks &
hi experts
please help me to get my requirements to maintain my drugdata.please find
the attachment.if it possible in excel please helpme.
thanx in advance.
regards
jasmin
--
--
Some important links for excel users
18 matches
Mail list logo
