Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ty Ty is offline
external usenet poster
 
Posts: 72
Default Auto duplicate rows

Is there a way to have a row copied/duplicated automatically?

Here is the problem:
1. I have a row with 1 column with a list of 4-5 items with all the same information.
2. Example: 3-4 phone numbers for 1 house. Same address and same description and same ranking.
3. I have a column listing how many numbers are listed in that 1 column/row box
4. my problem is that the 3-4 numbers need to be on each individual row
5. I was copying the entire row 3-4 times. Then deleting out the phone numbers to have only 1 phone number for the whole row.

The solution of automatically doing this will save me the time of manually doing with a copy, paste, and delete.

Any help will be greatly appreciated.

Thanks,
Ty
Reply
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
Auto extract data & inserts rows additional rows automatically Meeru Excel Discussion (Misc queries) 3 September 9th 09 01:46 PM
Auto Removal Of Duplicate Rows Astro Excel Worksheet Functions 1 February 19th 09 09:21 AM
Duplicate rows into new rows based on row value Tom Excel Worksheet Functions 5 March 29th 08 05:32 PM
Auto Number the Rows of Auto Filter Result ashish128 Excel Discussion (Misc queries) 3 April 29th 07 06:41 PM
Duplicate rows Elimination- change rows accordingly meendar Excel Programming 2 April 11th 06 05:31 PM


All times are GMT +1. The time now is 09:00 AM.

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"