Hi All, I have a List in which in a B Colum i want to sum if it have "Total" in A Column what should i do

Hi Every One, I hope you all are doing well, I required your help to resolve my issue in excel. On single worksheet i have two different sheet name as 1.IP...

i am just trying to figure it all out and cant seem to get it to do it properly so i was hoping someone already worked out all the bugs and have a template

I have two columns of dollar amounts I want to add, E & F,and subtract the third, G, and the results in column H. So I entered the formula =Sum(E2+F2-G2)...

I have built a worksheet in Excel to print ID cards using data in another worksheet exported from an accounting program. The field for the first name is...

when i save a file as html it can not be filled in is there a way to save it as html and also be able to fill it in?

Need some help on a basic question. I have a list of constantly growing data & I would like the last entered value in this list to copied to a fixed cell. EG,...

Hi, Basic Formula in A1 says: B1*C1. This works. I have all cells formatted to Number Format with 0 decimal place(s). I also have the 1000 separator...

After using macro recording for a single insertion of a row, the recording showed this: Rows("50:50") followed by in inser command, my question is How do I...

I am trying to format a textbox and I'm using to following code: Private Sub TextBox1_Change TextBox1.Value = Format (TextBox1.Value, "###0") End Sub But...

Hi, I am using Office 2K7 and facing a problem in splitting the text into different columns. I have lastnames and firstnames together in a cell and there is...

I want to have a excel workbook open up everytime on a particular sheet. This is irrespective of which sheet i had last accessed and saved the file. However,...

Hi. I have a column that contain numbers (either + or -). I want to find the last cell that contains a -ve value and return the corresponding date from the...

Ok - so we started at my company with 2003, and I created a site to report numbers for sales on our intranet sharepoint, and everything was great! Now, with...

Several people in our company recently started to use MACs. They cannot open ..xlsx files we have created in Excel 2007. Does anyone know what the solution...

Hi all Can You Help I have a work book called" Best Dress on League" On Sheet called" League information" I have in Column A Date Column B Venue Column C...

In the "old days" you used to be able to type a number into Excel as 11301967 and then use the Format Cells command to have it formatted as a date, such as...

I have drop downs on some cells - i have the code below that is meant to color the drop down cell once set by the user - which i does. However, I want to be...

Hi all I update my Mail add-in and VBA code examples to avoid the error if you use Windows Live Mail as your default mail program. More information in the...