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