Fill cells based on number in another cell

[Rog778]

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

[#2]

@Rog778 

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!