I am trying to write a macro to fill a cell formula with +value(cell located at Control+UpArrow) which reference the grand total line of a pivot table. The...

Rather than creating a complex form with all the associated VBA coding I have created a worksheet which will transfer information to another sheet - using one...

Microsoft office excel security notices pop up is displayed when I start Excel 2007 to either "enable macros" or "disable macros" I enabled the 3 of them I...

Unfortunately, that article does not show you how to make the fix in Windows 7 and the "advanced" button is no longer there when you're in the screen to...

I have recently moved from Excel 2002 to 2007 and when saving a large file with several macros and reopening it keeps saying that there is unreadable content...

I have downloaded some worksheets to practice from Office Online. When I open the worksheets also the browser is opened displaying the instructions for that...

Microsoft office excel security notices pop up is displayed when I start Excel 2007 to either "enable macros" or "disable macros" I enabled the 3 of them I...

OK- What I have is an xls file with 2 worksheets (200 and availability) . The formula I'm using is: =vlookup($b3:$b202,availability!$A2:$B437,2,False) '200'...

can anyone please help me out with a formula wherein i have some 100s of records in an excel sheet,with coloums as below S.No item No. issue date expiry...

I have a spreadsheet with a cell containing: ="Print Date: "&Text(TODAY(),"mmm-dd-yyyy") I want to add another cell that reflects the date of the last time...

I have a full name in A1 but I want it to read as: Full Last Name, First Name Initial. For example, I would like to convert John Appleseed (a1) to...

Hi, I have a Pivot table with some numbers in it. Is there a way to replace the numbers with a text? For example: replace all numbers 1 with "yes" . Is this...

(I am working with XP and Off2007) ctrl # (UK keyboard) applies a date format. Where do I define which date format this short-cut applies? What I have...

Hi, I am using Microsoft Excel 2002 (10.6852.6858) SP3. I am not able to view files with extension xlsx. I tried with downloading Microsoft Office...

Hi I need some help, i have a simple formula that sums for example AA40:AG40. Every week this has to increment across 1 column ie. AB40:AH40 in week...

Using the belowing formula in Sheet 1 Cell K80 (Date Formatted) =IF(ISBLANK(A60),"",VLOOKUP(A60,Data,20,FALSE)) If Data,20 is blank how can I change the...

using the following formula in sheet 1 Cell K80 (formatted as Date); =IF(ISBLANK(A60),"",VLOOKUP(A60,Data,20,FALSE)) How do I change the formula to have cell...

Hi all, I downloaded office 2010 from internet. But when I tried to create Excel fil by right clicking New on desktop there is no Excel icon...

cannot edit excel worksheet inserted in word document when reopening word...

Hi: I am trying to write an if formula that if B2 is equal to a specific date in a range of dates then it is the end of a pay period, if B2 is equal to a...