Thread
:
Macro - Import, Delete, Concatenate
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Macro - Import, Delete, Concatenate
Have you tried recording a macro while doing it manually. Then clean it up
and then re-post
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"cranen" wrote in message
...
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. Thanks so much for your help and time.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett