General

I want to link sheets in excel to a master sheet in excel
I have 12 sheets, 1 fr each month of the year showing hourly data. I want to create 13th master sheet with advance filter linking the 12 sheets so that i can get data form criteria "date from, date to" and "time from, time to". How do i Link the Sheets? for Advance filter? I use Excel 2007. ... 8 Apr 2010 04:00

Organizing a column for what's after the @
I have a table with a 2 columns, in one there are the names of people and on the other one there are the email addresses of those people. Addresses and people have been gathered through some time and they have no specific order. Some of them work for the same organizations and I would like to send the same emai... 8 Apr 2010 09:30

Retrospective Cell Naming
If I set up a spreadsheet that includes references of the form =C3 etc, if I then define a name for cell C3 (eg "cost"), then I have to manually go back through the spreadsheet to find references to C3 and change them to the name. Is there a clever way (other than find and replace) to automatically or via macr... 7 Apr 2010 22:32

Cascading Drop-Down Lists
Thank you indeed. This was really helpful. -- "T. Valko" wrote: We can all thank Debra for having such an awesome website! -- Biff Microsoft Excel MVP "Mossykel" <Mossykel(a)discussions.microsoft.com> wrote in message news:72676933-8692-4F5E-8D35-54515E7F43FB(a)microsoft.com... ... 7 Apr 2010 22:32

Formula Help
Hi All I have a cell that I need to return a value that is either 10% more if another cell = >0 or 10% less if < 0. eg B53 =10 then C53 = (C38*10%) and add to C38 or if B53= -10 then C53= (C38*10%) and take From C38. B53 = 10, C38 = 16.10 then C53 should = 17.71 or B53 = -10, C38= 16.10 Then C53 should = 14.4... 9 Apr 2010 00:11

adding spaces
I have a cell that I want to say put in ab123456789us, but have it look like ab 123 456 789 us. Is there away to do that? ... 8 Apr 2010 11:05

Put excel data on a US map
I have sales force data(ie, salesman, customer, customer location, 09 sales, 10 sales, etc) and I would like to have the data display on a us map. Something that would make smaller or larger balls based on sales dollars, with the salespersons name and customer name, and have the ball show up where the customer... 7 Apr 2010 18:03

How do I save the same document in 2 different files
I save my budget document during each use. In Excel 2003 I was able to save it once a week to a 2nd 'safety' file as well. Now with 2007 there is no 'save as' (at least not that I can find) so am not able to save a 2nd copy for safety. It's a very different program and I realize I have to get use to the changes... 8 Apr 2010 14:03

find a record with a missing value
Hi everybody, I have an excel worksheet A B John XY John X John Y John G Ed X Ed Y Tod XY .... GHA in each records I have a name in column A and some value in column C , I want to write a fomula ( in column D ... 8 Apr 2010 01:50

Refresh of links in shared file.
I have created a shared file that has a production schedule. It has links to another non-shared file so that I can use/refresh a query to pull production information from a database and put it into pivot tables. I have a vlookup to find the totals of the part in the pivot table. When I have the schedule file... 7 Apr 2010 16:54