How to update a cell based on date in excel and store that value A few weeks back I was asked to create a rule in Excel that would recalculate a cell’s value ONLY on Monday! And store that calculation. What? Hmm.. Then I thought, wait a minute, I should be able to do this in the cells directly. At first I tried to do this all in one… Read More
Cant cut and paste a formula in excel? Could be a skype bug This through me for a look. Seems that if you have a skype plugin installed, you cannot cut and paste formulas in Excel. Pretty random till you think about it. The skype plugin is pretty aggressive trying to capture what it thinks are phone numbers and its totally possible the its intercepting the paste function… Read More
How to make Excel open each file in a separate window. Tip #198 As a developer and analyst, I heavily rely on the powerful features and flexibility that Microsoft Excel provides for various tasks. This was especially true when I was supporting enterprise level accounting systems. I would often be working with two or more workbooks at a time, and loved having the ability to view two worksheets… Read More