483 reputation
414
bio website
location Belgium
age 27
visits member for 3 years, 5 months
seen 2 hours ago

Apr
23
answered My outlook 2010 ribbon does not have the vote buttons how do I get the vote commands to show
Apr
19
comment Randomize table guests in Excel
how many guests can a person have?
Apr
10
comment How can I sort a list of numbers, by its last 3 digits in Excel
basically, VBA can solve your problem without having to add additional columns/data to your sheet.
Apr
10
comment How can I sort a list of numbers, by its last 3 digits in Excel
Is VBA out of the question?
Feb
20
awarded  Popular Question
Sep
11
comment Paste a range into a filtered table
Yes, I've created a simplified copy to test it and to use it on here. Those 5 values represent the data we have to copy from the other sheet (so in fact thousand of numbers compared to the 5 here).
Sep
11
comment Paste a range into a filtered table
No, we have thousands of numbers from another sheet that we want to past in an existing table that's filtered. It's gonna be a one time paste, but doing this manually will take a long time.
Sep
11
comment Paste a range into a filtered table
@DaveRook: should be clearer
Sep
11
revised Paste a range into a filtered table
added 26 characters in body
Sep
11
asked Paste a range into a filtered table
Aug
13
comment Ok to play games on a laptop (heat)?
When using a laptop, make sure there enough space beneath you laptop so there's room for the hot air to escape, this will help alot. Also counts for consoles.
Aug
13
comment Tick/Untick check box/radio button/toggle button from the keyboard
If they are in the desired state, why would you want to tick/untick?
Jul
3
comment Use a password to protect a text file
@Bob: isn't that the first thing you do with a flash-drive, format it into NTFS?
May
25
comment Large Operation error when sorting in Excel
Then the message your user is getting is pretty obvious, your data has grown too large and needs more time computing changes. You can do 3 things: wait for the workbook to recalculate, rethink how you build up the workbook or consider an alternative for excel.
May
24
comment Large Operation error when sorting in Excel
Is this workbook growing in size, or is there a cleanup on data every now and then?
May
23
answered Excel 2010 Help name worksheets automatically
May
22
awarded  Enthusiast
May
9
comment Excel - Locked for editing by ' '
@TimtheEnchanter: I've edited my answer and added a possible cause to this problem. Maybe that can explain why it happened.
May
9
revised Excel - Locked for editing by ' '
added 660 characters in body
May
9
comment Excel - Locked for editing by ' '
@TimtheEnchanter: so, you still can't unlock the sheet or is there another issue?