Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, i have data in my spreadsheet from coloumn "A" to coloumn "L" . In
coloumn "G" i have codes and in coloumn "J" i have debit and credit figures. I want macro which should look into coloumn "G" and coloumn "J" cells and if there are debit and credit figures in coloumn "J" cells which relates to same code which is in coloumn "G" cells then Macro should delete those both rows of debit and credit figures from Range("A:L") FOR EXAMPLE: G J ---------coloumns 15SS -100 15SS 100 15SS 200 JK44 300 JK44 -300 JK44 400 Macro should delete 4 rows from above data which will be 15SS -100 and 15SS 100 then also JK44 300 and JK44 -300. i want macro to delete row from Range("A:L"). Please can anybody help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
add rows figures in a column if selected by a variable | Excel Worksheet Functions | |||
MACRO FOR DELETING DEBIT AND CREDIT FIGURES ROWS | Excel Programming | |||
tricky problem with 14800 rows (collating figures) | New Users to Excel | |||
Excel formula for summing using figures from adjoining rows | Excel Worksheet Functions | |||
Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below | Excel Programming |