ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   cell increment range (https://www.excelbanter.com/excel-programming/378640-cell-increment-range.html)

Sparky AKA_Sparkticus

cell increment range
 
I want to be able to pick the cell using a number form another cell
so i start at c33 and if the number is 6 in the input cell so the range
selected would be c39.

Im using this method to in put data on stock picking sheet

a 3
b 4
c 0
d 1

what i wan to do i populate a cell with data based on the numbers. the first
item is 3 so i c33 c34 & c35 have that item listed then item b starts at
c36 and so on.





All times are GMT +1. The time now is 01:10 AM.

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