Copying formula from one cell to another with absolute value in it

G

Guest

Good Evening,

I have created numerous worksheet that does various calculations.
I would like to be able to copy the cell form one sheet to another.
I used the lookup function with the $ sign.
My question is how do i copy that formula, and paste special or something to
all the other cells.

Example:
empl_1 is the sheet name
Column A
12
23
35
65
Total_1 is the final sheet name
i would like to copy the exact data from those columns to new column in this
sheet
I used =LOOKUP(Empl1!$B$9,Empl1!$B$9)
How do i copy this numerous times? Any help would be appreciated.
Hopefully this is not too confusing

best regards
BK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert selected formula references from relative to absolute 6
Copying data from one sheet to another 2
Copy Formula From Another Cell 2
Absolute Cell refernce Not working 9
Copying Data from One Worksheet to Another 2
Copying Range From One Sheet to Another 6
absolute & relative references 2
Copying formulas, relative and absolute cell references 3

Top