Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need assistance with simple Excel macro or code
I've got very little VBA experience, but have created and edited some Excel
macros. I will be exporting data weekly into an Excel sheet, and need a macro to sort and delete some rows. The sheet will have 7 columns with a header row; column G will contain a value of 0, 1 or 3. I need to delete all the rows that are not "1", then will do some other sorts. the initial export will have up to 400 rows of data. can someone help with this code? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need assistance with simple Excel macro or code
The macro recorder is your friend. Do it manually while recording. Then clean up the macro. -- Don Guillett Microsoft MVP Excel SalesAid Software "dbix" wrote in message ... I've got very little VBA experience, but have created and edited some Excel macros. I will be exporting data weekly into an Excel sheet, and need a macro to sort and delete some rows. The sheet will have 7 columns with a header row; column G will contain a value of 0, 1 or 3. I need to delete all the rows that are not "1", then will do some other sorts. the initial export will have up to 400 rows of data. can someone help with this code? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need assistance with simple Excel macro or code
I have recorded a macro; the primary issue is that there will be a variable
number of rows each time I export to this file. My preliminary macro sorted on column G to get all the 0's, 1's and 3's together. What I'm missing is the command structure to determine the range where all the 0's and 3's are to delete. "Don Guillett" wrote: The macro recorder is your friend. Do it manually while recording. Then clean up the macro. -- Don Guillett Microsoft MVP Excel SalesAid Software "dbix" wrote in message ... I've got very little VBA experience, but have created and edited some Excel macros. I will be exporting data weekly into an Excel sheet, and need a macro to sort and delete some rows. The sheet will have 7 columns with a header row; column G will contain a value of 0, 1 or 3. I need to delete all the rows that are not "1", then will do some other sorts. the initial export will have up to 400 rows of data. can someone help with this code? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need the code for a simple macro | Excel Programming | |||
Need a simple printing macro code | Excel Programming | |||
Simple, need assistance | Excel Programming | |||
Need code for Excel Simple Visual Basic Macro to select next avai. | Excel Programming | |||
Simple (?) Macro Assistance- Select, Insert, Paste, Rinse, Repeat | Excel Programming |