So, I want to set up a way to copy stuff from one excel sheet to another. I use an excel workbook to consolidate multiple outlets' revenue reports into one journal entry. The problem I am having is that, obvious, for the workbook to work, the cells need to remain constant in the individual outlets for them to flow through to the journal properly, and they need to be sorted by account. The report that is auto-generated by the outlets is sorted by amount rather than account, and doesn't have all accounts listed if there wasn't any activity on it. Right now we are getting around that by hand entering it from a print out of the reports into the workbook.
My question is if there is any way that I can get excel to automatically sort (which, okay, that one I know how to do and is somewhat easy) and compensate for not all accounts being listed (it doesn't do much good to sort in account order, and then because there was no activity on Discover cards have it post Mastercard activity to Discover because when it was auto-generated it didn't leave a blank space for discover, it didn't leave a space for discover at all)?
I have no idea if my question made sense, and if I really have to I can try to screenshot what I'm talking about, but I hesitate to do so for obvious reasons (yeah, I know, I can redact any important information, but if I can get someone to go ah-hah without having to post screens, I'd appreciate it).
My question is if there is any way that I can get excel to automatically sort (which, okay, that one I know how to do and is somewhat easy) and compensate for not all accounts being listed (it doesn't do much good to sort in account order, and then because there was no activity on Discover cards have it post Mastercard activity to Discover because when it was auto-generated it didn't leave a blank space for discover, it didn't leave a space for discover at all)?
I have no idea if my question made sense, and if I really have to I can try to screenshot what I'm talking about, but I hesitate to do so for obvious reasons (yeah, I know, I can redact any important information, but if I can get someone to go ah-hah without having to post screens, I'd appreciate it).
Comment