LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Hedenblad
 
Posts: n/a
Default reference to multiple lines

I need to copy one row and then in another sheet "paste special" a "link",
not to one corresponding row but to several. Then I would have a block with
one reference like {=Medlemsregister!$B$90:$L$90}. The "block" acts like one
big reference of several rows corresponding to one singel row on another
sheet. Everey row looks the same. Parts of this "block" cannot be changed,
the number of rows cannot be changed so I have to
Now I want to do it again but have forgotten how I did it, and no one seems
to know...? Have tried every easy way of doin it so there must be a hard
one...?
/Rikard Hedenblad


 
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
select lines from multiple worksheets and write to new worksheet rem Excel Worksheet Functions 1 September 15th 05 03:35 PM
multiple lines Rhonda Excel Discussion (Misc queries) 3 July 6th 05 12:15 AM
linest won't accept multiple reference ranges Alex Gardner Excel Worksheet Functions 3 May 18th 05 01:20 PM
how do i reference multiple rows/columns with one function? NewUser13 New Users to Excel 0 March 4th 05 06:45 PM
How do I reference multiple rows Awetronics Excel Worksheet Functions 1 November 4th 04 12:37 AM


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