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.
I would like to have a button on "Worksheet 1" that will take the data in cells A1, B1 and C1 and push them to a specific tab in "Worksheet 2". Also, the data must be added to the first row that does not have data present. Ex. so if I have already pushed data to "Workbook 2" a few times, data added the next time will be one row below the last.
Any help would be GREATLY appreciated!!
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.
I would like to have a button on "Worksheet 1" that will take the data in cells A1, B1 and C1 and push them to a specific tab in "Worksheet 2". Also, the data must be added to the first row that does not have data present. Ex. so if I have already pushed data to "Workbook 2" a few times, data added the next time will be one row below the last.
Any help would be GREATLY appreciated!!