Hi,

Thanks ashish & Mahesh.

I need solution in different form.Please find new wxcel file with input data
& result required.

Kindly give me solution.

Thanks in adavnce

Regards

Sagar Aher
On Tue, May 17, 2011 at 6:04 PM, Mahesh parab <mahes...@gmail.com> wrote:

> Hi Sagar
>
> find attach, check whether its as per u r requirement.
> Thanks
> Mahesh
>  On Tue, May 17, 2011 at 1:57 PM, sagar aher <sagara...@gmail.com> wrote:
>
>>   Hi Ashish,
>>
>> Please find file & expected result...olz help..its urgent
>>
>> I have got following data in excel. I need to copy 1st number in given
>> row for e.g. 122532 should be copied against 100 for 4 times & similar
>> way 321654 should be get copied against 200 for 3 time like way.
>> ( Problem is that I'm not sure how many times 100 or 200 nos. comes )
>> kindly suggest me macro to run the same for very large data
>> plz find file where input & result is shown..kindly suggest me macro
>> solution
>>
>> thanks...
>> --
>> Cheers
>> Sagar Aher :)
>>
>>
>>
>> On Tue, May 17, 2011 at 1:43 PM, ashish koul <koul.ash...@gmail.com>wrote:
>>
>>>
>>> send  email to excel-macros@googlegroups.com  and attach your workbook
>>>
>>>
>>>
>>> On Mon, May 16, 2011 at 12:08 PM, sagaraher <sagara...@gmail.com> wrote:
>>>
>>>> How to upload a excel file??..kindly help
>>>>
>>>> On May 13, 7:29 pm, ashish koul <koul.ash...@gmail.com> wrote:
>>>> > can you attach the sample sheet
>>>> >
>>>> >
>>>> >
>>>> >
>>>> >
>>>> > On Thu, May 12, 2011 at 3:47 PM, sagaraher <sagara...@gmail.com>
>>>> wrote:
>>>> > > I have got following data in excel. I need to copy 1st number in
>>>> given
>>>> > > row for e.g. 122532 should be copied against 100 for 4 times &
>>>> similar
>>>> > > way 321654 should be get copied against 200 for 3 time like way.
>>>> > > ( Problem is that I'm not sure how many times 100 or 200 nos. comes
>>>> )
>>>> >
>>>> > > kindly suggest me macro to run the same for very large data
>>>> >
>>>> > > 122532
>>>> > > 100
>>>> > > 100
>>>> > > 100
>>>> > > 100
>>>> >
>>>> > > 321654
>>>> > > 200
>>>> > > 200
>>>> > > 200
>>>> >
>>>> > > 654987
>>>> > > 300
>>>> > > 300
>>>> > > 300
>>>> > > 300
>>>> > > 300
>>>> > > 300
>>>> >
>>>> > > 987654
>>>> > > 100
>>>> > > 100
>>>> >
>>>> > > 789654
>>>> > > 300
>>>> > > 300
>>>> > > 300
>>>> > > 300
>>>> > > 300
>>>> > > 300
>>>> > > 300
>>>> > > 300
>>>> >
>>>> > > --
>>>> >
>>>> > >
>>>> ---------------------------------------------------------------------------­-------
>>>> > > 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 athttp://www.excel-macros.blogspot.com
>>>> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
>>>> > > 5. Excel Tips and Tricks athttp://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 <http://akoul.blogspot.com/>
>>>> > *akoul*.wordpress.com <http://akoul.wordpress.com/>
>>>> > My Linkedin Profile <
>>>> http://in.linkedin.com/pub/ashish-koul/10/400/830>
>>>> >
>>>> > P Before printing, think about the environment.- Hide quoted text -
>>>> >
>>>> > - Show quoted text -
>>>>
>>>> --
>>>>
>>>> ----------------------------------------------------------------------------------
>>>> 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 <http://akoul.blogspot.com/>
>>>  *akoul*.wordpress.com <http://akoul.wordpress.com/>
>>> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>>>
>>>
>>> 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
>>>
>>
>>
>>
>> --
>> Cheers
>>
>> Sagar Aher :)
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> 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
>



-- 
Cheers

Sagar Aher :)

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

Attachment: GRC Report_1805201_Help Needed.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Reply via email to