Hi Noorain Ansari,
Ohh...sorry... I got...
Regards,
raghavendra
On Aug 4, 11:40 pm, Raghavendra <raghavendra....@gmail.com> wrote:
> Hi Noorain Ansari,
>
> Thanks for your reply
>
> I have one issue in this. If I have more than 1000 line items ( in
> each cell 5 characters)then the given code is not working. Could you
> please advise?
>
> Regards,
> Raghavendra
>
> On Aug 4, 11:22 pm, NOORAIN ANSARI <noorain.ans...@gmail.com> wrote:
>
> > Dear Raghavendra,
>
> > Please use below code and see attached sheet...........
>
> > Sub consolidate()
> > Dim i, j As Integer
> > j = Sheet1.Range("B1000").End(xlUp).Row
> > For i = 2 To j
> > If i = 2 Then
> > Sheet1.Range("D4").Value = Sheet1.Range("D4").Value & Sheet1.Range("B" &
> > i).Value
> > Else
> > Sheet1.Range("D4").Value = Sheet1.Range("D4").Value & "," & Sheet1.Range("B"
> > & i).Value
> > End If
> > Next
> > End Sub
>
> > On Thu, Aug 4, 2011 at 11:25 PM, Raghavendra
> > <raghavendra....@gmail.com>wrote:
>
> > > Hi,****
>
> > > ** **
>
> > > ** **
>
> > > Can anyone advise me on VBA code to perform the task as mentioned in the
> > > attachment?****
>
> > > ** **
>
> > > Regards,****
>
> > > Raghavendra****
>
> > > --
>
> > > ----------------------------------------------------------------------------------
> > > 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
>
> > --
> > Thanks & regards,
> > Noorain Ansari
> > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
> > Consolidate Data(solved).xlsm
> > 22KViewDownload
>
>
--
----------------------------------------------------------------------------------
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
