Log In
Register
Home
May 29, 2019
Offline
Hello,
I'm looking for some help to automate our credit card transaction entry into a monthly worksheet. I have the transactions listed with the nominal code, date, description, total, net and VAT. I'm manually entering the net amount into it's corresponding nominal code breakdown table and the VAT goes to it's nominal code.
It would save so much time to just enter the list and the net amount automatically finds it home on the breakdown table.
I've tried all the Lookups, Match and If formulas, but nothing is working. What's totally frustrating is I've done this before, but for the life of me, I can't seem to get it to work this time around!! Any help would be appreciated.
See Answer
Moderators
January 31, 2022
Offline
Would be great if you could upload a file demonstrating what have and what you want. It's difficult to help without some real data to play with. Just remove any confidential information but leave the file structure as it is.
Trusted Members
October 17, 2018
Offline
I also suggest you tell us the Excel version you're using
May 29, 2019
Offline
Appreciate you willing to have a look at it.
That should be the attachment available. I'm using excel 365 and importing data from Xero.
1 Guest(s)
