Well I have had help from several people on here to get it to do what I want it to do.

I did notice 1 error a week later. There are other workbooks that contain several worksheets (as opposed to the ER which contains just "emergency room"). The bill analysis clears ALL worksheets in a single workbook. Not really a problem except it only clears them and does not do the final step of putting "FACS#" into the cell and selecting the same. It only does that on the worksheet it's used on.