srinidhi
Active Member
HI,
I have 3 tabs,in a workbook
Today, Completed & Not Completed.
In Today’s sheet the data starts from A 10 & goes upto Q 500.
Here I want to search for the words Completed & Not Completed & paste only Completed data in the Completed tab & the Not Completed data in the Not Completed Tab.
The data to these tabs will be updated on a daily basis, & it shld have the old data as well(Yesterday, day before …….
So in these tabs the macro has to find the first blank cell in column A & then paste the data from colum A to Q.
I have 3 tabs,in a workbook
Today, Completed & Not Completed.
In Today’s sheet the data starts from A 10 & goes upto Q 500.
Here I want to search for the words Completed & Not Completed & paste only Completed data in the Completed tab & the Not Completed data in the Not Completed Tab.
The data to these tabs will be updated on a daily basis, & it shld have the old data as well(Yesterday, day before …….
So in these tabs the macro has to find the first blank cell in column A & then paste the data from colum A to Q.