Functions

Instructions on how to use macros
Can someone explain to me how to use macros in excel? I know that on the sheet that you want to designate the code you go to view code and paste it in there but I dont know what to do after that in order for the macro to work. Any help is greatly appreciated. Thanks ... 23 Feb 2010 18:15

Copy formulas from one workbook to another
I'm using Excel 2007. I wanted to copy some formulas from one workbook to another, but it becomes pictures right away (same as choices when pictures). The paste functions work fine within the same worksheet or the same workbook. It never happened before. Can someone help? Thanks. ... 23 Feb 2010 17:05

Custom Spreadsheet Properties
We keep track of the version of a file by using Prepare-Properties-Document Properties-Advanced Properties-Custom-Document number. Is there a way to have cell B41 pull this information and display it so these steps are no longer needed in order to just confirm the version number, such as: =Doc.Properties.DocNu... 23 Feb 2010 14:45

Adding values that fall between 2 dates
i'm using this to add values that are between 2 dates =SUMPRODUCT(--(G8:G26>=DATEVALUE("1/1/2010")),--(G8:G26<=DATEVALUE("1/30/2010")),F8:F26) but i need the dates 1/1/2010 and 1/30/2010 to be user input. so that those values are reading from another cell. is this possible ... 23 Feb 2010 18:15

Use of "AND"
How do i use "AND" in an if statement on Excel worksheet? ... 23 Feb 2010 14:45

#REF errors in links
I have a workbook with links to many worksheets in separate files. Each year I used to change the source files to the corresponding year and the links work fine. Now all of a sudden this year when I change the source file the links shows #REF. I don;t know?Why.But the formula is displayed correctly and the res... 23 Feb 2010 13:36

How do I round Up to in Millions?
> for example This figure 1,235,256 to be shown as 1.2 All assistance appreciated ... 23 Feb 2010 12:27

Pivot Table accessing data from OLAP cube
Hi, I am creating a Pivot table using OLAP cube (in Excel 2007) on Windows Server 2003 OS and same Pivot Table using OLAP on Windows XP. The wierd problem i am facing is that on Windows Server 2003 OS, the moment I finish importing the cube, it shows me a screen like "Drop Row/Column Fields here" and on Window... 23 Feb 2010 12:27

Pocket Excel
On the PC excel you can tab into a column, right click and one of the items in the list is 'Pick from drop down list' Does anybody know if this can be carried out in Pocket excel. I know that it won't work the same way but is there any other functions that I could use. Many Thanks Carol ... 23 Feb 2010 12:27

rounding up to the nearest 1000
i cant figure out how to round my final figure UP to the nearest 1,000. i have a list of numbers that are added to a final figure. i need to have that final figure round up to the nearest 1,000, but yet be 15,000.00 or greater so if my total is 26,581.00, i need it to round to 27,000.00 but if my final figure is 3... 23 Feb 2010 11:19