omarespo
09-30-2008, 12:17 PM
I need help creating code for what I am trying to accomplish in Excel 2003.
I have two tabs, Tab 1 and Tab 2. In Tab 1, I have a database query that is refreshed on a daily basis. In Tab 2, I have rows of data that I have copied from Tab 1. So Tab 2 is a history of data copied from Tab 1.
I would like code that would copy rows of data from Tab 1 into Tab 2 if a certain cell in the row is indicated as "yes" and that row is not a duplicate in Tab 2.
I hope this makes sense.
Thank you
I have two tabs, Tab 1 and Tab 2. In Tab 1, I have a database query that is refreshed on a daily basis. In Tab 2, I have rows of data that I have copied from Tab 1. So Tab 2 is a history of data copied from Tab 1.
I would like code that would copy rows of data from Tab 1 into Tab 2 if a certain cell in the row is indicated as "yes" and that row is not a duplicate in Tab 2.
I hope this makes sense.
Thank you