Jayceejay, Did you ever get your link broken? I have the same problem. And I don't see where there was ever a clear answer to what to do. I do not want my...

I deal with both companies and end users and I'm trying to figure out how to set up the contact table. My plan was to set one table for companies and have...

i need to know how to get formula printed on the spreadsheet. please advise margaret

=IF(C7="","",VLOOKUP(C7,'Sheet3 (2)'!$A$2:$C$152,2,FALSE)) this is my formula I would like to be able to add the list. I tried following the dynamic...

Here is an example of what I am talking about. A B C D 1 A B C D 2 2 41100 274 584 3 2 41100 274 625 4 2 41100 274 333 5 2 41100 274 102 6 2 41100 274...

Hi, I would like to duplicate an existing spreadsheet with all the formulas but none of the data. Does anyone know how to do that? Cheers Gavin

Hi I have values in columns A to ...say G. I want to quickly (without retyping the values) flip the order so that what is now in column A appears in column G,...

How do I create a mailing list in excel? Excel looked like a math thing which scared the daylights out of me. Up to this point in my career I've been able to...

When I concatenate two fields, why does a large space appear between both entries? Is there a setting that I should check out?

Hope I can clarify. Here is an example of what I'm working with. Sheet One is Raw Data dumped in from a seperate report. Sheet 2 is where I'm doing all my...

In excel I maked a right click menu with variabel values. After all, I found that menu in the whole application, this was not my intention. I deleted het menu,...

Hi, When I am working on my websites I save 'snippets' of code for use elsewhere. These 'snippets' are quickly called from the software (Dreamweaver). There...

I am trying in vain to use sumif and countif formulas with reference cells in the criteria. For example, in the formula =SUMIF(D5:DS5,"A10",D8:DS8), I have to...

I'm going to build a house and I want to keep the records of the project using Excel. I'm a novice to both and any advice will be appreciated.

I use the Combo Box pull down menu buttons a lot. I click on the Box, select an item from the list and the relevant data pops up as expected. How can I make a...

Hi, I have what I think is a formula...on Sheet 1 I have a total $ amount for items sold. I typed in L3+M2 (the L column is profit and M is the total..NOW..on...

I have a list of 5,000 words that I need sort by the number of letters in the word for my students is this possible to do? The words range from 1 letter to 9...

If I have the date of birth, how do I calulate the age of a person? Thanks Doug

Hi, I have a userform containing various VBA controls such as comboboxes, listboxes and check boxes. I want to provide the option for a user to clear the...