Renaming duplicate column names

  • I am having trouble opening the file you posted. Could you please post it again?

    You can say "THANK YOU" for help received by clicking the "Like" icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

  • The file paths are contained in a different workbook. Is this correct? Will you have multiple file paths for multiple workbooks on which you want to run the macro or only one path and workbook at a time?

    You can say "THANK YOU" for help received by clicking the "Like" icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

  • In the last file your shared, the data is in column A. In the original file, the data was in column G. That is why the macro doesn't work. What I need is a copy of the actual workbook, not a sample and a copy of the workbook which contains the file paths.

    You can say "THANK YOU" for help received by clicking the "Like" icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

  • We seem to be going around in circles. Do you have multiple files in "Z:\" on which you want to run the macro or only one file?

    You can say "THANK YOU" for help received by clicking the "Like" icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

  • Since the file.xlsx has to be opened by the macro, you will have to place the macro in another workbook and run it from there.

    You can say "THANK YOU" for help received by clicking the "Like" icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

  • Yes. Just place the line of code at the end of the macro.

    You can say "THANK YOU" for help received by clicking the "Like" icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

  • You are very welcome. :)

    You can say "THANK YOU" for help received by clicking the "Like" icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!