Excel Question

[Mike]

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

[007stuart]

Originally Posted by Mike

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

Have you tried the text to columns under the data option

[idi banashapan]

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