title: Excel Paste to visible, Transpose as Link combine function
body: <p>Hope you all are doing good. I am working on a workbook in which i have a column of 10 consecutive cells.</p>
  
  <p><a href="https://i.stack.imgur.com/1aBH3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1aBH3.png" alt="Data to be Copy"></a></p>
  
  <p>On another sheet there is a row where i want to paste that data as transposed but the problem is, some cells in that rows are not consecutive some of them are hidden. like in image: 
  <a href="https://i.stack.imgur.com/zjPi5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zjPi5.png" alt="Data to be pasted"></a></p>
  
  <p>Now i want to paste Data to visible cells only as Transpose and those cells must be paste as a link as if any changes made to first sheet, the relative cell in second sheet should also be change. Luckily i have done much working by my self as i found how to paste to visible cells only by following VBA code: </p>
  
  <pre><code>Sub PasteToVisible()
  'Declarations
  Dim Range1            As Range
  Dim Range2            As Range
  Dim InputRange      As Range
  Dim OutputRange     As Range
  
  'Prompt Box Title
  xTitleId = "Paste to Visible"
  'Start Input Range
  Set InputRange = Application.Selection
  'Select input range box
  Set InputRange = Application.InputBox("Copy Range :", xTitleId, InputRange.Address, Type:=8)
  'Select output range box
  Set OutputRange = Application.InputBox("Paste Range:", xTitleId, Type:=8)
  'Loop to paste the range in visible cells
  For Each Range1 In InputRange
      Range1.Copy
      For Each Range2 In OutputRange
          If Range2.EntireRow.RowHeight &gt; 0 Then
              Range2.PasteSpecial
              Set OutputRange = Range2.Offset(1).Resize(OutputRange.Rows.Count)
              Exit For
          End If
      Next
  Next
  Application.CutCopyMode = False
  </code></pre>
  
  <p>End Sub'</p>
  
  <p>This can Paste values to visible cells but in columns only (Not Transpose). For Transpose and Link, I am using a simple excel formula of Transpose as in Image below: <a href="https://i.stack.imgur.com/OK8lg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OK8lg.png" alt="enter image description here"></a></p>
  
  <p>This can link the values in Transposed form. I want to combine all three functions (Paste to visible, Transpose and As a link) in one Step. Please Help me on this. I will really appreciate any suggestion and Help. Thanks in advance.</p>