I've automated as much as I can, but I am now at a road block. Any help would be great!.
Simply put,
I have two worksheets in my "My Documents" folder on my C:\ drive. Let's call one "Worksheet 1" and the other "Worksheet 2". "Worksheet 1" has data in the first tab in cells A1, B1 and C1...