Forum Discussion
Assistance needed combining two text columns.
mathetes Thank you very much for getting back to me. I run an aging report twice a month and need to have rolling comments to record the collections attempts (Notes). I need to show the previous month's balance and the current. In cases where the full debt has been collected, or new customers there can be a change in the total number of people on the report. I greatly appreciate your help and advice.
Thank you very much for getting back to me. I run an aging report twice a month and need to have rolling comments to record the collections attempts (Notes). I need to show the previous month's balance and the current. In cases where the full debt has been collected, or new customers there can be a change in the total number of people on the report. I greatly appreciate your help and advice.
You didn't explicitly and specifically respond to any of the suggestions I made, other than to thank me..... Leaving me to wonder whether you are open to changing the way you do it? If so, you'd have to share some more information on how you proceed to collect the data. If not, that's fine. I have other things to do with my time. But if I were in your place, I'd want to have a system that made full use of Excel's abilities.
- I apologize, I am open to your suggestions. I was attempting to explain the purpose and needs of the report. I run an agings report that provides me with the updated data for the selected time frame. I get an account #, customer name, and balances for 30, 60, 90, 90 plus, and total balance. I have to provide report that provides the customer name, previous balance, current balance, and collection notes that are rolling. They want to see the comments from previous and current customers months for tracking purposes. I am trying to use Excel in the best way possible.
So are you getting a printed/written report from someone else, or does it come in the form of an Excel spreadsheet? Are you providing that someone else with your output, your semi-monthly report, as a printed report or do you send them your Excel spreadsheet? Or do you have total control of the entire process? Or something else?
(I'm trying to get a comprehensive picture of the full process of which you have given us glimpses, small snapshots.)
Is it possible for you to share an anonymized (real names and other identifiers replaced by, say, Disney characters' names) copy of the actual workbook(s) involved? That would make it a LOT easier to offer a recommended approach, specifically tailored to your situation, knowing where it might fit in the bigger scheme. If it's possible, post that mockup workbook on OneDrive or GoogleDrive with a link pasted here that grants access.
- Sure, I download the report from our ERP system, and provide the report to several other people semi-monthly. It is filed where others have access to it. I hope this makes sense, the columns are broken up here.
Customer Current 4/8/2023 - 5/7/2023 (30) 3/9/2023 - 4/7/2023 (60) 2/7/2023 - 3/8/2023 (90) Before 2/7/2023 (>90) May 8 Total June 8 Total Notes
ABC 87951 Dr. Swiss $0.00 $0.00 $0.00 $0.00 $37,900.00 $37,900.00 $18,000.00 5/25 emailed inv to email address removed for privacy reasons; 5/31 Tom sent payment
KING 58416 Toy Store $0.00 $0.00 $0.00 $0.00 $33,712.50 $33,712.50 $33,712.50 Write off?
ABC 35987 Jed's Trucks $0.00 $0.00 $0.00 $0.00 $15,600.00 $15,600.00 $15,550.00 5/8/2023 resent invoices; 5/29 Rec'd $50.00
ABC 35958 Candlewick $0.00 $0.00 $0.00 $0.00 $15,210.00 $15,210.00 $15,210.00 5/23 Molly emailed company, 5/31 Joe emailed Fred
KINE 78425 Nancy Duck $0.00 $11,440.00 $0.00 $0.00 $0.00 $11,440.00 $11,440.00 paid 5/19/23
ABC 58712 Judy Bligh $5,892.00 $0.00 $0.00 $0.00 $0.00 $5,892.00