Hi all proffesionals,
I would like you to help me with this vision of mine how to generate "Result file" with just one click
Source_file.xls
I have 1 source file containing queries. Every query in column A have "Yes" or "No" and rest of columns are filled with data.
Result_file.xls
I am always copying manualy the rows containing "Yes" to another "result.xls" file. In the result file the copied data are starting at A7 Cell (can start from the first blank Ax cell). One more thing, i copy from source file only rows from B column to I column.
Here i would like you to help me out. It would be great if i can "play" the macro to do this for me.
Thank you very much
Pavel
Bookmarks