146 reputation
6
bio website
location Tokyo, Japan
age
visits member for 1 year, 4 months
seen Jun 30 at 8:32

Apr
29
comment Excel 2013, can data be re-sorted automatically?
@Iowak, if you like please write up an answer and I will mark it as sought-after. Thanks again for your valuable help.
Apr
9
comment Excel 2013, can data be re-sorted automatically?
yes thanks, I fixed the issue now. Thanks
Apr
8
comment Excel 2013, can data be re-sorted automatically?
@lowak, the newly inserted is the last code block which runs in WorkSheet_Calculate(). The first code block that schedules workbook recalculation sits in "General" and the StartTimer() method is invoked upon the click of a button in one of the worksheets. I think I may have found the problem: The code that re-sorts the tables is referenced on ActiveSheet which is not correct when being on a different sheet and kicking off the "Workbook re-calculation macro"
Apr
8
comment Excel 2013, can data be re-sorted automatically?
@lowak, thanks for your offer to get back on this, I find problems with my current macro within Worksheet_Calculate. My settings to Calculate are always set to manual, and I already run another macro that refreshes the whole workbook at specified intervals. My problem is that sometimes when I start the macro that refreshes at specified intervals I get a run time error that originates from the newly inserted macros that refresh the tables. I edited my question to show some code, do you mind taking a look? Thanks
Apr
7
comment Excel 2013, can data be re-sorted automatically?
well just played with it and Worksheet_Change seems to be much better than sticking the macro into Worksheet_Calculate, for whatever reason. Runs pretty smoothly now and I guess I can just go with that for the time being. Thanks
Apr
7
comment Excel 2013, can data be re-sorted automatically?
So, I take it there is no function within Excel2013 that activates automated re-sorting of tables? I am surprised about that because conditional formatting adjusts automatically on any changes in source data. So, I find it hard to believe that no sorting functionality exists that re-sorts on changing data. I understand that I can simply record a macro and re-sort manually and plug the code into the WorkshSeet_Change() event method, but its extremely dirty, the slightest change in column renaming breaks the code to just name one issue.
Apr
7
comment Is there a dynamic sorting feature in Excel 2007/2010?
@dav, is there a way to re-sort automatically? I have automatically updating cells and depending on incoming values the rankings change. I am looking for a way to have the table resort automatically (similar to conditional formatting) without having to click the re-sort button.
Feb
21
comment Wakeup PC upon mouse click but not mouse move
Given the apparent impossibility of what I asked for I still mark your answer for the effort put in, thanks.
Feb
19
comment Wakeup PC upon mouse click but not mouse move
@Joe, agree its for a HTPC, the mouse is placed on the coffee table and I do not want the HTPC wake up from sleep each time the wireless mouse is moved by a bit.
Feb
16
comment Wakeup PC upon mouse click but not mouse move
@HashiramaSenju, I do not see how your link points to anything that differentiates between mouse click vs mouse movements to awake a PC from sleep.
Feb
16
comment Wakeup PC upon mouse click but not mouse move
Can you name a single motherboard that has such feature? Mine does not and I checked the obvious before I posted this question