Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro - Import, Delete, Concatenate
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro - Import, Delete, Concatenate
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? "Don Guillett" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate and Delete | Excel Programming | |||
Import Macro in PERSONAL.XLS will not import to my main document | Excel Programming | |||
Export/Import: How do I delete Userform copies? | Excel Programming | |||
Delete then Concatenate | Excel Programming | |||
How to delete & import a macro | Excel Programming |