Search results for query: *

I have the following info on a sheet. “Program” is in cell A1. Program Number Name Date Job Hours 1 1100 steve 1/1/04 158654 6 1 1471 frank 1/1/04 189 6 1 1596 tom 1/4/04 186 6 4 1400 elroy 1/4/04 181 4 4 1500 wilma 1/5/04 181 6 I want to move the individuals in program #4 (Elroy and Wilma)...

I have installed NT 4 (twice now) on a reformatted hard drive. I tested the drive during the reformatting with the “Scandisk/All/Surface” command. It came up clean with no problems. I have installed service pack 5. I tested the system to make sure that everything was working (especially the...

I am having trouble getting a mouse to work on a Gateway, 75 MHZ PC with Win98. There is no USB. I have tried two different mice and have even switched the plugs b/w the keyboard and the mice. When the PC is booting and in the DOS like screen (black and white) I see the message telling me that...

Hello, I have a copy of Linux 2.3 on CD. I have never used or even seen Linux in use so I have a few questions: Will the MS office suite work with this? Will the Opera or Mozilla browsers work? Should I obtain a newer version of Linux or can I install the 2.3 and then download an upgrade...

'In the Prop1Invoice folder I have the Prop1Invoice workbook that has three invoice sheets that are copied to the Propxfer workbook. But right before they are copied, a "File Not Found" dialog box appears with the Prop1Invoice folder and the "propxfer" filename. When I select...

I have six command buttons on a worksheet. Three to print and three to preview. Right now they all work as desired in printing and/or previewing their respective worksheets. I am wanting to add some code to each button to open a List Box and display the files in a directory in which to print or...

How can I ignore the case of the worksheet name in the code below? If the worksheet name was entered as "clntRATE" or "ClNtRaTe" (or any other variation of upper and/or lower case), the code below doesn't recognize the variations. It only recognizes "CLNTrate" For...

I am trying to assign a macro to a command button that I have added to a worksheet. I open the Toolbox, click on the Command Button icon, then click on my worksheet to create the button. But when I right click the button to assign the macro, I do not get the choice of “Assign Macro”. I have a...

The seemingly simple stuff drives me crazy! The user clicks a button “Process Data”. An input box opens and gives the user 3 choices: 1)Enter month and year to process data 2) click OK to view the raw data without processing or 3) click CANCEL and close the activeworkbook without viewing or...

I am wanting to do some previewing and printing with Macros assigned to six command buttons on a worksheet. Three for previewing and three for printing. I want to preview and/or print “Invoices and Detail” (which is everything), “Invoices Only” and “Detail Only”. I have the following worksheets...

In a previous post, I did not do a very good job of explaining my situation or including good data. Below is some data on a worksheet (“propnova”) that needs to be filtered. This is a very abbreviated table of info. My actual table has over 200 records to filter. Branch Fund Number Name 1...

I have a worksheet (“Branch 3”) with the following abbreviated info. I want to filter on the “Fund” column. Branch Fund Number Name 3 1 1000 Bob 3 1 1111 Steve 3 1 1200 Dennis 3 4 2000 Jason 3 4 2222 Mark 3 4 2333 Curtis With the following code I filter as desired, and then copy and...

I have the following code: Sub OpenReportMonthWorkbook() Workbooks.Open Filename:="Prop1-" & ReportMonth & ".xls" ActiveWorkbook.LinkSources (xlOLELinks) With ActiveWorkbook .UpdateLink .LinkSources = True End With Sheets("InvoicePage2").Select End Sub It...

I looked thru past posts and did not find anything to match my questions below. I have a procedure that uses info from different workbooks. I want to check if a particular workbook is opened or not. If not, then open it. If it is already open, do not open it again or tell me that it is already...

I have the following procedures that make up one big procedure to print labels: Sub HelensLabelsAll() SelectDate EmployeeCostCenterNumberParsing SortCCandName InsertBlankRow MoveCCNumber InsertDate ThreeColumns Insert2ndBlankRow AdjustCellWidth LeftJustify RenameLabelSheet End Sub The...

I have the following info in my Clntrate table: (the actual table has about 300 people listed) Number Name Rate 1000 Bob 2.50 1250 Steve 1.25 1500 Mike 3.00 1569 Frank 4.50 I am wanting to select and move some of this info over to 3 different hours and pay sheets. I have the following code...

I created a pivot table by recording the macro. I did not stop to think that the next month’s data would not be of the same range size. 'the following is part of the original code produced by the recorded macro: ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= "'Branch...

I am trying to get the following procedure to read a row of information, find the cells in the row that are NOT empty (they will have a number in them) and then shift one column to the right and insert an “L” or an “H” (two separate procedures at this point) in the empty column to the right...

The brief worksheet looks like: A B C D E F 1 name job 05-01-03 5-02-03 2 Bob 186 6.0 6.0 3 Steve 188 6.0 4 Mike 189 6.0 Row 1 is my headings: 2 on down is the employee name, job # and hours. Columns D and F are the empty cells to place an L and H into. In the procedure below...

If I have cells in a spreadsheet that are formatted bold or with a specific font, how do I get this formatting to carry over into a Pivot table? I keep losing the formatting when the PT is created. TIA Bill