Hi Folks,
Regularly i have to import a text file and convert it into excel format
by using the Data/Get External Data/import text file.

The resulting excel spreadsheet has 4 columns of data.Col A has
numbers,B has text,C & D have numbers.
It is very lengthy which i have to further format in the below manner:
In this spreadsheet after about every 54 rows 8 rows of text appears
which is not useful for me and i have to delete the rows manually.The
text starts from Col B and besides the text in Col A a number appears -
83410.(This number is unique to the text cells and appears only once in
the first row corresponding to the text cells.So below this number in
col B their r 7 lines of text.)

Also,some rows appear which have a sign like -------------.These
appear irregularly in col C & D.
To remove the 8 rows of text and the rows with ------------ i have to
manually delete the rows which becomes a very tedious procedure.
So is it possible to write a macro which will search for no.83410 in
Col A and delete the 8 rows starting from this number(including the
number itself)
Also,the macro shud search for ---------- in col C & D and delete the
entire row corresponding to -----------.
Any help will be very much appreciated.!!


---
Message posted from http://www.ExcelForum.com/