Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
reconciliation
can anybody help with the VBA for comparing data in two worksheets and
delete the matching data or copy the data that cannot be matched |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
reconciliation
dim i as integer, j as integer
for i = 1 to maxrows for j = 1 to maxcols if sheets("Sheet1").cells(i,j) = sheets("Sheet2")_ .cells(i,j) then sheets("Sheet1").cells(i,j).ClearContents sheets("Sheet2").cells(i,j).ClearContents endif next j next i this deletes the data that is matched in both sheets. John. -----Original Message----- can anybody help with the VBA for comparing data in two worksheets and delete the matching data or copy the data that cannot be matched . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reconciliation | Excel Discussion (Misc queries) | |||
How can I formulate a reconciliation? | Excel Discussion (Misc queries) | |||
reconciliation of numbers | Excel Discussion (Misc queries) | |||
reconciliation in different currencies | Excel Discussion (Misc queries) | |||
Stock Reconciliation | Excel Worksheet Functions |