I am using a Vlookup to return values within a sheet using cell A2 as my reference some of the data that I am returning via the lookup are dates this is ok when there is a date value in ...

I’ve created an excel worksheet, and I’m trying to track the time that it takes to finish a project. My problem is that I need to see a running (real-time) clock that shows the days elapsed between the time the ...

Having an issue, I had a search function in Excel and now it is gone. The function would search my workbook and find by name, but now I lost the option function on the search box. How can I restore ...

I am trying to insert a row that meets a cell criteria into another sheet. When it copies over to the second sheet, it just replaces the first row instead of shifting the cells. Here is my code below. I ...

What I need to know is how to reference the second sheet in a (2003, .xls) workbook when using an Excel Formula without using the sheets name. I need be able to write the following formula =Average(‘Sheet 2’!A1:C3) Except The Sheet ...

I’m trying to create graph paper with 1/2″ squares in an excel program but don’t know how many pixels it takes for each 1/2″.

I need to open this pptx-file. Can anyone help me with that? Made in Microsoft PowerPoint 2010 and cannot been seen or open with any applications… If it can’t be open, how can I fix the file. Cannot attach the ...

I have a word file I created in Word 2010 and saved as a Word 97-2003 document. I reopened it a week later and closed it. Now, when I go to open it, the File Conversion box comes up. No ...

How can I restrict Excel cell input by only Command button which I have created. Basically what I’m trying to avoid manual entry and allow data input from command button only to a range of cells.

In Excel 2010 I have a cell that looks-up a calculated valu based on the values in 3 other cells. I want that to be store as static so that when the date changes it does not change. The code ...