Create MACRO on below requirements
Budget: $10 – $25 USD
On personal computer drive , 4 Files are located Test1 , Test2 , Test 3 , Test 4 .
Create a Macro to open Test 1 file & sum the column H & Copy the sum on New worksheet name ' Results'
Open 'Test 2' File , Sum Column F , Copy the sum on New worksheet name ' Results'
Open ' Test 3' File , Sum Column G , Copy the sum on New worksheet name ' Results'
In Test 4 File , Sum the Column H & Copy on worksheet ' Results'.
The sum of ' Test 4' file , should match with the Total sum of ' test 1' + 'Test 2' + Test 3' + 'Test 4'
If the Result matches , the cell color should change to Green , if not to Red color
Create a Macro to open Test 1 file & sum the column H & Copy the sum on New worksheet name ' Results'
Open 'Test 2' File , Sum Column F , Copy the sum on New worksheet name ' Results'
Open ' Test 3' File , Sum Column G , Copy the sum on New worksheet name ' Results'
In Test 4 File , Sum the Column H & Copy on worksheet ' Results'.
The sum of ' Test 4' file , should match with the Total sum of ' test 1' + 'Test 2' + Test 3' + 'Test 4'
If the Result matches , the cell color should change to Green , if not to Red color