Anyway, as you can see there are two sets of counters in the sheet that I have attached. First, I need an additional two sets of counters (i.e. there is currently one counter set in columns A-E and a second counter set n columns F-J. I need a new counter set in columns K-O and another set in columns P-T.)
Next, the current formula only works if I manually enter a new value in the columns entitled "Number 1". All of the columns that will be "Number 1" columns (A,F,K, and P) will be DDE Linked to my stock trading platform and will update automatically. I need this formula to be altered so that the counters function in the exact same manner, but change automatically when the DDE linked cells change. This is also described in the post "Excel Event Counter"
Finally, I will need the columns labeled "# (1>2) and # (1<2) to create a timestamp when the values in these cells change. This request is similar to the request in my old post "Timestamp in Excel." Once again, these cells will be changing automatically and I need the timestamps to be able to update automatically when a change occurs. The targets and timestamps are as follows:
Cells in column C will timestamp column U
Cells in column I will timestamp column V
Cells in column M will timestamp column W
Cells in column S will timestamp column X
Note: When I ultimately construct this spreadsheet, the cells in the columns Labeled "Number 1" and "Number 2" will be populated when the spreadsheet opens.
Thank you, I know this is a tough one but I greatly appreciate the help. Please let me know if you have any questions.