ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   repeating formulas by the same row or colum increment as the last. (https://www.excelbanter.com/excel-discussion-misc-queries/14742-repeating-formulas-same-row-colum-increment-last.html)

Formulas

repeating formulas by the same row or colum increment as the last.
 
I need to repeat formulas in a sheet by the same #of rows. I mean I might
increase the copied value by 22 rows. How can I enter that without typing
each row increment. So if I was to copy row 22 and then row 42 and then row
62. I might have one that looked like +sheetnameb22. The next one would be
+sheetname b42, the next +sheetnameB62


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

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