LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default copy text A1*7

Hi

I want to copy the text in cell A1 3 times, and the text in cell A2 3
times, below each other.
This should be as shown below, need to be used when you have over 100
names.
It is time consuming to do this manually.

name1
name2
name3
name4
name5
name6

name1
name1
name1
name2
name2
name2 and so on.

Greteful for anykind of help
Tomas Fredblad

 
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
Search and copy certain text Rusty Excel Discussion (Misc queries) 2 July 20th 06 12:11 AM
Copy text from text box to cell in another worksheet pfa Excel Worksheet Functions 2 June 24th 06 01:29 AM
How to I copy text from a range of cells to another single cell? WRT Excel Discussion (Misc queries) 2 December 18th 05 06:17 AM
To copy values in a column relevant to text in an adjacent column? Guy Keon Excel Worksheet Functions 2 November 15th 05 08:10 PM
How do I copy text from a cell into a comment? Catnip Excel Discussion (Misc queries) 1 May 27th 05 02:12 PM


All times are GMT +1. The time now is 10:39 AM.

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

About Us

"It's about Microsoft Excel"