Forum Discussion
Solved
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 tak...
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.
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.
- Yes. I pasted more data on the left side of the Paste sheet. I then dragged down the formulas on the right side of the Paste sheet. That part worked. When I went to Data>Refresh All is when that error message popped up.
StephenGundrum , can you attach the updated file?
- I'll need to redact customer information first. I'll upload as soon as that is done.