Posted to microsoft.public.excel.misc

JPreeshl

external usenet poster

Posts: 13

copy offset rows

I have a column of names in consecutive rows. I want to copy them to another
sheet where the 1st name is in row 5 then the 2nd name is in row 15 etc with
an increase of 10 rows between the copied names.
If I try to copy a formula it just takes every 10th name not the next one.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Repost: Copy and Offset cell reference	CJ[_2_]	Excel Worksheet Functions	1	September 5th 08 03:38 PM
Copy link to offset sheet	SNACK D	Excel Worksheet Functions	5	December 14th 07 01:38 AM
Offset every # of Rows	Javier Diaz[_2_]	Excel Worksheet Functions	8	July 13th 07 06:08 PM
copy offset to cell	Kev	Excel Discussion (Misc queries)	6	December 31st 06 04:02 AM
copy and paste with offset	kevcar40	Excel Discussion (Misc queries)	3	October 10th 05 03:20 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us