Hello,
Don't know if this is possible, I have done some playing around and it has beaten me.
I get a spreadsheet which has 2 different datasets on it, one below the other, the length of the data sets vary. So I am having trouble as the row the second data set start on changes.
What I am trying to do is write a macro to search for the header "Count" and then select the A to M (13) on the row and then all data below that to move to a second tab.
Is this possible, am I just being inexperienced here?
Thank you in advance.
Don't know if this is possible, I have done some playing around and it has beaten me.
I get a spreadsheet which has 2 different datasets on it, one below the other, the length of the data sets vary. So I am having trouble as the row the second data set start on changes.
What I am trying to do is write a macro to search for the header "Count" and then select the A to M (13) on the row and then all data below that to move to a second tab.
Is this possible, am I just being inexperienced here?
Thank you in advance.
