Why don't you just apply a filter to the master data and select "paid"
for the status column. Highlight all the visible data and click <copy
then select a (blank) paid data sheet and paste the data in. Repeat
this but for "unpaid" and copy the filtered data into the unpaid data
sheet.

Hope this helps.

Pete

n4navin9 via OfficeKB.com wrote:

hello
i want a function or macro to solve the following issue

i have 3 sheets in excel
1.master data
2.paid data
3.unpaid data

in master data i have data say name,address,reg.no,stauts
i want a function or macro which will search for "paid" in "status" column
in master sheet and copy that data in paid sheet and the same for unpaid
status


pls reply

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200701/1