LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Kenny Kendrena via OfficeKB.com
 
Posts: n/a
Default copy / paste selective rows

Hi all,

I'm trying to copy a row of formulas and paste selectively (every 7th row)
the same formulas (keeping them relative to their row). FYI the 6 rows in
between consist of some #'s and some formulas. Thus, trying to use go to
special formulas doesn't do the trick. Is there a macro that lets me
copy and paste every x rows and loop until it reaches the end of my data?
Thanks!

--
Message posted via http://www.officekb.com
 
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
Copy & Paste Brian Keanie Excel Discussion (Misc queries) 1 February 5th 05 11:56 AM
How to Copy & Paste Rows? none Excel Discussion (Misc queries) 6 January 29th 05 02:37 PM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 04:55 PM
copy paste cell character limit Fred Excel Discussion (Misc queries) 1 December 2nd 04 08:58 PM
copy and paste G Excel Worksheet Functions 2 November 2nd 04 01:56 AM


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