Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Taking content from worksheet,loc it in another, and if exists. copy it to a third...
I work for a hospital, and I have two worksheets...one with patien
names, and doctor names, and then another worksheet with patient name and appointment dates. These worksheets are both located in ON workbook. I need a script that take a name from the patient name column in shee 1, try and find it in sheet 2, and if it exists, to return to sheet and copy the entire row to sheet 3 I approached it obviously starting with the Do...Loop method, usin functions I copied from a Macro recording. If I could make the resul of the find boolean then I wouldn't be asking you guys this now. I als tried a different a approach using the For...Next method but that didn produce the result either... If someone could come up with a script for me I would greatl appreciate it.. Thanks alot! Dav -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Only allow cell content if it lready exists | Excel Discussion (Misc queries) | |||
copy row content from one worksheet to another, if a condition met | Excel Worksheet Functions | |||
do not copy data to another sheet if exists | Excel Worksheet Functions | |||
How do I copy a cell (content AND format) from one worksheet to a. | Excel Worksheet Functions | |||
How to sum value from master worksheet taking value from other close worksheet | Excel Programming |