Announcement

Collapse
No announcement yet.

Conditional copy - headers

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Conditional copy - headers



    Hi Team, I just joined the forum today and looking for help.

    To give you a background -
    Sheet 1 - Has the Basedata having multiple column in Row 1 with different headers - around 60 columns
    Sheet 2 - in Column A, I've pasted the 15 headers matching in Sheet 1 - Headers are transposed in Row 2 to 16 (column A)
    Sheet 3 - Blank sheet
    I need a macro which will help me do the following:
    would check the headers in Sheet2, find those headers in Sheet1 copy the entire column and paste in Sheet3, these needs to be repeated for the 15 headers listed in Sheet2.
    Any expert advise would be greatly helpful. Thanks for support

  • #2
    Hi and Welcome to the Forum

    From your description ... looks like you request can easily be managed with Advanced Filter ...

    Difficult to guess why the copied Headers have been transposed from Columns to Rows ...
    If you feel like saying "Thank You" for the help received ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

    Comment


    • #3
      I wanted to achieve this flow through a Macro. This is one of the step for my other flow. The list of headers in Sheet2 can be short or can grow and Macro is supposed to find the header in Sheet1 and if it is not listed, it is supposed to skip and go to the next row. Not sure if I've explained well...Please let me know more details are required

      Comment


      • #4


        Still .. quite unusual ...

        Could you attach a sample file ...?
        If you feel like saying "Thank You" for the help received ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

        Comment

        Working...
        X