DynamicScale501
New Member
- Joined
- Nov 4, 2015
- Messages
- 1
Hi,
So currently I have a very large spread sheet excel 2010 with control values that pull specific data sets. The data sets are all numerical and use a reference row to be pulled. I currently just pull them from top to bottom from a start point of cell 1. However, I need to change my start point for a new model. and it has to dynamically shift up or down from the starting value.
My problem: Getting the cells to pull consecutively based on a changing control value. I have an example however i am not allowed to post attachments yet.... I can get it to start correctly but not continue in order.
I am open to both VBA and formula soloutions. This doesn't sound difficult but i just can't seem to wrap my head around it correctly.
So currently I have a very large spread sheet excel 2010 with control values that pull specific data sets. The data sets are all numerical and use a reference row to be pulled. I currently just pull them from top to bottom from a start point of cell 1. However, I need to change my start point for a new model. and it has to dynamically shift up or down from the starting value.
My problem: Getting the cells to pull consecutively based on a changing control value. I have an example however i am not allowed to post attachments yet.... I can get it to start correctly but not continue in order.
I am open to both VBA and formula soloutions. This doesn't sound difficult but i just can't seem to wrap my head around it correctly.