ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   autofill according to cell index (https://www.excelbanter.com/excel-worksheet-functions/7352-autofill-according-cell-index.html)

honour

autofill according to cell index
 
for example I fill B1 cell with D3.And I want to fill the other B
cells(B2,B3...) with the D(3+n) .The n is a constant.For example n=2. That is
why B2=D5 or B3=D7.How can I do that??Thank you

Frank Kabel

Hi
see your post in excel.misc

--
Regards
Frank Kabel
Frankfurt, Germany

"honour" schrieb im Newsbeitrag
...
for example I fill B1 cell with D3.And I want to fill the other B
cells(B2,B3...) with the D(3+n) .The n is a constant.For example n=2.

That is
why B2=D5 or B3=D7.How can I do that??Thank you




All times are GMT +1. The time now is 11:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com