I need a calendar that, each day, will sum attendance data going back 6 months to the day. In other words, add today to the bottom of the calendar and drop the oldest date. Sum attendance for the dates displayed. ...

The RowLiner addin Software is very help full to follow where a active cell is, especially working in bigger spreadsheets. However, I found that if a spreadsheet is protected, the RowLiner border lines for columns and rows does not “move” ...

Hi, Is it possible to have a Check Box (Form Control) appear/disappear in a cell by selecting a value from a dropdown menu? For example: I have my dropdown menu in cell b2. Based on certain dropdown values, I would like ...

How can I convert a date in format DDMMYY to DD/MM/YYYY in Excel 2002. Thanks Steve.

I am trying to use a macro to print a chart in color but I am not having any luck. Does anyone have any ideas? I am using Excel 2010

I can’t find Word in the program files and I was advised to look in the C drive under program files, MS office, office 12, etc but there is no Word.exe file in there. I can open Word docs that ...

I have a pretty long string in my strbody but shortened it for this question; can someone tell me how to underline “Monthly Projections:”?   strbody = "Monthly Projections:" & "<br />"

I’m trying to copy/paste something from OpenOffice swriter to TextPad; I copy to clipboard, but in Textpad, when I paste (Edit|Paste or ctrl-v), Textpad gives me the message “The clipboard is in use by another process.” Seriously, this makes NO ...

My knowledge of excel is limited. I want to set up a simple spreadsheet template for rent received. I have tenants who may chose to pay rent weekly, fortnightly or monthly. Start with a cell that says their rent is ...

I have thousands of matching pairs of data under Col A and Col B. I am trying achieve the following: for every pair of data, there will be an “exact opposite pair” somewhere below. See example below: A B 100 162*