Macro - Import, Delete, Concatenate

C

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. Thanks so much for your help and time.
 
D

Don Guillett

Have you tried recording a macro while doing it manually. Then clean it up
and then re-post
 
C

cranen

I am not sure how to make the functions work by recording a macro. I have
all of the code, but I just can't figure out how to combine it together and
use it with the "if" and "Concatenate" statements. Any suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import Macro 1
Import Macro Problem 1
Concatenate and Delete Macro 2
Macro for fast deletion of rows that conatin certain data. 2
Delete rows macro 3
Macro to concatenate columns 1
delete rows in a given range 1
Run macro on all files in a specific folder 3

Top