Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am trying to reduce a column of data from ~8200 rows to ~1200 rows. I have
2 spin buttons that control the upper and lower limit the user desires. Is there a way to reference just the cells within the range? For instance . . . data is listed from A1 to A8200. A new list is generated from the upper and lower limits depending on their respective spin button value (ie. a lower limit value of 2481 would be the beginning point of the 'new' data range and an upper value of 3674 would be the end). The reduced list (from A2481 to A3674) is then written in column 'B' and dyamically changes with the spin buttons. I appologize if this is too vague and thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CHANGE LOWER TO UPPER CASE IN EXCEL FOR WHOLE SPRDSHT | Excel Worksheet Functions | |||
How do I convert all upper case excel sheet into upper and lower . | Excel Discussion (Misc queries) | |||
Upper & Lower case problem in VBA | Excel Discussion (Misc queries) | |||
How do I easily draw in Excel the Upper and Lower limits of a con. | Charts and Charting in Excel | |||
changing lower case to upper case | Excel Discussion (Misc queries) |