-
Differentiate between sources of results on cells
Hey all,
I need some ideas on this topic:
Excel workbook with multiple spreadsheets, each spreadsheet has some numbers. Those numbers are either hardcoded, or they are result of in-sheet formula, or they are a result of a fromula coming from another spreadsheet or they are loaded from external data source (FAME Populator).
I need ideas to distinguish between those cases so the result will be a cell colored differently according to which of the abovementioned cases the number belongs.
Cheers,
S.
-
You can use SpecialCells to identify formulae and Constants. Does your Fame data appear as Constants. How are these loaded?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
Dear mdmackillop,
Yes, thank you SpecialCells is one option but how does one distinguish between formulae coming from the same workshet or from another one.
What do you mean how are the Fame data loaded?
-
I've no idea how you mean to implement this or what your present data, in particular Fame data looks like. Has it any distinguishing "marks". Is it there as the result of running code or what?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Reply With Quote