Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy offset to cell | Excel Discussion (Misc queries) | |||
Why Copy/Paste fails using Offset & Resize of myRange? | Excel Discussion (Misc queries) | |||
Offset in another sheet | Excel Discussion (Misc queries) | |||
copy and paste with offset | Excel Discussion (Misc queries) | |||
Using offset more than once on the same sheet | Excel Worksheet Functions |