Awesome, thanks for the quick reply, exactly what I need to make my life easier!! I knew it could be done. Now I won't need to import the worksheet into Access anymore.