Add Column at the end with concatenate formula

Dave

Guest

Posts: n/a

7th Feb 2008

Hi,

I have multiple worksheets within my workbook where the number of columns
vary. I need to add a column at the end and then concatenate the columns
FirstName and LastName which are not always in the same column for each
worksheet. Does anyone have any suggestions on how I could do this?

--
Thank you

Dave

« Combobox | How to set Range variable to point to End(xlDown) cell? »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Concatenate cells in one column of value in another column is same	EE	Microsoft Excel Programming	2	19th Aug 2007 01:04 AM
Evaluating results of a concatenate formula, as a formula	=?Utf-8?B?ZG9kZ2Vy?=	Microsoft Excel Worksheet Functions	5	9th Sep 2005 01:55 PM
How do I copy concatenate formula in column	=?Utf-8?B?VFQ=?=	Microsoft Access	2	10th Jun 2005 07:19 PM
compare the first column and concatenate the second column	=?Utf-8?B?c21iMjAwMHVzZXIxMDA=?=	Microsoft Excel Worksheet Functions	0	22nd Apr 2005 07:12 PM
Copying CONCATENATE formula to other cells in column	=?Utf-8?B?VGlt?=	Microsoft Excel Worksheet Functions	2	18th Jun 2004 03:24 PM