data access on different worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top