Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 03-16-2017, 11:47 AM
snoop snoop is offline filling a row value from another cell Windows 10 filling a row value from another cell Office 2010 64bit
Novice
filling a row value from another cell
 
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
 



Similar Threads
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
filling a row value from another cell matching data from one work sheet to another, then auto filling missing cell information timomaha Excel 1 09-12-2014 07:51 AM
filling a row value from another cell Text Form Fields - Filling the table cell simville02 Word Tables 1 01-31-2013 11:12 PM
filling a row value from another cell Image filling a Word table cell completely? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:32 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft