I just made 31 macro and they all work perfectly.
Now my boss asked me to create 5 worksheets (for 5 stores) and make th
macro's work on each worksheet individually or worksheet specific.

Currently when i try to change the macro in one worksheet, it change
the macro for all the worksheets...

I need to make these macros worksheet specific..

If I cannot make it worksheet specific, then Can I add an IF statemen
that will tell the code that if you're in the 101-JAN04 worksheet, the
use all the information from the c:\UDC\101 directory?

HELP

--
Message posted from http://www.ExcelForum.com