I have column say E, G, I and so on, separated by some equivalent number of rows. I want to see these column in consecutively in another sheet.
I want to write a formula in just one cell and copy this consecutively in successive column and then copy this row downward.
How do I this?
Thank you.
Do you mean that you want the values from column E of one sheet to go into column A of the other sheet, and for column G to go into column B, and I to go into C etc.? I'm not sure where the "rows" part comes into it - is your data on consecutive rows in the first sheet, or are there gaps between the values? Which cells contain the data that you want to copy across?
Pete
That's right.Originally Posted by Pete_UK
What about the other questions?
Pete
Hi rajesh,
Try using the Offset formula like:
=OFFSET($A2,0,2*(COLUMN()-11) +4)
See the attached where I've used the above formula (in the yellow cell) and pulled across and down to fill in the answers.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Enter this in Sheet2 (or whatever worksheet you are using for the copy) and fill down and across
Formula:
=IF(ROW()>COUNTA(Sheet1!E:E),"",OFFSET(Sheet1!$E$1,(ROWS($E$1:E1)-1)*1+0,(COLUMNS($E$1:E1)-1)*2+0,1,1))
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks