i have two worksheets, worksheet1 and worksheet2
in worksheet 1, i want a1=worksheet2!b1,
a2=worksheet2!b5,
a3=worksheet2!b9,
........
any way i can realize this?
many thanks!
i have two worksheets, worksheet1 and worksheet2
in worksheet 1, i want a1=worksheet2!b1,
a2=worksheet2!b5,
a3=worksheet2!b9,
........
any way i can realize this?
many thanks!
Try OFFSET:
=OFFSET(WorkSheet1!A1,(ROW()-1)*3,0)
Mark.
thanks..........
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks