Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'll try to be clear, was thown into this task and need some help. I have
tried looking around for help but never saw a straight solution. I get a daily .csv file that I need to save after I manually delete certain info. The file has columns A - AA (Always), but can vary on rows. Column A has multiple text entries, the only one I need is titled Parent. After that they have a numeric value in column V, I must delete all rows with the value of 0 (the actual # zero, there are numbers & zeros in this column, need to get rid of rows with 0). Then the only columns I NEED are A,B,D,K,L,N,O,P,Q,R,S,V,W (C,E,F,G,H,I,J,M,T,U,X,Y,Z,AA need to be deleted) I hop e this is clear, and I really hope that there is a easy solution to some sort of macro I can run to automate this process on a daily basis to make my life a little easier. Thanks, Drew |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting specific rows with a specific criteria using inputbox | Excel Programming | |||
Macro for removing specific rows and columns, freezing panes..? | Excel Worksheet Functions | |||
Macro for Deleting Specific Rows? | Excel Programming | |||
Macro to search across multiple columns and delete rows not containing specific value | Excel Programming | |||
Deleting columns other than those that a specific word in row A | Excel Programming |