Dragging formats to cells

[MadMax7]

I was wondering if some could help me with this one...

I have a datapage that i refernce to feed my final worksheet, the problem is the data runs from top to bottom on my on my final sheet ( a format i van not change) and left to right on my datapage.

The problem i am having is on my final sheet once column A1 has been updated (the cell ref reads SWI1!B2) i want to drag the data across the page (left to right) so cell b1 reads SWI1!B3 and not SWI1!C2.

hope this is clear, i can not transpose the data as it comes fron a access database in the left to right format.

i hope some can help

 

[SkipVought]

MadMax7,

So you are bringing data in from an Access TABLE with Headings across columns in row 1, and your datapage has headings down rows in column A?

Do I have it right so far?

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}

 

[AnotherHiggins]

If I understand what you're after, then this should work for you:

=INDIRECT("SWI1!R"&COLUMN()&"C"&ROW(), 0)

You may need to tweak it to fit your exact needs. If you put this formula in cell B3 on your summary sheet, it will return the value found on sheet SWI1, cell C2.

Not to be a jerk, but your question is actually not very clear. First of all, what does any of that have to do with "dragging formats"? The rest is a little hard to decipher as well. Just a suggestion: before posting, press the "Preview Post" button and proof read your post...maybe even pop it into Word and do a spell check. It might help you get more responses quicker! For more info, see faq20-2883.

Hope that helps!

John

Every generalization is false, including this one.

 

[01Patrik]

There is an easy way to achieve this:

1/ Create a new sheet. In my example, the final sheet is called "A", and the new sheet is called "B".

2/ In A1, use the following:

=INDIRECT("A!R"&COL(A1)&"C"&ROW(A1),FALSE)

or, if you have blank cells within, and don't want them to show 0:

=IF(INDIRECT("A!R"&COL(A1)&"C"&ROW(A1),FALSE)="";"";INDIRECT("A!R"&COL(A1)&"C"&ROW(A1),FALSE))


Autofill sideways and down as far as you need!


// Patrik

 

[01Patrik]

Oops, I can see I was a bit late on that one

// Patrik