Microsoft Office Questions? Ask a IT Expert for Support ASAP
Welcome to JustAnswer. My name is XXXXX XXXXX I will be assisting you today. Please do not rate this session until it has been completed.
Can you tell me which version of Excel you are using?
If it is 2007 or later, take a look at this document: http://office.microsoft.com/en-us/excel-help/track-changes-in-a-shared-workbook-HP010197381.aspx
Sorry, scratch that ... it's not shared because you're downloading changes from another site.
Well, the short answer is yes, it can be done. But it is going to take quite a bit of VBA coding to do it. Have you done any programming using VBA?
If you happen to be using Excel 2013, then you can use the "Inquire" function to show the differences: http://office.microsoft.com/en-us/excel-help/what-you-can-do-with-spreadsheet-inquire-HA102835926.aspx
Or you can use Spreadsheet Compare for other versions of Excel: http://sourceforge.net/projects/spreadshcompare/
Let me know if any of that helps or if you still need more instruction.
Hi and thanks for the help. Using Excel V 2010.
No, programming experience at all. Id like the solution done for me
ahhh ... I'm sorry but I'll have to opt out then. I am kinda' strapped for time right now and this would take a few days worth of work.
I understand. Thanks anyway
No problem. If nobody has picked up the question by Monday, then I will revisit the question and maybe we can get something working. In the meantime, please take a look at those links to see if they help you anyway.
Appreciate the info. I will check them out but the solutions there will need to be VERY easy to follow in order for me to get the results I want. Cheers.
I think you might like the last one ... it's very easy to run through. Perhaps I'll talk to you on Monday. Have a great weekend!
Hi, the compare.xlam program works pretty well. With a bit of tweaking, it would be what Im asking for.
Any idea if that is possible?
I'm Lindie, and I’m a moderator for this topic. I've been working hard to find a professional to assist you right away, but sometimes finding the right professional can take a little longer than expected. I wonder whether you're ok with continuing to wait for an answer. If you are, please let me know and I will continue my search. If not, feel free to let me know and I will cancel this question for you. Thank you!
Hi, yes Im happy to give it another few days. Didnt think it would be this hard. Thanks
Hello, Thank you, XXXXX XXXXX continue to look for a professional to assist you. Please let me know if I can be of any further assistance while you wait. Best,
Hi and thanks for the feedback. I have previously tried the COMPARE software and it does help. Was hoping there would be something more specific to what I needed though.
I cant find the VLOOKUP system in excel, I'm new to excel (2010).