View Single Post
 
Old 03-16-2017, 11:47 AM
snoop snoop is offline Windows 10 Office 2010 64bit
Novice
 
Join Date: Mar 2017
Posts: 3
snoop is on a distinguished road
Default

That Works but not for me

I need to explain my problem more fully I have a formula that i repeat many times down, in cell a1 i have '=C1 * d1 /e1'

this formula is copied down 1000's times, however the value of C1 & D1 change intermittently
I want to automate the process the value of c1 & d1 will remain the same for 20 rows and then change to new values for a further 50 rows and this continues.

At the moment I have in cell C1 '=$F$1' & D1 '=$G$1' which is the first 20 rows then I manually change the value C1 to =$F$2 & D1 =$G$2 for 50 rows and so on

Again Be gentle and thank you for your help

Last edited by snoop; 03-16-2017 at 06:49 PM.
Reply With Quote