LinkBack URL
About LinkBacks
I am constantly opening transaction history in excel from M&T bank
I am strictly posting credits to the account
I want to remove the debits column and all of its corresponding rows as well keeping only the credits
How do I do this
Removing columns on spreadsheet for reconciliation
I am constantly opening transaction history in excel from M&T bank
I am strictly posting credits to the account
I want to remove the debits column and all of its corresponding rows as well keeping only the credits
How do I do this
Without seeing the worksheet it's a bit of a guess. But one approach
Use Data filter
- apply filter on debit column
- select the individual values in debit column
- delete all those rows
should leave you with everything you want
EDIT
and I should have also added - then delete the debit column
Last edited by kev_; 04-13-2017 at 10:44 AM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Where is the data filter located? Home tab? Data? Can't find it, I'm using excel 2010
Hi, welcome to the forum
If all the data you want to remove is in 1 (or more) column(s), and that column does not contain data you want t keep, click on the column letter at the top, and then either rt-click and select Delete, or click the Delete button on the Home tab/Editing/Delete
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I want to delete that colom and also the rows associated with those columns
debits.png
Put cursor in cell with text= "Trans Date".
Then click on DATA tab
Then click on "Filter"
Then click on the arrow at the top of the Debit column
Then select each individual value
Got it, thank you
You are welcome.
Thanks for the rep
Please click on Thread Tools at top of thread and mark thread as solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks