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
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