LinkBack URL
About LinkBacks
ainon ithnain 
I have a macro (MacroFormulas2Values) that changes the formulas in a row to their values. How to automatically trigger this macro after the formulas in a particular row have displayed the results in black font?
I have a macro (MacroFormulas2Values) that changes the formulas in a row to their values. How to automatically trigger this macro after the formulas in a particular row have displayed the results in black font?
Is it happening with the help of Conditional Formatting?Originally Posted by ainon ithnain
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Yes. The font color of the cells in a row changes to black from white when the results in a cell in that row are different from the contents in the cell immediately above it.
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Survey-Instrument-Report-Sample.xls
A sample workbook is attached herewith.
Please understand our pain because your's is a new set of data to our eyes, without proper description about cell/col reference and which sheet and all we can't able to provide the exact solution
As I would appreciate any help, let me elaborate on the programme. I have a summary sheet in which I input readings of survey instruments every week or every month, say. For each new reading of a survey instrument, the reading which I put in the summary sheet is then captured and displayed (via formula) onto a detailed table of readings (on a separate worksheet) of that instrument. Each row of the detailed table shows the reading for a certain week. Once a certain week's reading has been shown in a row of the detailed table, I will then change the reading (computed via formula) to its value. Any new reading for the instrument that is manually typed in the summary sheet will then be captured and shown in the proceeding row. If I do not change the computed result/reading (formula) to its value, then any new reading will still be displayed in the same row as the previous week reading, that is the new week's reading will overwrite the previous week reading. I wish for the changing of the formulas to its values to be done automatically instead of my current method of using a shortcut key to run the macro to change the formula to its value.
But your post #7 description does not covered the Conditional Formatting Part
What I suggest is instead of moving the data here and there... just keep a master data and you can easily extract the required output by way of using PIVOT TABLE and project it in whatever way you want
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks