concatenate column macro

Hi Guys, Can someone please help me to correct my VBA code to achieve my requirement please. I have a range of IP using which I want to create a command and I want to do this via macros. The command part will be same every time, only part that will change is IP. So, I'm trying to achieve this...

I have 3 sheets in excel in Sheet 1 there are 2000 rows and 28 columns till AB.In sheet2 I have the following data <tbody> TAG POS=1 TYPE=SELECT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_ddlkhata CONTENT=% TAG POS=1 TYPE=INPUT:TEXT FORM=ID:aspnetForm...

G'Day Excel gurus, please help. I'm hoping to be able to concatenate the data in column 'A' and 'C' into column 'A' on the same row in a new worksheet using vba. It also needs to work it's way down the column and ignore any blank cells until a certain value ('END') in a cell is reached. It...

hi everyone. appreciate any help on the below question i have data set in first column : a,b,c,d,e........;. about 160 values data set second column: 1,2,3,4,5....... about 86 value i want to create a table that line them up and says a 1,a 2,a 3,a 4,a 5,b 1,b 2,b 3,b 4,b 5,c 1,c 2,c...

I have read many discussions on how to CONCATENATE or not to. Using public functions or entering the data in active cell. Right now I want it to select range D2 and combine all data in column D (not including blanks or duplicates) into Cell D2 with a delimiter (/) Range("D2").Select...

I have a spreadsheet that contains order numbers and line items on each order. What I need to do is transpose and concatenate the column with the line item positions. Example: Column A Column B order # pos # 10256 10 10256 20 10256 30 10256 40...

I have a data set that needs to be concatenated in groups of 48 (sequentially - ie. the first 48 columns in the first row , the second 48 columns in the first row, the third 48 columns in the first row, etc). I want the code to repeat until I get to the end of the columns. If the codes places...

Hi, I recorded the following macro to add a thorn symbol before and after each record in a table. I can't figure out how to edit the macro so that it will work with a different set a data where there is a different amount of records. Help is much appreciated. Thanks. Sub Macro6()...

This should be easy, I have a column of First Names, a column of second names and I wish to create a new column with First Name , space, Last name. I can create a cell specific code such as = CONCATENATE(B2," ",C2) However I want to make this into a macro to run on any file that I open for...