The client has made the following changes to the job.
Bidding period ended early.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
want you to write a marco in excel.
Four sheets [alpha, beta, Error list, main]
take 2 user inputs
1) folder c:/test/alpha
2) folder c:/test/beta
Button value= Process
on click of button, it should loop thru all files in alpha, beta
compare the file names, if any differences then raise in Error list sheet.
1)pick each of the alpha file, copy contents in thisworkbook alpha sheet
2) pick corresponding [same file name] beta file and copy contents in thisworkbook beta sheet
3) compare [cell by cell], if any diff then raise in Error list
Error List Sheet will contain the following columns:
Beta file name
Address of Issue Cell
Alpha Cell Value
Beta Cell Value
assume: each file might have 10-20 columns/rows of data all String.
let me know the estimate and time.
Sign in or Register to see more