Hello
I am new at Excel and here my issue and I hope you help me out. I have two the same reports in Excel for examples this today ( called this workbooktoday) and yesterday(called workbookyest) –I run this report every day . Problems is that clients from last day today show up in the today report and I have to match the clients ( sometimes more than 300 of them) in today report to yesterday and delete them in today report if they are in yesterday report.The data are to be compared are in column A and B , but the datas are not every row . Here is arrangement:
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
> </o>
Column A B
Some data Some data
Data Payment: $25.00 on 03/15/2011 Money Order<o></o>
<o> </o>
3000569542 WINSTON K MANNING
<o> </o>
Somedata Some data
<o> </o>
<o> </o>
<o> </o>
3000569542<o></o>
<o> </o>
Somedata
<o> </o>
As you see the datas must be matched are client file # started with 3000 in column A( it is one in the row but is not very row of column A), first and last name in column B( names are both in one row but are not in every row of column B –they are capital letter ), and date in column A as well on which payment was made but before date some data in row of column A that can be disregards .The spreadsheets are the same arrangements –both of them .
I would like to have a macro that compare the clients file # , names in the today report to yesterday and delete if clients from yesterday report are in today’s report .
I really appreciate any heads up with this issue.
<o> </o>
Best Regards
I am new at Excel and here my issue and I hope you help me out. I have two the same reports in Excel for examples this today ( called this workbooktoday) and yesterday(called workbookyest) –I run this report every day . Problems is that clients from last day today show up in the today report and I have to match the clients ( sometimes more than 300 of them) in today report to yesterday and delete them in today report if they are in yesterday report.The data are to be compared are in column A and B , but the datas are not every row . Here is arrangement:
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o> </o>Column A B
Some data Some data
Data Payment: $25.00 on 03/15/2011 Money Order<o
></o><o
> </o>3000569542 WINSTON K MANNING
<o
> </o>Somedata Some data
<o
> </o><o
> </o><o
> </o>3000569542<o
></o><o
> </o>Somedata
<o
> </o>As you see the datas must be matched are client file # started with 3000 in column A( it is one in the row but is not very row of column A), first and last name in column B( names are both in one row but are not in every row of column B –they are capital letter ), and date in column A as well on which payment was made but before date some data in row of column A that can be disregards .The spreadsheets are the same arrangements –both of them .
I would like to have a macro that compare the clients file # , names in the today report to yesterday and delete if clients from yesterday report are in today’s report .
I really appreciate any heads up with this issue.
<o
> </o>Best Regards
