Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Formular Without Changing References Within
Help Needed.
I want to copy the same formular to about 400 rows in a sheet. I dont want to the cell references in the formular to be changed, fo example: Cell G9 =VLOOKUP(F9,WorkerData!I5:K404,3,FALSE) Cell G10 =VLOOKUP(F10,WorkerData!I5:K404,3,FALSE) Cell G11 =VLOOKUP(F11,WorkerData!I5:K404,3,FALSE) Cell G12 =VLOOKUP(F12,WorkerData!I5:K404,3,FALSE -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Formular Without Changing References Within
Use the dollar sign as follows and copy the formulae in as many rows a
you want. Cell G9 =VLOOKUP($F$9,WorkerData!$I$5:$K$404,3,FALSE) - Manges -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Formular Without Changing References Within
Do I leave the $ sign off if I want the cells to update? and use it if
dont want them to update -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Formular Without Changing References Within
yes, the $ sign makes the cell absolute in your formula
If you want only the row to change then put $A1 only column, then A$1 both to change A1 no changing then $A$1 - Manges -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Formular Without Changing References Within
Thanks very much for your help.
I must say this is the best forum I have ever used.....I have neve before received a usefull reply in less than a minute before...... have tried this and it works fantastically. Thanks Manges -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing worksheet references | Excel Worksheet Functions | |||
Copy formular | Excel Worksheet Functions | |||
How to copy an array without changing relative cell references? | Excel Worksheet Functions | |||
How to copy an array without changing relative cell references? | Excel Worksheet Functions | |||
Copy/Paste without changing location references | Excel Discussion (Misc queries) |