Seems pretty simple, but I can't figure it out. I want to pull every 7th cell from a column in another workbook to my current worksheet. So, for example, if I have 14 cells filled in a column, with the number 1 in A1, 2 in A2, 3 in A3, through 14 in A14 on one worksheet, I want to link my current worksheet to it and reference the appropriate cells so that '7' and '14' appear in cells A1 and A2 on my current worksheet. Then I'd like to do that for every 7th cell in the column.
Thanks.
Bookmarks