View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Giddy Giddy is offline
external usenet poster
 
Posts: 2
Default drag across multiple data sets

Hi Spiky
This isnt how I have written the formulas, this is how I have tried to
describe what I need it to do, I need a formula from cells 1-4 in cell 1
sheet 1, but when i drag I want a formula from cells 4-8 in cell 2 sheet 1,
rather than from cells 2-5 as it does automatically. I have looked on HELP
but I am not familiar with the jargon required to get the correct answer, but
I will try looking up OFFSET as you have suggested.

Thanks Giddy

"Spiky" wrote:

Why don't you give actual cell references, that will help. Instead of
saying:
Cell 1 sheet 1 = Sheet 2 Cells 1 - 4

Say:
Sheet1!A1 = Sheet2!A1:A4

Or whatever the actual cells should be. It will be easier for someone
to help you. OFFSET formulas are probably the solution for this task.