Linking using ranges?

  • Thread starter Thread starter Geoff
  • Start date Start date
G

Geoff

I have a chart of data on one excel worksheet (and this
chart has a constant number of columns, but the number of
rows vary). I need to take all of the data on this chart
(not all of the data on that worksheet) and put it in to
the middle of another worksheet. I was wondering if
there was a way to do this without using a macro. My
thought was to try to create a range on each sheet and
set one range equal to another, but apparently excel
doesn't allow this (at least in version 2000, which I am
using). Does anyone have any thoughts or ideas? If this
isn't possible how would you do it with a macro? Thanks
a lot!

Geoff
 
Yeah that's what I was originally going to try. However, sometimes the area
that needs to be copied is only 10 rows long, while other times it is over
100. This becomes a problem since extra data at the bottom of the page,
which I do not want to be copied, would also be copied. That's why I was
wondering if there was anyway to set one range equal to another. Thanks for
your help though!

Geoff
 
Back
Top