how can I get an event to show up in my calendar every year on the 29th Saturday

Hi, I have several MS Excel *.xls files that are lists of things (e.g., list of books, which would contain author, title, publishing date, genre. Similar lists...

Hi, GreyCampus is conducting Free Webinar on Advanced Excel. Improve your productivity with Advanced Excel. Master in excel with tips and tricks learned...

I recently downloaded PowerPivot add-in for Excel 2010 and ran the install. I went into the options & found the add-in in the COM Add-ins. I clicked the box...

Can anyone advise how to make a simple report in Excel?? I have two columns of info that I need to group.. 1) Name & 2) Value I have over 10000 lines of...

How can i view 3 worksheets in the same workbook, tiled side by side in the excel window? Is this possible?

My company uses a program called PureEdge that enables users to click a simple "Sign Here" button and record a digital signature. The signature is...

How do I safely and securely convert an excel file (xls) to a QIF or OFX file?

Hi, I am hoping someone can help me with this. I would like to write a macro in Excel that copies the value from a cell, and uses that value to generate a new...

Hi, Whenever input data in one cell in a worksheet, how can Excel help to check if this entry (data) has never been input before after inputting the data, so...

Dear Members, I have two drop down list in the Excel sheet. say Country and State. If i choose value from Country, automatically respective state should be...

I saved a workbook with a digital signature, but now want to remove it so I can edit the workbook. When I try to remove the signature, signature is "invalid"...

I have just inserted a series of 8 calculated fields using sumproduct into a spreadsheet which references a closed workbook and have now been given the error ...

Office Version:Office 2007 Operating System:Windows XP Our organization has a hundred printer makes and models. We all use Office 2007, and we all print to...

Having trouble with formulas. I have two work sheets. Work sheet1 is a work order. Work sheet2 is what needs to be done by a certain date. What I need to do...

Hi there, I had an Excel Macro program which was running very well in Office 97. But after I had upgraded my Office 97 to Office 2003, I could not run part...

Hi, I have an excel which has automatic calculations turned on and uses RTD to get Real time Data on the sheet. The sheet is updating all the time. Whenever...

Hey all, Basically, I have a last, first, and initial in column A, B, C respectively - a list of 1000. Then I have last, first in column D, E respectively - a...

Hi I am using Microsoft Office 2007. And I am getting the problem that each time I write any link in Excel sheet, by default it converts it in to the...

Hello everbody, I have this little problem with a worksheet in excel. I was trying to make an alphabetic order ( from A to Z ). Than I noticed excel doesn't...