Recent content by mayhem

Thank you @ AlanSidman, @pecoflyer, and @bosco_yip, you've all provided me with different solutions expanding my options in the future. Wishing you a beautiful week ahead, mayhem

Help, it's been years since I used Excel and I need to update the email addresses (Column G) in the 2nd tab (22-23) with email addresses from the 1st tab (21-22) where the conditions of Columns A match (Centre Name). If it's possible to populate based on Columns A & C matching would help even...

Thank you so much Peter, what a simple and effective solution, I'd been racking my brain with iF and VLOOKUP functions to no avail. Have a great day

Greetings I have 2 sheets and need to transfer the Students Taken in 2018 information from SiteTotals.csv sheet into Schools for CRM matching the schools. Please help, as I', unsure what is the simplest way to achieve this without manually copying each cell and pasting when working with a...

Thank you Ninjas fr your time and helping out. I'll read up on the recent CF post too. Best, M :)

Hi Excel Geniuses I've attempted to create formulas here that reference texts in column H to fill the entire row i.e. 1. "Open" returns no fill for the entire row 2. "Complete" or "Complete *more text*" returns blue fill for the entire row 3. "In Progress" or "Awaiting *more text*" or "Review...

Thank you Narayan, you're the best :)

Dear Chandoo What's the best formula to split a cell by case. In the below example, how do I separate 15 Potts St from RYDE NSW 2112. 15 Potts St RYDE NSW 2112 Thank you

But you LOVED helping me out! ;) Thank you so much for your help with this, it is much appreciated. I can do the remaining months myself. Have a beautiful week ahead and Happy Holidays Mayhem

I'd be overwhelmed with gratitude and would love to learn from you how it could be achieved. Shukria, Gracias, Merci, Arigatou :) Mayhem

Same colour as per Setup legend please. Thank you so much I appreciate your time M

4. That's right, thank you for checking, I can live with that 5. I did manually start to colour some of the Calendar but stopped when I realised the scale of the task at hand. Yes I'd like to automate the Calendar tab based on the colours in Setup. I've done as you suggested, giving each colour...

Thanks for the quick response. 1. The date population in Setup is manual 2. The calendar I copied, used conditional formatting. If manual is easier, I could use that instead unless there's another way to distinguish legends i.e. coloured text instead of cells 3. I'd like the calendar to display...

Hi Narayan I appreciate you provide advice, I hope I didn't sound demanding :) Apologies, my articulation was poor at best. - I have 2 tabs: Calendar and Setup. - Under Setup I have populated dates and legend that I need reflected in Calendar tab (Anything else in Setup tab, I don't...

Pranam Narayan, thank you for your input on the following thread but I wasn't able to understand so I followed the link sent by Hui and had one more query. Pls see thread and let me know if you can help as my deadline for this task is fast approching...