How can I ignore the counting of blank values in pivot table ?
Thanks
Praveen Parmar
Greetings Experts,
I am working on this Excel workbook where I have 2 sheets. The first sheet a user enters data on only. The second sheet I need to actively display the same cells/values...
Hi
We get an error messenge: "one of your object libraries(excel9.olb) is missing or damaged. please run setup to install it" from a Terminal server when we login and try to open Excel. Th...
I have an access database that i want to format and print reports with using a word template. This template has an excel chart embedded into it and requires having valid values passed into it...
Hello experts
I need a code that checks 4 different cells or there values an based on all those values displays a certain text.
For example: 4 cells to be checked are B2,B4,B6 and B8
if B2...
We have an Excel form that is emailed. I want to take this form and run a macro or something to append it to an Access table or compile all the forms into 1 single Excel spreadsheet to import ...
I need your help please.
I have a spreadsheet with 3 workseets in it in my spreadsheet. I want to create a 4th worksheet and use the data, excluding the labels and dates. BUT, everyday I in...
Experts,
I need a way to convert a date like 5/15/1849 to May 15, 1849. Is there a simple way to do this.
Thanks for any help.
I have an excel program with many hyperlinks pointing to the computer they are installed upon. This program will be moved to another computer. How can I change the hyperlink address to work on...
I have written a Excel VBA application. Now I am looking for a good way to send this application to a customer.
Issues to solve:
- Experiences in the past have shown to me, that if i sent an...
Ref: http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_23723233.html
Each week I receive dozens of Excel files containing standardized info found...
How can I view 2 excel files at the same time. I am using a notebook with extended deskstop setting with monitor set up as primary device and notebook second.
I have a table that is filled mostly with calculated values from information elsewhere on the sheet or in other sheets/workbooks.
Sometimes, though, it's necessary to manually change a cell...
Hello, I am using 2007 and I cant figure out how to change the data region.
Can someone tell me the steps?
thanks
I would like to send emails from a list in an Excel 2007 workbook. I have tried to import from Outlook, but I lose the body of the email. I can manually achieve what I want by clicking on th...
I am running a macro from Excel. It opens an existing excel file, makes some changes to both files, and then closes the files.
I still have Excel running once it's done...It does close t...
I would like to be able to have a running total in my Excel Pivot table and then create a calculated field off of that running total. This is a recurring issue that I normally fix in the bac...
I want to save a workbook in a specific folder "C:\Documents and Settings\Robin\My Documents\Backups\runners" as the value of a cell F1 in another open workbook "savebydate.xls". F1 has the v...
What is the VB code used to exit excel? Exit the current workbook?
How do I do the above While saving?
How do I do the above without saving?
I'm using the Find method to cross reference items across several sheets.
my problem comes when i reach an item that does not exist in the find range
i get a runtime error 91.
is there ...
We have a timesheet spreadsheet that is protected, which we have cells that need to be spell checked. When the sheet is protected then spell checking is unavailable.
Is there a way of achi...
I have the following small sub that highlights numbers in the range if they are above or below the stated values. However, it also highlights my field headers, how do I alter this to execute ...
Is this even possible? When I click my button i would like to run this script. I works great now to save and email in xls as an attachment. Can I have it save as an XLS but attach in outlook ...
I have an excel sheet that is 1800 rows long with 5 columns in use.
I need to create a Macro that will hide (or delete) any row where all of the cells - ABCDE - have no value.
Condition: s...
Hi Gents,
I have the following problem with a VBA code which automtically generates a numbering system for some assets.Everything works as intended except when I get to level 4 and if in le...
