ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Fill in cells with an array (https://www.excelbanter.com/excel-discussion-misc-queries/230994-fill-cells-array.html)

dgh

Fill in cells with an array
 
I have a row of numbers that I want to fill into a row only if a variable
cell increments by 1. For instance:

Array = 200 10 5 6 8

Variables 0 1 1 2 2 3

Row 1 200 10 5 6 8
Row 2 200 10 5 6 8
Row 3 200 10 5 6 8



I want to be able to change the variables so the array can stat at different
cells within the row.


--
dgh


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

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