Wish I was good at this !!!!

**Eeeee** · 10-24-2006, 10:27 AM

Hi Guys great site...

Hope mines a simple problem..

On worksheet 1 I display the result of a calculation performed on worksheet 2. The formula and answer are correct and display the way I want, OK so far. I now want to repeat this horizontally on sheet 1 based on cells arranged vertically on sheet 2. However I want to drag the cell horizontally so I dont have to input the formula each time in every cell. This copies the formula OK but it looks at the wrong cells in sheet 2, I think it's cos I'm dragging horizontally and the cells in the formula are arranged vertically . Is this easy to fix without redesigning the whole sheet ?

**mrice** · 10-24-2006, 03:03 PM

You could try a formula combining OFFSET and CELL functions

Something like

=OFFSET($E$2,CELL("col"),0)

**peejay** · 10-24-2006, 04:14 PM

you could use a macro something like this

Sub Macro1()

Sheets("Sheet1").Select
Range("A1:A20").Select
Selection.Copy
Sheets("Sheet2").Select
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=True
End Sub

change the sheet names and range to suit your application.

Manually you can do a copy ----- paste special (highlight the transpose option)

Wish I was good at this !!!!

LinkBack

Thread Tools

Rate This Thread

Display

Wish I was good at this !!!!

Response

Try a Macro

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions