Dear All,
I require to reconcile 2 sheets every month and its very tedious.
Can this be automated by a macro. here is what I need to do.
sheet 1 is the bank statement , sheet 2 is the reconciliation sheet, where I have to search the items from the sheet 1 and if the item is present in sheet 2 then I have to enter the date from sheet 1 to sheet 2, thus clearing all the similar items in both the sheets.
Pl. help thanks
Any body has any idea on how to Automate the Bank Reco in Excel.
I mean at the click of a button, we should get the diff. of the Bank statement and the Bank book in a seperate sheet.
Anybody ?
I would be highly obliged.
I would like to find a template for reconciling bank statements with the
formulas already hard-coded.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/comm...lic.excel.misc
I'm trying to automate a process. I can't figure out if conditional formatting, or an IF/Then statement is correct to use. Or, perhaps a macro is required? I'm doing a large bank reconciliation....
An example:
Columns:
1) Date, Amount, Ref Number, Result
2) Date, Amount, Ref Number, Result
So, this is what I'm hoping for: If the amount column in row 1 is the same as the amount column in row 2, AND the ref number in row 1, is the same as Date in row 2, put an "x" in both D1 and D2 (D being the Result cell)
Thanks,
I have bought some preprinted checks (voucher style) to run through my laser
printer and am looking for a simple template for word or excel that I can use
to ill out the check on my computer.
Hey guys,
I was wondering if this was possible to create a script where it can autodownload from bank websites to download monthly bank statements.
I have done macro for currency exchange rates, but not when it comes to actually downloading a pdf. Is this possible?
If not, is this even possible with regular VBA? What would I need to learn and know in order to get this done. I am guessing Microsoft SQL??
Thanks
When I download my barclays statements into excel it does not download
properly. The data is not in column format.
I am looking for a template that will simplify the bank reconciliation process?
and tracking my daily expenses? I thought about downloading some
applications for this
purpose, but none of them satisfy me and they are not free,
Thank you
