Forum Discussion
Fill cells based on number in another cell
I have two rows of cells
E F G H I
| 3 | 4 | 5 | 6 | 7 |
| 7 | 6 | 5 | 4 | 3 |
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:
