Autofill Row (whilst skipping every other cell), using column from another sheet
HI! Thanks for considering my problem.
I need to autofill from b28 along row 28 in the source sheet, from column e in 'Sheet1' starting in e2 going down, eg: e2,e3,e4.
However, I need to do this whilst skipping every other column in the source sheet.
e.g.
b28= 'Sheet1'e2
d28= 'sheet1'e3
f28= 'sheet1'e4
etc
Appreciated if you could help! x
In B28
=IF(MOD(COLUMN(B1),2)=0,INDEX(Sheet1!$E:$E,COLUMN(B1)/2+1),"")
copy across
Life's a spreadsheet, Excel!
Say thanks, Click *
Perfect! Thank you immensely!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks