I want to copy the value of a cell to adjacent cells, X times, with X being the variable. For example, say in A1 I had the value 10 (variable) and B1 (value) I had 100. I want a formula to copy the value of 100, 10 more times and place these in rows C1 thru L1 (so now you would see a row containing 11 100's). If the variable was changed to say, 5. Then you would see a row of 6 100's from B1 to G1. So the formula is simple to copy a value X number of places to the right. Hoping this can be done without macros, rather a formula I can place within the cells.
Hope this can be done.
Thanks in Advance
Matt
Bookmarks