Hi there
I was wondering if the following can be done using VBA?
I have a spreadsheet with rows of data sorted by warehouse branches in column C. What I would like to do is select the rows of a certain warehouse branch based on the current warehouse branch based on where the cell I'm on.
So for example if the current cell activated in column C is on "London" for example, I would like to run a macro that selects all the rows below and above that are the London branch.
My spreadsheet is sorted by branch.
Thanks in advance!
I was wondering if the following can be done using VBA?
I have a spreadsheet with rows of data sorted by warehouse branches in column C. What I would like to do is select the rows of a certain warehouse branch based on the current warehouse branch based on where the cell I'm on.
So for example if the current cell activated in column C is on "London" for example, I would like to run a macro that selects all the rows below and above that are the London branch.
My spreadsheet is sorted by branch.
Thanks in advance!