Hi,
I want to extract specific entries from the bank statement to copy them and paste on a separate excel sheet. How can i do this? This I need to do for a specific bill payments has been made. Thanks for your kindly effort.
Hi,
I want to extract specific entries from the bank statement to copy them and paste on a separate excel sheet. How can i do this? This I need to do for a specific bill payments has been made. Thanks for your kindly effort.
Last edited by top1; 04-16-2010 at 07:05 PM. Reason: attach a excel file
what discerns the entries you want to extract from the rest of the chaff? once we know this we can help you....
i attached a sample file. this is just as examples hope it helps you to understand my question. thanks
can you put a filter (data-filter..2007) on to see the specific data you need?
i have really very basic idea of excel.. how can i do tht i have office 2007. thansk
data -filter- deselect all (will clear out the defaults)- select what you want to keep
Last edited by somesoldiers; 04-16-2010 at 08:43 PM.
Here you go,
Should work with '07 as well. It is macro driven so enable macros when you open it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks