MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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 -


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

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)

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

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