Forum Discussion
Converting pasted data to customer follow-up information
I have a very basic understanding of Excel and I need some help. I'm trying to create a workbook that will take daily transactions and convert them to a customer follow-up list. Is there a way to take the information on the Paste sheet and move it to either the Act or the Up sheet based on Column N? The Act and Up sheet should return Code, Rep Name, BAN, MSISDN, Customer Name, and Date.
StephenGundrum , The original version assumed that there will be only one occurrence of Rep, so it was erroring out when a rep was there twice. I changed the logic to accommodate multiple occurrences of Reps. See if this works.
11 Replies
StephenGundrum , looks like a perfect use case for Power Query. Paste more information in the Paste Tab and extend the formulas in the table on the right side. Update the Rep list as well. Then click on Data->Refresh All to update the Act and Up table. Let me know if you run into any issues...
TheAntony [Expression.Error] There were too many elements in the enumeration to complete the operation.
Is this error after pasting in the new data? Also, in your iferror formulas, you have used a " " as the 2nd argument. Make sure it remains " ". You will get an error if you change it.
