I have a question on how to run a macro and I am very new to these s
any help is greatly appreciated. I had a bank statement from work tha
was electronically sent to me which i put onto excel. I then put all o
our cash receipts on excel. What I need is to run a macro that wil
pull out all of the exceptions of the numbers in column A that don'
match column B. I basically would like to do this because the amoun
of numbers are huge and it would take me a very long time to cross thi
manually. I am sure there is a way to do this but I don't have a clu
how to run these macros. I just thought I could make my ban
reconciliation a lot easier if there was. I appreciate your help

--
boliw
-----------------------------------------------------------------------
boliwj's Profile: http://www.excelforum.com/member.php...fo&userid=2735
View this thread: http://www.excelforum.com/showthread.php?threadid=46860

It can be done but generally you will need more than 2 columns

Typically date, amount, check # and/or some code number

Otherwise how do you know which $100 entries cancell each other?

Post back with specific info available....

"boliwj" wrote:


I have a question on how to run a macro and I am very new to these so
any help is greatly appreciated. I had a bank statement from work that
was electronically sent to me which i put onto excel. I then put all of
our cash receipts on excel. What I need is to run a macro that will
pull out all of the exceptions of the numbers in column A that don't
match column B. I basically would like to do this because the amount
of numbers are huge and it would take me a very long time to cross this
manually. I am sure there is a way to do this but I don't have a clue
how to run these macros. I just thought I could make my bank
reconciliation a lot easier if there was. I appreciate your help.


--
boliwj
------------------------------------------------------------------------
boliwj's Profile: http://www.excelforum.com/member.php...o&userid=27354
View this thread: http://www.excelforum.com/showthread...hreadid=468605

I was going to include the date that the money was deposited per ban
records as well as the date the cash receipt was approved on our end.
Hopefully this well help

--
boliw
-----------------------------------------------------------------------
boliwj's Profile: http://www.excelforum.com/member.php...fo&userid=2735
View this thread: http://www.excelforum.com/showthread.php?threadid=46860

Unless you can get full details, automating this will cause problems

case: you approve monday $100
tuesday you approve $100
Tuesday $100 is logged at bank

Whose $100 is it??

unless you can get confirming invoice numbers, customer number and such you
will cause a nightmare by automatically applying $100 on Tuseday to either
of the $100 outstanding.

Talk to your controler / accountant and get better matching data

"boliwj" wrote:


I was going to include the date that the money was deposited per bank
records as well as the date the cash receipt was approved on our end.
Hopefully this well help.


--
boliwj
------------------------------------------------------------------------
boliwj's Profile: http://www.excelforum.com/member.php...o&userid=27354
View this thread: http://www.excelforum.com/showthread...hreadid=468605

I have a personal check-book built into Excel.
One column is there for a check mark (I use *)(you can use anything you
want)
I put in this mark when I get my bank statement and the item is on the
statement.
Than I perform 3 separate totals for the data.
The first Adds everything (In) and subtracts everything (Out)
this is my personal tally.
The second adds all entries which do not have an * (SumIf())
The third adds the first and second to give the bank balance.

All the formulas act on the full columns (avoiding the need for range
settings)

Again the only way to automate this is to have an identifier column...

--
steveB

Remove "AYN" from email to respond
"boliwj" wrote in
message ...

I was going to include the date that the money was deposited per bank
records as well as the date the cash receipt was approved on our end.
Hopefully this well help.


--
boliwj
------------------------------------------------------------------------
boliwj's Profile:
http://www.excelforum.com/member.php...o&userid=27354
View this thread: http://www.excelforum.com/showthread...hreadid=468605