Hi All,
Got a couple of questions wouldn't mind being answered:
1- I have some data that is import along with a load of crap surrounding it kinda of like below:
crap
crap
crap
identifier
Data
Data
Data
More crap
Was wondering how in macro you would write it such that can look through the column A and find the identifier (just a text string) then delete all the rows above it including the identified, then all the rows below the data.
2- Have another data set, from column A to AZ + variable number of rows,looking to search for the first intsance of multiple criteria in the top row from right to left (starting from right I guess I mean) then when one of the criteria is found copy the column it is in and the 3 columns to the left of it into a different sheet that has a similiar name to one this data is in: so data is in "jan 2011" to be copied into the existing sheet of "jan 2011 data"
Cheers
Got a couple of questions wouldn't mind being answered:
1- I have some data that is import along with a load of crap surrounding it kinda of like below:
crap
crap
crap
identifier
Data
Data
Data
More crap
Was wondering how in macro you would write it such that can look through the column A and find the identifier (just a text string) then delete all the rows above it including the identified, then all the rows below the data.
2- Have another data set, from column A to AZ + variable number of rows,looking to search for the first intsance of multiple criteria in the top row from right to left (starting from right I guess I mean) then when one of the criteria is found copy the column it is in and the 3 columns to the left of it into a different sheet that has a similiar name to one this data is in: so data is in "jan 2011" to be copied into the existing sheet of "jan 2011 data"
Cheers
