Macro

[cranen]

I need a macro that imports a text file, deletes entire rows if in column C
there is a blank, deletes entire rows that include text that I specify,
concatenates rows that meet criteria (e.g. C1 and C2 are combined if A2="" if
not then C1), and Deletes rows where cells in Column A are blank. I need it
to do this in the order given. I don't really know how to go about doing it
by recording. Thanks so much for your help and time. I could probably get
all the code, but I dont know how to combine it. Any suggestions?

 

[stanleydgromjr]

cranen,

To best describe or illustrate your problem you would be better of
attaching a dummy workbook, the workbook should contain the sam
structure and some dummy data of the same type as the type you have i
your real workbook - so, if a cell contains numbers & letters in thi
format abc-123 then that should be reflected in the dummy workbook.

Please supply a before and after sheet in the workbook so the perso
helping you can see what you are trying to achieve.

Scroll down and see "Manage Attachments".


Have a great day,
Sta