data access on different worksheets
indirect() or index might do what you want depending on what you want to do
with it.
In A1 enter
=indirect("Sheet2!A"&row()*2-1)
to get the values in Odd rows in Sheet two column a when copied down
"Carl C" wrote:
data on my second worksheet is spaced, so that the data is in row 1 then 3
then 5. How do i get an equation in the first worksheet that accesses the
data in the second so that I can have it skip rows from the second worksheet
so that I don't get n/a when I copy the cells?
|