ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel VBA - Help with a loop, compare, delete problem (https://www.excelbanter.com/excel-programming/290229-excel-vba-help-loop-compare-delete-problem.html)

rippy

Excel VBA - Help with a loop, compare, delete problem
 
Help!

I am new to excel VBA and really not sure if what i want to do can be
done and how to go about doing it.

Basically what i would like to have happen is have column A loop thru
itself till there are no more rows and find any exact matches such as
A3 & A4 in the included file. If they are a match I would like it to
cut the row where there is no amount in Column F or G and paste in into
the dump worksheet. If the cut and paste isn't an option then just
delete the row.

Thanks for any help!

RIPPY

Attachment filename: temporary filefeb after changes claims pay and reserve.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=431002
---
Message posted from http://www.ExcelForum.com/



All times are GMT +1. The time now is 01:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com