a macro that can copy data from copy.xls to our current excel macro.xls based on criteria:
I need a help...
I need a macro that can copy data from copy.xls to our current excel macro.xls based on the following criteria:
* Get the filename of another excel(copy.xsls) in B1 cell by clicking on the button in the C1 cell of our current file (macro.xsls)
* have to read the cell value in the copy.xsls based on the criteria
Like for example :
in the Lth column having the header at L5 filter criteria "Yes"
Copy the H column values in to the A column in macro.xsl
|