RockandGrohl
Well-known Member
- Joined
- Aug 1, 2018
- Messages
- 790
- Office Version
- 365
- Platform
- Windows
Hello all,
I'm chopping down a phat (with a ph) list of some 500,000 clients in a sheet with filters, and then I have a variable in mind which I want to apply across another variable length of rows.
So Column BA is blank and I need to apply variable "ref" to the top "req" rows, which happens to be 475 in this instance.
Is there a way to take ref and apply it from the top all the way down until it gets to 475, then stops? For the meantime I'm going to do this the suckers way, by implementing a loop with a count that goes down visible cells, but I'm all ears if I can learn a better way to navigate and manipulate filtered data.
Everything I know at the moment tells me I should be defining a range, so in the interest of posterity, my defined range of ("AB2:AB" & LastrowDF) is called "TourPasteRng"
Cheers!
I'm chopping down a phat (with a ph) list of some 500,000 clients in a sheet with filters, and then I have a variable in mind which I want to apply across another variable length of rows.
So Column BA is blank and I need to apply variable "ref" to the top "req" rows, which happens to be 475 in this instance.
Is there a way to take ref and apply it from the top all the way down until it gets to 475, then stops? For the meantime I'm going to do this the suckers way, by implementing a loop with a count that goes down visible cells, but I'm all ears if I can learn a better way to navigate and manipulate filtered data.
Everything I know at the moment tells me I should be defining a range, so in the interest of posterity, my defined range of ("AB2:AB" & LastrowDF) is called "TourPasteRng"
Cheers!