I need Sheet A Column B to autofill/drag to show the value from Sheet B Column H, but where the value is spaced every 10 rows.
Example need Sheet A Column B Rows 1, 2, 3, 4 ... to show
=SheetB!H16
=SheetB!H26
=SheetB!H36
=SheetB!H46
I need Sheet A Column B to autofill/drag to show the value from Sheet B Column H, but where the value is spaced every 10 rows.
Example need Sheet A Column B Rows 1, 2, 3, 4 ... to show
=SheetB!H16
=SheetB!H26
=SheetB!H36
=SheetB!H46
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks