Excel Question
 

Hi there.

Hope someone could please help on this....

It's an excel question about copying and pasting formulas..

Thought I would attached a spreadsheet which has my problem !

On tab1 I have 100 months of a data % going 'across' the page with a conditional format giving me a green amber red traffic light under each month.

I need to complete sheet 2 and I am trying to copy the formula and then paste it but in this cases going 'down' the page.

Having real problems simply copying the green amber or red onto tab 2 column c and then copying it down 100 lines.

Maybe I am doing something stupid but would appreciate any ideas on the best way of doing this.

Really appreciate any help and thanks for your time

Regards

Mike

Re: Excel Question
 

Have you tried the text to columns under the data option

Re: Excel Question
 

Transpose is likely to be the thing you are looking for in Excel.

Your attached Excel Spreadsheet appears to be a Word document, by the way