See one response to your other posting in .worksheet.functions.
(perhaps a simple INDEX/MATCH suffices)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"jeannie v" wrote:
Hi: I have created a Macro that looks at an auto-filtered worksheet. I'm
auto-filtering a name in Column A and I want it to pop the data in Column C
to another worksheet in the workbook. My problem is that the data will
change and I want the Macro to pop the new data in Column C to the other
worksheet when it auto-fiters the name. I hope this is clear and I will
appreciate any help you can offer. If you need further clarification, I will
try to give you the examples a little better. Thank You, --
jeannie v