i'm having a bit of trouble figuring out how to do this:
On one worksheet i have a dynamic named range that starts on a2 and goes down a couple hundred lines. i'm trying to display the cells on a different worksheet but starting at A4, if I enter "=("named range") on a4 it gives me the value for a4 on the first sheet, i tried offset formula but it gave me an error, i could use index but each row needs to be entered manually and there is a lot of data. does anyone have a simple way to do it?
any help would be greatly appreciated.
Chris
Bookmarks