Is there a macro where I change a cell in one sheet and the pivot table will auto refresh. If I change the cell B18 in Dashboard sheet, the pivot table in...

I can export from my MRP system into an excel format, but this does it in a way so that i can't manipulate the data. all the cells have a ' before the value....

I needed to create a text string which is a formula. I did it and now have 400 entries like the following: =DATE(2003,10,04) Each of these entries is a...

I have a pivot table with 155 values and the count for each value. I know that by double clicking on the count in the data area the details will open in a...

The message is: Opening the VBA project in this file requires a component that is not currently installed. This file will be opened without the VBA project....

need help incrementing a row of inventory numbers (that are preceded by a letter) formula to increment U0750 to U0751..to U0850. also another column of alias...

I have a column of comments about certain Names in individual rows. I also have a column with a list of just names. all of the names in column A are...

I have cca 150 entries in 6 column table made in excel 2007. One of those 6 columns contains links to pdf files saved in separate directory on the same hard...

I have a string imported from a ".csv file (phone number) as follows. "=1 123-456-7890). I need to end up with a string formated as a # as followes...

Could anybody tell me the difference between "--" and "*" in Sumproduct with Example If Possible with Example Thanks in Advance

I have one excel-file that contains some values; ABC, CBA, AAA etc. Then I have another file which contains all of these values and more (its actually text)....

I have installed windows xp & ms office 2007 on my PC, I am facing the problem that excel sheet is opening with every thing right aligned, for example: First...

Dear All... Just a few ago. I have 2 nice codes that works visually very well. The good thing is, these Codes do not require me to go thru the menuselection...

Hi, I want to do a simle routine in excel which will save me alot of time. I have mentioned the details in the excel file which is at...

A B 1 a20 I want cell B1 to read "act" if A1 begins with an "a" or B1 reads "avsp" if A1 begins with an "av" or B1 reads "hp" if A1 begins with...

Hi Specialist, How can I get the Currency value of a range for below table: Col A (Currency) Column B (Price) EUR 100 GBP...

please give me syntax for that case!

Hi, I have a pivot table with multiple column fields: Part number, warehouse location, workstation location. I would like to display the fields in the order...

I have installed windows xp & ms office 2007 on my PC, I am facing the problem that excel sheet is opening with every thing right aligned, for example: First...

Hi guys.... can we add detail if we link cell... example Col A 1 100 2 8 now in another sheet i want to link col A1. usually the simply way just =A1...