Forum Discussion
copy row based on columns header and row color
I have a macro which copy's the entire Sheet 2 to Sheet 1 based on the headers. For an example, Sheet 2 has multiple columns and Sheet 1 will have only 5 or 6 column with headers of Sheet2. With ...
Hi Venkatraj E,
Have you used Power Query at all?
If you have Excel 2010, 2013 or 2106 or later then that would be my recommend approach, then add an extra column with a Y against each row you'd like to transfer rather than relying on the colour.
Is this an option for you, if so I'll attach an example
Thanks
Wyn
Wyn Hopkins Thanks for your response. Unfortunately, the source file is generated by an application. So, we have to achieve this through a Macro/VB
- Hi
But your source table for the Macro is in the Excel sheet.? Power Query could reference that table or the source file itself potentially?Could you share some example with an excel sheet? I'll review the Application output, whether I could tweak.
Hi Venkatraj
Is your application output an Excel file, or CSV ?
What version of Excel do you have (2010, 2013, 2016 ?)