Fill cells based on number in another cell

Copper Contributor

I have two rows of cells 

 E                  F                  G                 H                I



My question is how do I change the value of  E1 to 4 and automatically change E2 to 6 etc 

F1 to 7 F2 changes to 3 etc

I would also like to fill other rows say 4 and 5 with percentages of the same values?

Thank you

1 Reply


With your permission, I recommend to provide more information.

You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.

I recommend: Always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).

If possible, add a file (without sensitive data) and use this file to describe your project step by step, or add photos with the appropriate description.

Don't forget that not every Excel user has a clue about every job and what you see he can't see.


In this link you will find some more information about it:

Welcome to your Excel discussion space!