help w/ fine tuning

MS EXCEL

    Sponsored Links

    Next

  • 1. Conditional Question
    Hi -- is it possible to do conditional formatting that would highlight the first time a customer hits $1,000,000 or above and then in another column look for those highlighted and place the year and qtr that happened I have a pivot table that looks like this column A Column B Column C Column D etc.... (2000-1 thru 2010-1) Customer 2006-1 2006-2 2006-3 Customer A $1,000,500 $2,000,000 Customer B $1,000,000 $3,000,000 So I would want to highlight Customer A the amt in 2006-2 and then create a column in my spreadsheet that states 2006-2 Customer B highlight the amt in 2006-1 and in another column state 2006-1 Can anyone help? Thank you!!!
  • 2. How do i generate a bill from an inventory list?
    Hi everyone, I have an invoice as one sheet and an inventory list as another sheet in the same workbook. I would like to be able to select items from the inventory list and have that info. (about 3 columns from 8) sent directly to the invoice in order to generate a bill, however, the items are not necessarily consecutive in the list. Is there a way to do this? Thanks for any help!!
  • 3. How can I show/hide the cell comment blocks ?
    How can I show/hide cell comment baloon boxes ?

help w/ fine tuning

Postby Mike » Fri, 21 Oct 2005 04:33:45 GMT

here is what i have done so far. what i need to do is enter by tech. and
have a full summary of totals. we need individual totals and cumulative
total to track individual and office productivity.

TIA
Mike





Re: help w/ fine tuning

Postby flyfishonly » Fri, 21 Oct 2005 04:58:11 GMT




My attachment didnt go thru

Job#   Customer    Price  Tech. Reg hrs   OT Hrs
1        jim        $200   Mike    5.8      1


Total:       Invoiced:
             Billable Hrs:
             billed / total hrs. available(%)


Similar Threads:

1.Help fine tuning delete macro

I'm trying to use this mcaro to delete rowsa based on the value of Column B 
and it isn't working

Sub DeleteCM()
 lastrow = Cells(Rows.Count, "B").End(xlUp).Row

    Set myrange = Range("B2:B" & lastrow)
    For Each Count In myrange
    If Count.Value = "CM" Then
    Count.EntireRow.Delete
    End If
    Next
 End Sub

Any help would be appreciated.

BTW there are 2 other values I want to delete the rows if they exist "IC" 
and "MG".  Do I need 3 separate macros?

2.Excel to XML: Need some help fine tuning a macro

3.Possible Fine Tuning

4.Fine tune scroll amount

Is there a native setting in Windows/Office/Excel 2000 that specifies
the number of rows to scroll with each wheel click?  Right now, it
scrolls more than one row.  Each row can be very tall.

Can this behaviour be restricted to Excel?  I still want to reduce the
amount of scrolling for any other application.

5.Fine tune the counting area by setting up parameters

6. Want to fine tune VLOOKUP formula given last week

7. Fine Tuning

8. Fine-tuning selection change event for merged cells & wrap text



Return to MS EXCEL

 

Who is online

Users browsing this forum: No registered users and 37 guest