#1
|
|||
|
|||
How to create a macro to calculate the differences
Is there a way to create a macro that highlights data based on another data source and calculate the differences compared to the source data? |
#2
|
||||
|
||||
Your post is quite ambiguous. What data sources, what is to be highlighted and what constitutes a calculation of differences?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
I'm in a office pool and I want to compare my selections to everyone else's and calculate the total differences between my selections and theirs. My selections will always be highlighted and I want only the selections that are the same as mine to become highlighted, then calculate each to show the total differences on each selection compared to mine.
|
#4
|
||||
|
||||
Selections of what? A selection is only something you can see on-screen, with a range selected in an open document. You can't use VBA to compare what's selected on your screen against what someone else has selected on theirs.
Quote:
If you're trying to compare documents, you can use Word's built-in Document Compare tools, without the need for VBA.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Description of Uses/Differences in Placeholders | CathClaud | Mail Merge | 6 | 06-23-2014 06:31 PM |
Error in calculating differences | kiwikees | Excel | 2 | 06-15-2014 06:22 PM |
Macro to calculate a value of a checkbox. | stephen_ | Excel Programming | 1 | 06-27-2012 04:57 PM |
Calculate differences between text cells? | poobear | Excel | 2 | 05-19-2012 06:43 AM |
Question regarding differences among styles | bigsnowdog | Word | 0 | 08-01-2010 02:41 PM |