How to make a pay - roll set of fnctns, all to import a number from a common cell ?

Hello everybody from Greece !
I have the following question which appears in several every day applications.
To make a spread sheed (pay - roll type) for N persons, you form the data manipulation function for the 1st person and then you copy - paste it down the list N times.
However often, all N functions may have to import a datum from the same cell ! I.e. a single common cell. So, if you apply copy paste, the 2nd, 3rd etc. function will try to import data from the next cells below the specific cell which are empty !!
How can we indicate to excel , in copy -paste, that a particular datum will be entered from a single common cell ??
Thank you for your assistance !

[QUOTE=Fotis1991;3576091]Welcome to the forum.(Καλημέρα Ελλάδα!!)


Dear Fotis hello !
I am glad for your prompt response !
I wrote a sample program to illustrate my question.
There is a column with N = 5 entries in a pay -roll. In the simple formula that calculates the pay for each person (A1 to A5) the last term is an added value of 100, common to all. In the next pay roll, next month, only this value has to change.
So, I will have to go through the last column N - times to change it by hand ! Imagine if N = 100 or more !
Is there a better way all N functions to take this value from a specified cell common for all ??
I'm I clear now ??
Good day (Καλή σου μέρα) !

Originally Posted by Fotis1991

Hoping that i got correctly your query, let's try this.

in aPut cell-let's say F1- your value. Let's say 100

Then in E7 and copy down use this.

Formula:

Please Login or Register  to view this content.

Great idea Fotis !
Are you an Excel Wizard ?? A gave you a Reputation star !
It worked straight away ! Can you explain briefly to me what is the particular type of IF fnctn that you are implementing so that I can adapt it according to the actual case ??
And something more :
If this common value is not just a summand as in this simplified example but e.g a divisor INSIDE a longer formula,
will I need a different type of command ??

Fotis,

I rewrote the first command using the magic cell name: $F$1 that you suggested and it worked without
having to use the IF statement !! So I will have this in mind from now on ! (I call it pin-down command) What is
the name of $F$x command ? Where can I read more about it ??

All credits to you !!!