Thread: Copy Formular Without Changing References Within
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Celtic_Avenger[_2_] Celtic_Avenger[_2_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote