have I understood correctly
c15 to c60 are 46 cells
c4 to az4 has 50 cells. perhaps AZ4 should be AV4 please check

what you want is column values to be transposed to row values

use edit-copy-edit-pastesepcial-all-transpose

highlight c15 to c60 and copy
goto sheet13 highlight C4 and use edit -pastespecial-all-trnspose

similary for other sheets.
you can preparea a programme
If I have misunderstood aplogise.


ramseyjramseyj wrote in message
...
I'm really beating my head against the wall on this one, I've gotten some
previous input that I haven't been able to make work. I know there has got
to
be a way to do this. All help is appreciated.


I have a 13 sheet workbook

I want the info input into cells C15:C60 (including things like background
colors) on Sheet 1 to go to cells C4:AZ4 on Sheet 13.

I want the info input into cells C15:C60 (including things like background
colors) on Sheet 2 to go to cells C5:AZ5 on Sheet 13.

And so on for Sheets 3-12 using the previous pattern.

Just info, Sheets 1-12 are training scoring sheets with daily scores input
and Sheet 13 is a tracking chart for the previously scored days. The goal
is
for there to be no input from the user required on page 13. I already have
a
working code for my background colors that generate background shading
based
upon certian numbers and keywords. I can provide the code that I'm using
for
my background colors if you find that useful.

As always, all help is appreciated and thanks in advance.