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 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...

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 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...

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...

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,...

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...

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

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...

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,...

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

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...

=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...

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

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...

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 am fairly new at using Excel - I am attempting to create a spreadsheet that includes vehicle information.... the Vehicle Title Numbers are seventeen digits -...

I have written a macro that takes me from the worksheet where I am entering information regarding an event to a worksheet that has a drawings of various table...

HOW DO I USE WATER MARK " DRAFT" IN EXEL