Recent content by genuineblonde

I have table organized as below: Plant Product Jan-05 Feb-05 Mar-05 ..... GA a 10 12 3 GA b 19 5 63 SC a 20 38 25 How do I get the data normalized? I know how to do for one variable, but not two?

Could it be that you have the first line identified to repeat in the Page Setup?

I am trying to import a Notes View into Excel using Microsoft Query. The Query work, but the numeric and date field come in a text. I need to be able to use in calculation. Since someone else will be using the data, I am hoping to get the data corrected coming in. The is a file that will be...

The data is stored in a Notes database, I am using Microsoft query to download the data into a spreadsheet. However, the data has to be converted because it all comes in as text rather than numeric. The SQL statements are generated when I create the query, so I haven't stored the data anywhere.

I am a major newbie...so please be gentle. I have the following select statements. SELECT Download_Schedule.Machine, Download_Schedule.EndDateTime, Download_Schedule.ordnumber, Download_Schedule.customer, Download_Schedule.Qty, Download_Schedule.brand, Download_Schedule.BagSpecNo...

On a chart, I have linked to a worksheet cell in a text box. Can I {how} change the alignment,font of the resulting text in box?

I was trying to avoid having to lock the form. The user needs to be able to insert and delete rows in the table.

How can automatically format an entry into a Word table to the currency format? Example: Enter 6957.11 Desired Display Result $6,957.11

Hi, I appreciate your help...however I am getting the following when I try to run the macro (2nd option). Runtime error '1004' Unable to set the pagebreak property of the range class. The range I am breaking on is a person name.

I have a worksheet with several columns of data, sorted by column A. Is there a way to insert a page break automatically whenever the value changes in column A?

I have a protected Excel Worksheet...how can a user's spell check?

I am new to using Project Central. How do I enable my resources to change the start, finish or duration time for a task?

I want to calculate the newworkingdays between two dates. If the answer is 1, then format the ## day otherwise format the cell ## days. I am using Excel 2002. Any help is appreciated.

Can anyone help me with a formula to calculate elasped work time? The time is for a group working a five day schedule Monday to Friday, Hours 8:00 AM To 5:00 PM. The data is currently arranged with the start date in one cell and start time in a second cell, but they can be combined. The...

It needs to fully automated. Thanks for the suggestion on the Autofilter, but it needs to be a separate list in another area of the worksheet.