Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
data access on different worksheets
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
protected worksheets/access | Excel Discussion (Misc queries) | |||
Limiting access to excel worksheets | Excel Discussion (Misc queries) | |||
Worksheets that everyone can access | Excel Discussion (Misc queries) | |||
Limit access to certain worksheets (tabs) | Excel Worksheet Functions | |||
Using input to access different worksheets | Excel Worksheet Functions |