LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Zadig Galbaras
 
Posts: n/a
Default Add certain rows....

Hi.

My spreadsheet has a repetitive calculation for each 25.th row.
In another place I want to list up each of these values, but then in each
and every row downwards.

That is;
A1 = 25
A26 = 26
A51 = 23

Now I want to copy these values to lets say to D1 like this
D1 = 25 - Linked to A1
D2 = 26 - Linked to A26
D3 = 23 - Linked to A51

Is there a trick in the formula in D2 to automatically jump 25 rows from the
row mentioned in D1, so it shows the value in A26, without me having to sit
here day and night in a week to do the tedious copy and link jockey routine?


--

regards
Zadig Galbaras
A Perturbed Norwegian Agnostic
-


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert rows based on specific value bob Excel Worksheet Functions 6 February 29th 08 07:11 PM
flexible paste rows function that inserts the right number of rows marika1981 Excel Discussion (Misc queries) 1 February 18th 05 02:40 AM
Row selections by row # OR by even/odd rows in another spreadsheet Tom Excel Discussion (Misc queries) 0 February 9th 05 04:03 PM
Adding Rows to Master Sheet Excel Newbie New Users to Excel 1 December 23rd 04 10:56 PM
Copying Rows when hiding other rows Neutron1871 Excel Worksheet Functions 2 November 3rd 04 11:38 PM


All times are GMT +1. The time now is 05:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"