Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |