Create a solution that we can use to compare and update spreadsheets
$2-8 USD / hour
Completed
Posted almost 11 years ago
$2-8 USD / hour
I would like to have three columns in spreadsheet A. When spreadsheet A is compared with spreadsheet B (also 3 columns), the following should happen;
1. Contents of column A in spreadsheet A are compared with column A in spreadsheet B
2. Column B and C in spreadsheet A are updated with the contents of columns B and C in spreadsheet B - IF column A is a match
3. Rows in spreadsheet A and spreadsheet B should be highlighted if they do not match with the other spreadsheet
I would like to use this solution on an ongoing basis. You should have experience of creating macro spreadsheet solutions. I need this asap.
Thanks!
Hi Kate, I'd love to do this for you, and have the time today. Please discuss this with me first though. I want to make sure that what I am thinking of is what you actually want.
$7 USD in 3 days
5.0 (20 reviews)
4.0
4.0
23 freelancers are bidding on average $6 USD/hour for this job
Hello
I would like to offer solution to your requirement developed as VB program. This will have lot of flexibility and other advantages of a front end back end system.
I have developed similar programs on VB.net.
You can send the sample data on excel files and I will be able to show how this can be achieved by this program
Thanks
Virupax
Dear Sir,
I think I can do this.
Please check the attachment.
I have more than 8 years experience in
Accounting as well as well versed in
Excel.
Please consider me.
Always available on Skype.
Hope to hear from you soon.
Shafikul Islam.
Hello Kate
Greetings from the United Kingdom. This is the kind of project I'd love to get my teeth into and I think its something I can do fairly efficiently in a short time frame. We'll be approaching the problem from a combination and VBA macro's - sometimes the best policy is doing a bit of both and we'll be able to create some forms where you choose from the server the 'Spreadsheet A' and the 'Spreadsheet B' effectively then press a SUBMIT button where all the rules you described are applied.
I'm keen to get cracking on freelancer.com and get a few good reviews in so am free to start working asap on this for you.
Many Thanks
ExcelDictionary