copying row to row
If I refer A1 in B1 and then copy B1 to B2. In this case B2 will be reading
A2 which is obvious. As i further copy B2 to lower rows it will continue the same way. Where the column is same but the rows are progessive. My question is that is thr any way I can copy cells down the rows making columns as progressive? |
copying row to row
Zen
Try the offset function with the second offset argument (column offset) equal to =row(). For example if you want formulas in column B, starting in row 2 to match row 1 starting in column A you would need to use: =OFFSET($A$1,0,ROW()) which as you copy it down, would reference cells moving to the right. You may need to adjust slightly depending on your starting points. Alternatively, you could use an array function, =TRANSPOSE(...) where the cells in the column equal the TRANSPOSE of the horizontal stuff. Good luck. Ken Norfolk, Va On May 22, 4:27*pm, zen wrote: If I refer A1 in B1 and then copy B1 to B2. In this case B2 will be reading A2 which is obvious. As i further copy B2 to lower rows it will continue the same way. Where the column is same but the rows are progessive. My question is that is thr any way I can copy cells down the rows making columns as progressive? |
All times are GMT +1. The time now is 11:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com