Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
mfn mfn is offline
external usenet poster
 
Posts: 1
Default copy a worksheet to new one with repeat rows 5 times

I have worksheet with 1000 rows.
i want to copy it to another one with repeat every row 5 times and put a
certain different values in column B every 5 times like:
B
32
42
654
76
4
..
..
..
32
42
654
67
4
and so on
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
repeat rows at top and bottom of worksheet simoltaneously M. Danesh Setting up and Configuration of Excel 5 January 12th 07 12:07 PM
How to repeat multiple rows as a header - each page of worksheet? laurandc Excel Worksheet Functions 1 August 17th 06 03:03 PM
how do I repeat rows at foot of worksheet? Debbie Iles Excel Discussion (Misc queries) 1 February 21st 06 06:53 PM
repeat rows for add'l pages for tabs on a multi-tab worksheet Nancy T. Excel Worksheet Functions 2 January 13th 06 06:35 PM
Copy from worksheet to another x times Union70 Excel Discussion (Misc queries) 0 March 7th 05 09:03 PM


All times are GMT +1. The time now is 08:14 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"