I have attached a spreadsheet so that it's easier to see what I am looking for here.
I have the formula that I want in Cell P4, but in some situations I don't have data for the previous y...
hi there,
in excel 2008 (Mac version) i'm trying to find a solution to search for part of a pattern in an array of cell, and then applying a sort function to give me the highest match.
E...
Hi guys,
How can I hide form's border completely in Excel? No min/max/close buttons.
Thanks.
Is it possible to assign a formula to a cell only if a specified cell is NOT empty in Excel 2003?
For example, I have a spreadsheet that will have a varying number of rows. I need to multip...
Hello,
I am trying to cut and paste the SQL query below into a SQL text window in MS Query after clicking the "Import External Data" in Excel 2003.
I get the error "Parameters are not allo...
I have a spreadsheet which resides in a trusted location. It has signed macros (via code signing certificate), one of which is an AUTO_OPEN macro.
How can I prevent the AUTO_OPEN macro from...
How do you make a Class module created in an addin visable and usable to other workbooks?
Addin properly loaded and registered. Office/Addins/Addin checked
within vba project... Tools/Refere...
i have used the following code (macro ) to create pivot table (help form jeverist,byundt@EE)--i have made few changes to the code they have given me.
the groups obtained after running the mac...
I'm trying to concoct a formula for excel that evaluates each cell for the state and then display a territory value.
More or less...
IF K2 = "MN", "KS", "WI", "ND", "SD" then "Midwest Te...
need help on how to write a macro that will automatically send an e-mail of a copy of an excel Worksheet as the body to a particular e-mail address.
I would like to create a 'Template' folder on our network shared drive that everyone in the network can access. Then when they go into Excel, they go down to the worksheet, click insert, and ...
How to create a user defined function in Microsoft Excel that can be accessed through all access spreadsheets?
To do this locally I open the VB editor and write what I would like. But I wou...
Windows 2000 and Excel 2000
I have multiple files with multiple sheets on which any of them will be a MS Query to download data. I want to know how to refresh the MS Query on each page separ...
I have setup a worksheet in excel that will be my data source - I would like to query that data and place the sum of the results in a cell on another worksheet?
Sheet1 has data setup to...
Hello
I have an Excel Spreadsheet which houses 4 pieces of information: Account Names, Inital Mortgage, Paid Amount to Date, and Balance do. Is there a way to generate an Letter Template ...
Hello,
We have an internal web application based on PHP and MySQL that produces HTML tables of data. The data is generated by MySQL queries in the PHP code, and the PHP write the files as ...
i have the following code to generate a pivot table from a an excelsheet(credit to jeverist,byundt,rorya@EE)
the code i have:
i would like to know if a pivot chart can be generated along ...
I have a spreadsheet with 1333 entries. At the end of this spread sheet is an entry for a company called "ETI". When I try to filter for this entry it does not show up but the comany is listed...
I am trying to create a presenttion using PowerPoint and all of the data is kept in an excel file. This is made up of names, addresses, some pictures, telephone numbers and a 500 word write u...
I have a heap of unused names in my excel file which I know is causing the file to be unnecessarily large. I can delete one name at a time but that is taking extremely long. And I need to thi...
I want to click several email hyperlinks in a spreadsheet but have them go to bcc, not to, as i don't want them to see the others email address.
I am on excel 2007, XP:, and working with financial statements in Cordobas (foreign currency); I need to convert all of the in balance sheet, income statemtns, cash flows, et al financial numb...
I have a workbook with several related spreadsheet. The worksheet is shared and protected. Users do not see their changes. I have to close the workbook and re-open to see changes. How ch...
so, column A has dates, and column B has name. how do i return the position of a match on both? i know for one, i can do match(3/1/2007,A:A,0). but what about two?
I am looking for some VBA Code to execute a comparison between two spreadsheets\workbooks and report the changes in a new worksheet\workbook. Does anyone have such code. Thanks
