Dear Ashish,
The said file is weighting around 5.5mb even after zipping it, unable to
send in this email. Provide me any other option to send the file.
Thank you,
On Tue, Feb 23, 2010 at 5:47 PM, saroj.32006 <saroj.32...@gmail.com> wrote:
> Dear Ashish,
>
> Please find the attached file of the said query. I am sorry for the late
> response, as i was busy in travelling. Hope u don't mind.
>
> Awaiting for your response.
>
> Thank you,
>
> Saroj.
>
> On Fri, Feb 19, 2010 at 8:09 PM, ashish koul <koul.ash...@gmail.com>wrote:
>
>> 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 1
>>>> st main 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
>>
>
>
--
----------------------------------------------------------------------------------
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
