$$Excel-Macros$$ Re: Concatenate Macro
Exactly what I was looking for Thanks, Steve On Apr 7, 5:55 am, Dave Bonallack wrote: > Hi Steve, > Try this code. It assumes data is in Columns A and B, as stated, and that the > data starts in Row 2. > > Sub Steve() > Application.ScreenUpdating = False > A = 2 > B = 2 > C = 2 > For i = 1 To 100 > Do Until Cells(A + 1, 1) <> "" > Cells(B, 2) = WorksheetFunction.trim(Cells(B, 2) & " " & Cells(A > + 1, 2)) > Range(Cells(A + 1, 1), Cells(A + 1, 2)).Delete Shift:=xlUp > C = C + 1 > If C - A > 200 Then Exit Sub > Loop > A = A + 1 > B = A > Next i > Application.ScreenUpdating = True > End Sub > > > > > > > Hi, > > > I could really use some help with creating a macro. I have two > > columns of data. The first column provides me with a list of Part > > Numbers and the second column Provides the Description of the Part > > Numbers. There are multiple rows for the Descriptions because that's > > the way they come into my spreadsheet. Looks something like the > > following: > > > (Column A) (Column B) > > Part Number Description > > > 100-100 Box with > > Cover and > > 4 slotted sides > > 100-211 Bubble Wrap, > > ESD sensitive > > 100-344 Shipping crate > > with pallet. > > > I need the information in column B to be concatenated onto one line, > > preferably in the same row as the Part Numbers. > > > Any help would be much appreciated. > > > Thanks, > > > Steve > > _ > Looking to change your car this year? Find car news, reviews and > morehttp://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fsecure%2Dau%2Eimrworl...- > Hide quoted text - > > - Show quoted text - --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Concatenate Macro
Hi Steve, Try this code. It assumes data is in Columns A and B, as stated, and that the data starts in Row 2. Sub Steve() Application.ScreenUpdating = False A = 2 B = 2 C = 2 For i = 1 To 100 Do Until Cells(A + 1, 1) <> "" Cells(B, 2) = WorksheetFunction.trim(Cells(B, 2) & " " & Cells(A + 1, 2)) Range(Cells(A + 1, 1), Cells(A + 1, 2)).Delete Shift:=xlUp C = C + 1 If C - A > 200 Then Exit Sub Loop A = A + 1 B = A Next i Application.ScreenUpdating = True End Sub > Hi, > > I could really use some help with creating a macro. I have two > columns of data. The first column provides me with a list of Part > Numbers and the second column Provides the Description of the Part > Numbers. There are multiple rows for the Descriptions because that's > the way they come into my spreadsheet. Looks something like the > following: > > (Column A)(Column B) > Part Number Description > > 100-100 Box with > Cover and > 4 slotted sides > 100-211 Bubble Wrap, > ESD sensitive > 100-344 Shipping crate > with pallet. > > I need the information in column B to be concatenated onto one line, > preferably in the same row as the Part Numbers. > > Any help would be much appreciated. > > > Thanks, > > Steve > > > _ Looking to change your car this year? Find car news, reviews and more http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fsecure%2Dau%2Eimrworldwide%2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801459%2Fpi%5F1004813%2Fai%5F859641&_t=762955845&_r=tig_OCT07&_m=EXT --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Concatenate Macro
hello Steve , try this = concatenate( Box with, Cover and,4 slotted sides) u can there by combined all the above rows into one alternatively =concatenate(rowc2,rowc3, rowc4) will give the required result thankx n regards Rajat Jain kolkata rajatv...@gmail.com On Tue, Apr 7, 2009 at 2:25 AM, Steve wrote: > > Hi, > > I could really use some help with creating a macro. I have two > columns of data. The first column provides me with a list of Part > Numbers and the second column Provides the Description of the Part > Numbers. There are multiple rows for the Descriptions because that's > the way they come into my spreadsheet. Looks something like the > following: > > (Column A)(Column B) > Part Number Description > > 100-100 Box with > Cover and > 4 slotted sides > 100-211 Bubble Wrap, > ESD sensitive > 100-344 Shipping crate > with pallet. > > I need the information in column B to be concatenated onto one line, > preferably in the same row as the Part Numbers. > > Any help would be much appreciated. > > > Thanks, > > Steve > > > > -- Rajat J --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Concatenate Macro
Steve, You can do it with a simple formula if you want: If you have data in cell A2 and B2 you want to join, the following formula will work: =A2&" "&B2 Then you can copy and paste special (Values) Norman On Mon, Apr 6, 2009 at 4:55 PM, Steve wrote: > > Hi, > > I could really use some help with creating a macro. I have two > columns of data. The first column provides me with a list of Part > Numbers and the second column Provides the Description of the Part > Numbers. There are multiple rows for the Descriptions because that's > the way they come into my spreadsheet. Looks something like the > following: > > (Column A)(Column B) > Part Number Description > > 100-100 Box with > Cover and > 4 slotted sides > 100-211 Bubble Wrap, > ESD sensitive > 100-344 Shipping crate > with pallet. > > I need the information in column B to be concatenated onto one line, > preferably in the same row as the Part Numbers. > > Any help would be much appreciated. > > > Thanks, > > Steve > > > > --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Concatenate Macro
Is it something you have to do often? or is it one time? It could be done with a formula, but if it has to be done often, then it would be better with a macro. pretty easy with a macro... Paul From: Steve To: MS EXCEL AND VBA MACROS Sent: Monday, April 6, 2009 4:55:00 PM Subject: $$Excel-Macros$$ Concatenate Macro Hi, I could really use some help with creating a macro. I have two columns of data. The first column provides me with a list of Part Numbers and the second column Provides the Description of the Part Numbers. There are multiple rows for the Descriptions because that's the way they come into my spreadsheet. Looks something like the following: (Column A) (Column B) Part Number Description 100-100 Box with Cover and 4 slotted sides 100-211 Bubble Wrap, ESD sensitive 100-344 Shipping crate with pallet. I need the information in column B to be concatenated onto one line, preferably in the same row as the Part Numbers. Any help would be much appreciated. Thanks, Steve --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---