•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Translating a Bank Statement to a Journal Entry
I need to translate a bank statement in a spreadsheet to a format suitable for uploading to my accounting system.
-The banks' descriptions are in different formats with important info in different spots.
-The journal entry descriptions can only hold about half the characters that the statement's descriptions can.
-I also need it to reference the relevant journal accounts.
"CDS0000589" needs to be "check 589" to account 110
"BANK STTLEMENT FEE 260319 58363" needs to be "bnk fee 0319" to account 650
Is there some kind of formula for "check cell x for a chunk of data that matches table y and apply the formula in that row"?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com