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 link to offset sheet

I have two sheets, and am trying to link cells (copy the same vallue) from
the second sheet into the first. The problem is, the first sheet has 10
blank rows between each link I'm trying to paste in from the seccond sheet.
The second sheet does not have any blank rows between the data.

I'd like a formula that would take into account this offset as I copy the
link on first sheet down. I.E. once I link cell A1 from second sheet to cell
A1 in the first sheet, I want to copy cell A1 in first sheet to cell A11 in
first sheet, but want it to reference cell A2 in the second sheet.
 
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 offset to cell Kev Excel Discussion (Misc queries) 6 December 31st 06 04:02 AM
Why Copy/Paste fails using Offset & Resize of myRange? [email protected] Excel Discussion (Misc queries) 3 November 21st 06 02:06 AM
Offset in another sheet wienmichael Excel Discussion (Misc queries) 2 November 2nd 06 09:21 PM
copy and paste with offset kevcar40 Excel Discussion (Misc queries) 3 October 10th 05 03:20 PM
Using offset more than once on the same sheet Pat Excel Worksheet Functions 1 September 8th 05 11:34 PM


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