Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

HELP! - want column value copy to row

Posted by Harry on May 10, 2001 9:06 PM

I have the value "1" in cell A1, "2" in cell A2 and so on. I have the value "a" in cell B1, "b" in cell B2 and so on. I click in cell F1 and enter "=A1" and I get "1" as the cell value. Great. Now I click on F1 and drag to the right. I get "a" (the value in B1. I want to be able to get "2" (the value of A2). I want it as an auto reference so that when A2 changes, G1 changes as well. I want to pull right and have it get info going down.

Help !!
Harry -

Check out our Excel Resources

Re: HELP! - want column value copy to row

Posted by Kevin James on May 10, 2001 9:27 PM

Hi Harry,

Sorry to be the bearer of bad news, but that simply is not the way Excel works. If you are trying to save yourself the time of typing formulas, you CAN do that by copying the formula down and THEN moving each formula to the cell you want to see it in.

Kevin

Re: HELP! - want column value copy to row

Posted by Anon on May 10, 2001 9:53 PM

Here's one way.
Enter the following formula in cell F1 and drag across row i as far as required :-

=INDIRECT("A"&COLUMN()-5)

Re: HELP! - want column value copy to row

Posted by Harry on May 11, 2001 1:07 PM

YOU ARE A GENIUS !! IT WORKED!! THANK YOU SO VERY MUCH

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.