function

[n4navin9 via OfficeKB.com]

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

 

[Pete_UK]

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