can you attch the file ....
On Fri, Feb 19, 2010 at 6:28 PM, saroj.32006 <saroj.32...@gmail.com> wrote:
> Dear Ashish,
>
> As per the e-mail exchange between u and Umesh, I am having a doubt. If we
> want to consolidate a data which is as like in no. of sheets in a work book
> with all employee details in sheets for 12 months. How can we consolidate
> the data basing on the Employee Id as an unique or primary key for all the
> column details.
>
> I will explain in detail...............for example..If we consolidate the
> data of employee's salary,pf, pt,incentives for month on month in a single
> sheet....basing on their Employee ID how can we want sum up of data for all
> columns of salary, pf, pt, incentives.........as cumulative for one year. If
> the data is small it will be easy to sort as according to EMP. ID and
> delete the duplicates, but if the data is huge(around 25000 employee details
> for 12 months is coming around 3 lakhs rows data). The said short cut
> formula is not helping here to have the cumulative data.
>
> Hope you understand the requirement...............If not, please revert
> back to me. I will write in depth.
>
> Thank you,
>
> Sarojkumar.
>
>
>
> On Sun, Feb 7, 2010 at 1:47 PM, Umesh Matkar <matkarum...@gmail.com>wrote:
>
>> Thanx Ashish…its work..thanx again
>>
>>
>>
>> - Umesh Matkar
>>
>>
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-mac...@googlegroups.com] *On Behalf Of *ashish koul
>> *Sent:* Saturday, February 06, 2010 7:57 PM
>>
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Please help - consolidate all shets in
>> main shet
>>
>>
>>
>>
>>
>> Sub Macro1()
>> Dim i As Long
>> Dim j As String
>>
>>
>> For i = 2 To Worksheets.Count
>>
>> j = Worksheets(i).Name
>>
>>
>> Worksheets(i).Select
>> Range("A43:P43").Select
>> Selection.Copy
>> Sheets("main ").Select
>>
>>
>> Range("C" & i).Select
>>
>> ActiveSheet.Paste
>> Range("b" & i).Value = j
>>
>>
>> j = " "
>>
>> Next i
>> End Sub
>>
>>
>>
>>
>>
>>
>> On Sat, Feb 6, 2010 at 7:18 PM, Umesh Matkar <matkarum...@gmail.com>
>> wrote:
>>
>> Dear friends(Excel masters),
>>
>> Please help me ..
>>
>>
>>
>>
>>
>> I have one excel file with 100+ sheet ..i want to consolidate data in
>> 1stmain sheet (File contents are HR data ..emp codes, sal, pf details)
>>
>>
>>
>> I want ..codes and total amount in front of code in main sheet.
>>
>>
>>
>>
>>
>> Pls find attached example file.
>>
>>
>>
>> Thanx in advance
>>
>> Umesh Matkar
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 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
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain @ jainayus...@gmail.com
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,700 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>>
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 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
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain @ jainayus...@gmail.com
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,700 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 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
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain @ jainayus...@gmail.com
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,700 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
