Hi

I'm hoping someone could help me out I've got a spreadsheet with multiple tabs containing different amounts of data but all in the same format (a list of tasks in columnA, Names running along the top of the page and their skill level next to each task name running vertically)

I want to pull this information into one sheet so I have a list of all tasks vertically and all names horizontally. The twist is I want the colour of each of the cells to pull through i.e. skill level 1 = red, 2= green, etc. In addition, I want to be able to add data straight into my results table e.g. if a user decided they wanted to add a skill level in for a task that wasnt on their original task list they could.

I can pull the data from multiple tabs using a pivot table but this doesnt pull the colour or enable me to edit it.

I know my question is as clear as mud but hopefully someone will have a vague idea of what I'm on about and help me

Thanks in advance

Lucy

p.s. I have some programming experience with PHP, JS, etc but none with VB