Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data need to be copied as per sheet name
Hi
I have a master sheet in excel which contain all the below details as per sheet names('status' column are the sheet names) Status Date Patient ID Docter Name Region Critical 6/25/2008 34567 Suhas IE Died 6/25/2008 12345 Pradeep US This master sheet is updated on daily bases, new recordes will been added on daily, i need a macro so that when ever the new recordes are added to the master sheet , all the other sheets similutaneous need to be filled example: if the Status column is Critical then what ever details is update next to that column need to filled in Critical Sheet....... The macro should match the sheet name and mastersheet data , then it should copy the related details to that particular sheet |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem copying from a hidden worksheet (data is copied, but alsoadditional sheet info) | Excel Programming | |||
Problem copying from a hidden worksheet (data is copied, but alsoadditional sheet info) | Excel Programming | |||
how to update a worksheet and have data copied to another sheet? | Excel Worksheet Functions | |||
Combobox data accidentally copied on different sheet | Excel Programming | |||
Copied empty cells, give sorting problem in Data sheet | Excel Programming |