LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Macro for adding text from one cell to another cell

I would like to make a macro to help me go through 10,000 rows of an excel
spreadsheet.

I have columns set-up with last_name, first_name, address (etc). I would
like to take the first name from one row and add it into the first_name cell
of another row.

Example

John | Doe
Jane | Doe

What I would like to have is:

John & Jane | Doe

Any help??


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding Text if Value of Cell = 0 MrMeth Excel Worksheet Functions 2 February 23rd 11 04:06 PM
Adding text to cell Grugs Excel Worksheet Functions 5 July 16th 09 04:55 AM
Adding text to a cell Khlaudhya Excel Programming 4 August 3rd 04 02:43 PM
adding text to end of cell bubba1965[_6_] Excel Programming 0 February 25th 04 03:47 PM
Adding text to a cell from another cell bt707[_4_] Excel Programming 3 October 11th 03 02:03 PM


All times are GMT +1. The time now is 04:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"