Using cell value to change range size

[Defski]

I am looking for help to make the following happen.

Say like I have a range that is from A20:C50, how can I make it so if a value in cell lets say cell A5 was "8" my new range would be A28:C50.

Ultimately I would like to be able to take the remaining data and copy and paste it into another sheet.

I assume this requires a VBA solution???


Thanks,

 

[My Aswer Is This]

Thanks for explaining that.
But I do not understand:

ending data that is leftover in a range

When this inventory is used up the only data that would be important is the remaining data left,​

If the inventory is used up I would think nothing would be left.

How do we know when inventory is used up?

 

[Defski]

I use the value in cell D24 to count down to the row where inventory remains.

So if there is a 20 in cell D24 it will count down that many rows and the remaining from that point is left over.

 

[Defski]

Anymore help on this?

range(Cells(range("D24").Value + 30, 1), range("C58")).Select

This is what I am currently using to almost get what I need done. but the end of the range is not dynamic, its fixed to C58.

Is there away to use the first part of this code and then have it dynamically find the end of the range no matter how many rows it may contain?

 

[My Aswer Is This]

There are several of us here who have tried to help you but in my case I just do not understand what your wanting.

And i believe your just wanting one piece of code to add to some other code your working with to get a end result which I do not know.
And just repeating what you have already said will not help me.

 

[Fluff]

How about

Range(Cells(Range("D24").Value + 30, 1), Range("C" & Rows.Count).End(xlUp)).Select