Thread: Fill in a formula within a worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Fill in a formula within a worksheet
One way, in the starting cell, put:
=OFFSET(CallList!$A$112,COLUMNS($A:A)-1,)
Copy across as far as required
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
"Tracy" wrote:
I have the following formula which I need to fill across the worksheet but
the cell reference is from another sheet and the information within the other
sheet goes down the page not from left to right?

Colum A Column B
=+'CallList'A112 =+'CallList'A113


Tracy
Reply With QuoteReply With Quote