| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing every 5th cell in another sheet
I have one sheet (Sheet1) that contains data. Everey 5th row
in this sheet I want to put a referce to in sheet2. E.g. Sheet2.A1 = Sheet1! A1 Sheet2!A2 = Sheet1! A6 Sheet2!A3 = Sheet1! A11 Sheet2!A4 = Sheet1! A16 and so on... Is there a way I can use Autofill in Sheet2 and return every 5th cell from the other sheet, sheet1? Regards Jan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| referencing to a sheet that it`s name is stored on a cell | Excel Worksheet Functions | |||
| odd behavior when referencing a cell on another sheet | Excel Discussion (Misc queries) | |||
| Referencing cell in another sheet yields null? | Excel Worksheet Functions | |||
| referencing Excel sheet name in cell | Excel Worksheet Functions | |||
| referencing a sheet named in a cell then using data from that sheet | Excel Worksheet Functions | |||
Threaded Mode
