Hi,
I would like to download my bank statement directly to a template. I can very easily download from the website to excel, but then I am stuck with a lot of time consuming formatting, sorting, summing, etc.
I notice there are a lot of options from the Data>Get External Data tab. I am thinking this may be where my answer is but I'm not very familiar with these options.
Thanks
What I do is download as you are doing, then copy the entries that I want to copy and paste special (values) directly into my formatted template.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
It depends on how the statement is set up. You should be able to work out a index/match or VBA solution.
Do you mind uploading a dummy example of the bank statement (meaning no personal data)?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks