![]() |
#5
|
|||
|
|||
![]()
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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
filling in blank cells with data from cell above | RayK | Excel | 1 | 01-12-2017 04:14 PM |
![]() |
timomaha | Excel | 1 | 09-12-2014 07:51 AM |
![]() |
simville02 | Word Tables | 1 | 01-31-2013 11:12 PM |
![]() |
Elisabeth | Word Tables | 1 | 07-18-2012 07:21 AM |
Filling the consecutive cell by day. | aligahk06 | Excel | 1 | 09-15-2010 08:17 AM |