I require 2 Separate Programs to be written for me to Run on my Desktop PC, Windows 7, 10 +.
The Programs are to do the following.
1. Enable me to Select Multiple Excel files and the program to perform the following..
Automatically edit the files by removing unwanted columns and editing existing column titles.(These are constant and don't change).
2. Create 2 new Columns at the end of the Table by Calculating figures in 2 existing Rows (Resulting in an Average of the Total).
3. Save the resulting files as MS-DOS CSV.
4. Upload to a Website Server (FTP ?) over writing existing files. (If Possible).
2 Programs to manipulate 2 Different but Constantly formatted Excel files that i will be able to Select Multiple of and re save in CSV format and upload to Website Server overwriting Existing files.
I will be running this program once a week to update our website.
I do all of the above manually and it gets Boring :)
Also Open to suggestions if my thinking is off the scope LOL.
I have attached a 2 Sample Files. Before and After.
I have also added the After File for you to view.