View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ramseyjramseyj ramseyjramseyj is offline
external usenet poster
 
Posts: 3
Default automatic copy and paste from sheet to sheet in a workbook

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.