$$Excel-Macros$$ please help me

[Satish Bandaru]

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:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


drugdata.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Total of sum of Diff. criteria according to date

[Rohan Young]

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 & regds

ROHAN

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Total Sum of Different Criteria_HELP.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ how to insert a new row using relative reference in excel 2003

[naresh v]

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 where ever i required...

 Please do the needful

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ How to start Excel-Macro

[pramod kumar]

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

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Need Institue in Hyd

[naresh v]

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 tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ go back to the last visited page

[Rajesh K R]

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 paste some
data from active sheet to previous sheet visited.How to do it?
Regards
Rajesh kainikkara

On 5/10/11, ChilExcel  wrote:
>  In Excel2003
>
>
>
> Chilexcel
>
>
>
>
>
> 2011/5/9 ChilExcel 
>
>> Please see attached file
>>
>>
>> Chilexcel
>>
>>
>>
>> 2011/5/9 rajan verma 
>>
>>> HI,
>>> Please see if it help..
>>>
>>>
>>> On Sun, May 8, 2011 at 4:01 PM, Rajesh K R
>>> wrote:
>>>
 Hi Experts
 Is it possible to create two buttons one for forward & other for
 backward and move to sheets in the order what we used after login just
 like we do in a browser.Pls check the attachment

 Regards
 Rajesh Kainikkara
 .

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

>>>
>>>
>>>
>>> --
>>> Regards
>>> Rajan verma
>>> +91 9158998701
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> Visita ; http://sites.google.com/site/chilexcel/Home
>> Visita ; http://www.youtube.com/user/timextag41
>>
>>
>
>
> --
> Visita ; http://sites.google.com/site/chilexcel/Home
> Visita ; http://www.youtube.com/user/timextag41
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Total of sum of Diff. criteria according to date

[ashish koul]

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 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 & regds
>
> ROHAN
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ How to start Excel-Macro

[rajan verma]

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,
> 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
>
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Need macro help to copy paste each column data under one column

[ashish koul]

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").End(xlUp).Row + 1
Sheets("out").Activate

Sheets("out").Range(" b" & swa).Select

ActiveSheet.Paste
Sheets("input").Activate
Sheets("input").Range(Cells(8, i), Cells(SW, i)).Copy
Sheets("out").Activate
Sheets("out").Range(" c" & swa).Select

ActiveSheet.Paste
Sheets("out").Activate
Sheets("out").Range(" a" & swa).Value = Sheets("input").Cells(6, i).Value
Sheets("out").Range(" a" & swa).Copy
Sheets("out").Range("a" & swa & ":a" &
Sheets("out").Range("b65356").End(xlUp).Row).Select

ActiveSheet.Paste

Next i



End Sub

On Mon, May 9, 2011 at 7:20 PM, Vinod  wrote:

> Hello Team,
>
> could you please help me with the below file.  explained the problem in the
> attached file.
>
>
>
> Thanks,
> Vinod.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Need Macro help to copy paste the each column data in one column

[ashish koul]

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   978
> feb  645
> mar978
>
>
> it should be realigned like below:  no of rows and column keep adding
> need to looping.
>
> AB   C
>
> bang  jan  645
> bang  feb
> bag   mar  978
> mysore  jan  978
> mysore  feb  645
> mysore  mar
>
>
> thanks.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ $$Excel - Macros$$ Help me to Generate report in a button Click and sent to the Manager

[ashish koul]

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 out the data by filtering the Managers name and paste it in a
>New Work Book.
>- Sent it to the respective managers E-Mail ID.
>- All the above actions should get done in a button Click.
>
> Awaiting for you valuable response. Bunch of Thanks in advance.!
>
> Thanks&Regards,
> *Sreekanth M
> *Mobile:08420642256
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ Total of sum of Diff. criteria according to date

[Zafar Iqbal]

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
Subject: $$Excel-Macros$$ Total of sum of Diff. criteria according to date

 

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 & regds

 

ROHAN

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Please check.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Total of sum of Diff. criteria according to date

[Rohan Young]

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(--($A$3:$A$11=M5)*($C$2:$K$2=$N$2),($C$3:$K$11))
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Help needed in macro.

[Born to Win]

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:
>
>> -- Forwarded message --
>> From: Born to Win 
>> Date: Tue, 10 May 2011 12:06:47 +0530
>> Subject:
>> To: excel-macros@googlegroups.com
>>
>> Hi Experts,
>>
>> here is attached dump along with this mail.i want to know agent wise
>> count in each categories or agent wise if possible through macro
>> please help me out.
>>
>> --
>> Thanks,
>> Prabhat
>>
>>
>>
>> --
>> Thanks,
>> Prabhat
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>


-- 
Thanks,
Prabhat

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Total of sum of Diff. criteria according to date

[ashish koul]

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
> situation what is the formula?
>
> please reply
>
> Thanks & Regds
>
> ROHAN
>
>
> On Tue, May 10, 2011 at 5:16 PM, ashish koul wrote:
>
>> =SUMPRODUCT(--($A$3:$A$11=M5)*($C$2:$K$2=$N$2),($C$3:$K$11))
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Consolidate data

[Rajesh K R]

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://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


CONSOLIDATE.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Consolidate data

[ashish koul]

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
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


CONSOLIDATE(1).xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Consolidate data

[ChilExcel]

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 important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Visita ; http://sites.google.com/site/chilexcel/Home
Visita ; http://www.youtube.com/user/timextag41

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


CONSOLIDATE_Chilexcel.xls
Description: MS-Excel spreadsheet