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 ...
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?
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 ?)It will be Excel Sheet and 2013 is the version what we use.