In yopur system's control panel (I can't be more specific as I do not know your operating system type) there is a regional settings applet that defines the...

I have a formula =IF(L5="YES",SUM(I5),"") I want to be able to look at all the cells in column L for "YES" and if found, SUM all the corresponding cells in I....

I would like to transfer data from my checkbook ledger worksheet to 4 different accounting worksheets without having to hand enter everything individually. Is...

I am trying to print comments that I have made (print preview, set-up, sheet, comments); but this area is grayed out and will not let me select an option to...

please help me .I am ata great loss I know nothing about computers let alone how to make elcel work for me. I need to make a sheet that will show a running...

Hi group, What I would like to do is create a tools/parts list from a workbook that contains 8 different sheets of inventory. What I have is an inventory of...

Hello, I have the following formula (I apologize for its length)...

Has anyone ever gotten this message? I have a large spreadsheet. I keep adding more info and change a format like maybe text color and this message pops up,...

I need a formula to show the average number of unit sales made in a month based on the number of days in that month in which items were sold. For example, if...

Crossposted to Misc, Programming and Functions ... Name Manager Version 3 Beta, developed by myself and Jan Karel Pieterse, with Mac localisation by Matthew...

I have three separate columns, which make up one full part number. I need to combine these columns in a way that allows me to cut and paste the result to a...

Hi Definitely possible and definitely macro work. But how can a macro recognize your "row 1", "row 2" and "row 3" of data ? Blank row between ? Start on...

What is the exact code to use the Vlookup function in a visual basics custom macro? I need to be able to use this in a loop that will have at least 2 index...

You should use copy-paste and then clear up the original position, instead of cut Hope it helps!;) --- Message posted from http://www.ExcelForum.com/

For a line that has been copied into Excel with two end of line characters, what is the code in VB for excel to parse the line and enter it into 2 columns. ...

Hi there, I have a spreadsheet that has my call centre's master stats on one worksheet. There are also seperate worksheets for each employee. I need to link...

Try this, In a separate new column (column D) insert the...

Ummm, I'm a bit lost now. I just hope I've got this in the correct newsgroup. Ok, here goes. I'm trying to write a program using some information a friend...

Is there a modified pmt formula that will take into account fixed fees (that do not accrue interest but is paid off first before principal & interest) as part...

Is there any way to set a cell to 0 if any error(eg DIV/0 or VALUE) occurs? --- Message posted from http://www.ExcelForum.com/