Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro
cranen, To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook. Please supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve. Scroll down and see "Manage Attachments". Have a great day, Stan -- stanleydgromjr ------------------------------------------------------------------------ stanleydgromjr's Profile: http://www.thecodecage.com/forumz/member.php?userid=503 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=126740 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to copy and paste values (columns)I have a macro file built | Excel Programming | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Macro not showing in Tools/Macro/Macros yet show up when I goto VBA editor | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |