Search:

Type: Posts; User: johndrew; Keyword(s):

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Macro to insert Row if the cell value changes

    I am barcoding items. As I click the scanner gun, the item goes in to Sheet 1, Column A. Like a1,a2, a3 etc.
    I do the mid function to separate the barcode values into columns on Sheet2.. Like A1...
  2. Re: #REF! in Pivot Table when Input Data is Deleted and Refreshed PT

    =+GETPIVOTDATA("Amt",$F$10,"TYPE"," Check")
    =+GETPIVOTDATA("Amt",$F$10,"TYPE"," Currency")
    =+GETPIVOTDATA("Amt",$F$10,"TYPE","Coins")
  3. Re: #REF! in Pivot Table when Input Data is Deleted and Refreshed PT

    Name Type Fund Amount
    Tom Check Tithe $11.00
    Bill Currency Missions $22.00
    Henry Coins Missions $33.00
    Sam Check Building $44.00 ...
  4. #REF! in Pivot Table when Input Data is Deleted and Refreshed PT

    I have a macro delete the data information and refresh the Pivot Table, I get #Ref!

    I am using a macro to delete the data and refresh and using Excel10

    It happens when I don't use all the...
  5. Text to Speech for Range with value greater than 0

    I have data in Columns B,C and D
    I would like to have it read the numbers back so I can check the accuracy of my entries
    It should continue "reading" the numbers in Columns B, C and D until it...
  6. Replies
    0
    Views
    109

    Post Cell Values to Comments to verify

    I am wanting to verity the data entered.
    I have a conditional format to check the data and highlight in red if it does not equal
    What I would like to have is the first input listed as a comment in...
  7. Replies
    3
    Views
    256

    Re: Copy Area and Post as Image

    Thanks, the Camera Tool did what I needed.
  8. Replies
    3
    Views
    256

    Copy Area and Post as Image

    I have a conversion chart of decimals to fractions I made in Excel.
    I want to copy and paste as an image so I can shrink it to fit at the top with the frozen
    headings.

    I tried to take a picture...
  9. Replies
    1
    Views
    119

    Speak Fractions

    I am wanting to have a macro start on C2 read and speak, then go to D2 read and speak, then E2
    and read and speak the value in the cell in Columns D and E are in fractions. Then next row
    For...
  10. Re: Don't print colors but show colors on screen

    Found it in setup, use Black and White
  11. Don't print colors but show colors on screen

    I am wanting not to print the colors on my spreadsheet. I have 4 colors.
  12. Replies
    0
    Views
    327

    Freeze Values from Active X combo Box

    I am using an Active X Combo Box to enter data. When the selection it does a Vertical Lookup and gets the price value of the Item. (note there are two Active X boxes with the second being for another...
  13. Re: Find the last used cell by starting from the top and going down.

    What I need is to find the last used row
    Add another Row
    Draw a Line on top of this new row
    Sum Columns B,C, D
    Name the Last Cell in Column D as Grand Total
    Put Grand Total In Cell D1 ( I...
  14. Find the last used cell by starting from the top and going down.

    Fellows I need to find the last used row by starting in B1 and going down.
  15. Replies
    6
    Views
    243

    Re: Go To Combo Box with a Macro

    Got it. Unlocked the cells where the Combo box was putting the input thus allowing the Combo Box to work.

    Thanks
  16. Replies
    6
    Views
    243

    Re: Go To Combo Box with a Macro

    Yes
    or unlock it when the sheet is locked for data input
  17. Set Print Range Starting with second last used cell

    I have 100 rows with a total at row 101.
    when I use LastRow = .Range("c" & .Rows.Count).End(xlUp).Row
    it stops at row 101 because of the totals. I need to start at C100 then find the last used...
  18. Replies
    6
    Views
    243

    Go To Combo Box with a Macro

    I have a combo box in cell "M5" Is it possible to go to the Combo box with a Macro
  19. Re: Have to Click twice on Combo Box for it to Enter

    Thanks
  20. Replies
    8
    Views
    184

    Re: Add additiona1 $. 0 to Concatenate value

    Thanks Weazel, that's just what I needed. Cheers
  21. Have to Click twice on Combo Box for it to Enter

    I have a combo box and when I select a item it turns the selection Blue and I have to click again to get it to enter.
    How can I get it to enter with one click?
  22. Replies
    8
    Views
    184

    Add additiona1 $. 0 to Concatenate value

    I have the following formula in "A1":

    ="$"&ROUND(G3,2)& " per sq ft"

    In G3, I have $7.00 or $7.10

    The problem is I get $7 or if I have $7.10 is drops the zero and shows $7.1


    What I want...
  23. Re: Draw Borders around a Row to Last Colulmn used

    I just need borders around the one row (row2) It now goes up and gets b1 and draws borders around the entire range.
  24. Draw Borders around a Row to Last Colulmn used

    I would like to draw a Bold border around a Range from B2 to the last column used.
    Also around the last Column down till the last row used.
  25. How to Insert last use Column in a Range

    I ran a macro which found the last use Column. Which was 10
    I want a Print Range from "E2" to "E" Last Column which was 10. The name was LastCol

    How do I write that VBA range E2:E10
Results 1 to 25 of 102
Page 1 of 5 1 2 3 4