Autofill Relative Equation Across Sheets

Hi everyone.

I'm trying to take this equation:

Sheets("Sheet1").Activate
Count = Range("C4")
Sheets("Sheet2").Activate
Range("C4") = Range("C4") + Count
Sheets("Sheet1").Activate
Range("C4").ClearContents

And AutoFill cells C4 through C42 on Sheet2 in the same way.

When I try to use an Autofill command, it just fills them all in with the same numerical value as Sheet2C4.

Thanks for any help.

I can't tell from your example and explanation exactly what you're trying to do, but maybe like this:

Please Login or Register  to view this content.

Originally Posted by shg

I can't tell from your example and explanation exactly

Sorry for not being more clear. I'm trying to have the values in the cells of Sheet1 added to the values in the same cells on Sheet2. It is for tracking inventory levels. Sheet2 is the total inventory, while Sheet1 is the week's purchases. This way, when the macro is run, a week's purchases are added to the total inventory, while Sheet1 is cleared and readied for more entries the next week.

Try the code I posted.

Thanks so much shg, that works great.