| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
create macro - delete all rows with zero in column L
Using Microsoft Excel 2000 SP3
I have this spreadsheet as shown below. Column Letter/ Row No. F G H I J K L 5 BAL MON TUES WED THUR FRI BAL 6 500 500 7 0 10 20 40 70 8 0 0 9 0 10 10 10 0 50 50 11 0 0 12 0 0 13 500 500 14 3040 3040 15 500 500 4040 4540 I have formulas in cells in column L that return a zero (i.e. L6=F6-G6-H6-I6-J6-K6) starting from row 6 onwards. There may be additional €˜X no. of rows from row 6. I need to a)copy only the values in column L from row 6 downwards to row €˜X into column F row 6 downwards. b)delete the values from column G to K from row 6 downwards to row €˜X c)delete the rows that have zero value in column L Can someone please help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
create macro - delete all rows with zero in column L
Start here
http://www.rondebruin.nl/delete.htm Test for ElseIf .Cells(Lrow, "A").Value = "" Then .Rows(Lrow).Delete Change every A to L -- Regards Ron De Bruin http://www.rondebruin.nl "Johnny" wrote in message ... Using Microsoft Excel 2000 SP3 I have this spreadsheet as shown below. Column Letter/ Row No. F G H I J K L 5 BAL MON TUES WED THUR FRI BAL 6 500 500 7 0 10 20 40 70 8 0 0 9 0 10 10 10 0 50 50 11 0 0 12 0 0 13 500 500 14 3040 3040 15 500 500 4040 4540 I have formulas in cells in column L that return a zero (i.e. L6=F6-G6-H6-I6-J6-K6) starting from row 6 onwards. There may be additional 'X' no. of rows from row 6. I need to a)copy only the values in column L from row 6 downwards to row 'X' into column F row 6 downwards. b)delete the values from column G to K from row 6 downwards to row 'X' c)delete the rows that have zero value in column L Can someone please help |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
create macro - delete all rows with zero in column L
Ron
Thanks for the prompt reply it worked very well. I amended the first row to third row as my data started from that point. It is great. Thanks. I will assign a button to it and hopefully the storesman can just click the button and do the job "Ron de Bruin" wrote: Start here http://www.rondebruin.nl/delete.htm Test for ElseIf .Cells(Lrow, "A").Value = "" Then .Rows(Lrow).Delete Change every A to L -- Regards Ron De Bruin http://www.rondebruin.nl "Johnny" wrote in message ... Using Microsoft Excel 2000 SP3 I have this spreadsheet as shown below. Column Letter/ Row No. F G H I J K L 5 BAL MON TUES WED THUR FRI BAL 6 500 500 7 0 10 20 40 70 8 0 0 9 0 10 10 10 0 50 50 11 0 0 12 0 0 13 500 500 14 3040 3040 15 500 500 4040 4540 I have formulas in cells in column L that return a zero (i.e. L6=F6-G6-H6-I6-J6-K6) starting from row 6 onwards. There may be additional 'X' no. of rows from row 6. I need to a)copy only the values in column L from row 6 downwards to row 'X' into column F row 6 downwards. b)delete the values from column G to K from row 6 downwards to row 'X' c)delete the rows that have zero value in column L Can someone please help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a macro to delete multiple rows? | Excel Discussion (Misc queries) | |||
| Create a macro to delete rows if value is less than a specified nu | Excel Worksheet Functions | |||
| Can I create a macro to identify and delete blank rows in a range? | Excel Programming | |||
| delete rows using macro when no data in column | Excel Programming | |||
| macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Linear Mode
