| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Link Increments
Hi
I have 2 sheets, sheet 1 is to show data from every 8 rows from sheet 2 e.g. on sheet 1 my links are =sheet2!b5 =sheet2!b13 =sheet2!b21 I have 400 of these to enter into sheet 1 and another 500 in another book, how can i do this programatically without having to manually edit every cell? Many many thanks Kerry |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Link Increments
=Indirect("sheet2!B" & 4 + 8*row(A1))
then drag fill down the column -- Regards, Tom Ogilvy "Kerry" wrote in message ... Hi I have 2 sheets, sheet 1 is to show data from every 8 rows from sheet 2 e.g. on sheet 1 my links are =sheet2!b5 =sheet2!b13 =sheet2!b21 I have 400 of these to enter into sheet 1 and another 500 in another book, how can i do this programatically without having to manually edit every cell? Many many thanks Kerry |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row increments - | Excel Worksheet Functions | |||
| increments | Excel Discussion (Misc queries) | |||
| ROUNDUP IN 0.2 INCREMENTS | Excel Worksheet Functions | |||
| How do I add time when some of the increments are less than an ho | New Users to Excel | |||
| Date-increments | Excel Discussion (Misc queries) | |||
Hybrid Mode
