Related:
- Need Macro Excel Net to Zero
- Spell number in excel without macro - Guide
- Macro excel download - Download - Spreadsheets
- Excel date format dd.mm.yyyy - Guide
- How to take screenshot in excel - Guide
- Excel free download - Download - Spreadsheets
3 responses
You have TWO $100 values in your list. Which of these should match to the ($100)? Are all of these amounts for the same account? Even if they are, without something to definatively tie these records together, ie. Invoice# then I think this is a lost cause.
Some thoughts:
What it should do: Find first negative value, go down the list to find a positive match or matches, highlight all matches. Repeat for the next negative number in the list.
Should the search ignore those values that have been previously matched?
Should a different color be used for each match found?
If there are a lot of matches using the same color for all matches could just make the list the same but in color!
How is the search going to be done, what should it look for?
Search for one set of matches based on user input?
i.e. User enters -100, macro finds all records that equal 100
or i.e. Users enters -100 and macros finds all records that sum to 100
Its more complicated than imagine.
What it should do: Find first negative value, go down the list to find a positive match or matches, highlight all matches. Repeat for the next negative number in the list.
Should the search ignore those values that have been previously matched?
Should a different color be used for each match found?
If there are a lot of matches using the same color for all matches could just make the list the same but in color!
How is the search going to be done, what should it look for?
Search for one set of matches based on user input?
i.e. User enters -100, macro finds all records that equal 100
or i.e. Users enters -100 and macros finds all records that sum to 100
Its more complicated than imagine.
