LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 557
Default DELETE ROWS ACCORDING TO FIGURES

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
add rows figures in a column if selected by a variable Paul Excel Worksheet Functions 1 February 29th 08 01:42 PM
MACRO FOR DELETING DEBIT AND CREDIT FIGURES ROWS K[_2_] Excel Programming 1 February 5th 08 05:10 PM
tricky problem with 14800 rows (collating figures) daviesnc New Users to Excel 1 April 19th 06 06:37 AM
Excel formula for summing using figures from adjoining rows [email protected] Excel Worksheet Functions 3 March 17th 06 02:26 AM
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 Annette[_4_] Excel Programming 2 September 21st 04 02:40 PM


All times are GMT +1. The time now is 12:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"