EXCEL: Copy data according to cell colour -


i have created calendar in excel. want export important events separated table. process following:

  • check colour of cells within concrete row

  • if colour of cell (for example) yellow --> copy description of below cell , date of event table

  • repeat process cells within selected row

calendar

desired output:

output

thanks lot!


Comments

Popular posts from this blog

c# SetCompatibleTextRenderingDefault must be called before the first -

C#.NET Oracle.ManagedDataAccess ConfigSchema.xsd -

c++ - Fill runtime data at compile time with templates -