Forum

Yes, and thank you. I've been trying the refresh all button for a week now, however I'm encountering an error (Cannot change part of an array), there...

That makes sense, thank you for explaining! Now all columns are displaying the appropriate category. As for the data, it was pasted into the tran...

Catalin, it worked!! Thank you, now working to fill in the category type, however since I manually put in the formula, I don't quite understand how t...

Hi Catalin, I can't thank you enough for your response, it was very helpful! I reformatted the data validation sheet to remove the drop downs as you'...

Thank you, I truly appreciate any insight you could provide!