I am trying to filter a worksheet using a Macro that contain a variable value (PR). When I run the Macro I can get the Auto Filter command to returm the...

A little help please: I have an order date 20030110 and a ship date 20030405. What is the formula for calculating? Thanks for your help.It is very much...

Good afternoon all, I'm great with Excel, but not so hot on doing much VB... What i'd like to do is have the Form window open automatically upon workbook...

Does anyone have a solution to this request; The sumif function will sum values in a column where a criteria is met in another defined column. This is...

I'm currently using numberformat extensively in an Excel 2002 spreadsheet that will be used worldwide. Half of my users, though, run Excel 2000 and the...

Good afternoon all, I'm great with Excel, but not so hot on doing much VB... What i'd like to do is have the Form window open automatically upon workbook...

Hi: I have a row of column labels on row 4 and I'd like to be able to program a macro that sorts based on the column labels. I have a row labeled "other" on...

I have created a workbook with a worksheet for each month of the year. In each worksheet I have created a table representing that month with the days of the...

Scottie, I tried to send an Excel file to your email, but it was returned. Here are the statements Column Headers: Column A --- Company Name Column B ---...

HAD MORE TIME TO FINISH THE REST OF THE ANSWER.. CELL D2 =IF(DAYS360($B2,$I$1)30,+$C2,0) CELL E2...

SCOTT, SENT INFORMATION TO YOUR EMAIL ADDRESS - AS SCOTTS AGING SCHEDULE. IF YOU HAVE BEEN HELPED, PASS ON SOME HELP TO SOMEONE ELSE. HAVE FUN.

Using Excel 2000 and cell A1 containing the number 7,418,212, what is the formula in B1 that will return 7,418,000 in B2? Or with 7,418,545 in A1, it would...

I'm following Microsoft's directions (http://support.microsoft.com/default.aspx?scid=kb;en- us;211693&Product=xlw2K) about creating links on Web pages to...

I need to count the number of durations 1. Less than 1 hour 2. Between 1 & 2 hours etc. HELP!

B8 = YOUR TARGET TOTAL C8 =IF(SUM(C4:C7)=B8,0,IF(SUM(C4:C7)B8,B8-SUM(C4:C7),IF (SUM(C4:C7)B8,B8-SUM(C4:C7),"WRONG"))) SURE THERE IS PROBABLY AN EASIER...

Hi All, I posted this in the programming section and didn't get a response. I assume that I was in the wrong section so I'll repeat it for help here. I have...

I have developed an Excel document and I want to print it with the grid lines showing. I have gone into page setup and clicked on the box for "print grid...

Hello again! This is my last visit to the newsgroup today.. hopefully. When assigning Data Validation to a cell and then designating a list to validate from...

When I use the tab key to move from left to right, if I hit enter afterwards it assumes that I'm entering a list of data and goes immediately to the first...

can u format a cell in a worksheet to accept text? for example, input multiple comments that will be hidden from view .... and then click on that cell to open...