skip multiple cells

I'm pulling an ID from a seperate Workbook that lists the the IDs in Column D vertically. I have a sheet that I need to copy these ID's to, but the formatting goes horizontally. For example, Assignment 1 Assignment 2 Assignment 3...

Hi guys and a Happy New Year! Please give me a helping hand in this matter: Public Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("A7")) Is Nothing Then Dim lastc As String, j, firstc As String, sstep Dim i As Long, s As Long, e As Long firstc =...

Hi guys and a Happy New Year! Please give me a helping hand in this matter: Public Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("A7")) Is Nothing Then Dim lastc As String, j, firstc As String, sstep Dim i As Long, s As Long, e As Long firstc =...

Ive checked a lot of solutions via web-searches, including Mr Excel using INDIRECT and other crazy long-formulas, but havent found anything SIMPLE addressing this: I need to skip FOUR rows on a separate worksheet and display the contents of that cell. E.G. The contents in Sheet2 of C7, C11...