Search:

Type: Posts; User: dguillett@gmail.com; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.00 seconds.

  1. Replies
    4
    Views
    70

    [SOLVED] i have no experience with that app & do not...

    i have no experience with that app & do not intend to buy it which I am prompted to do when trying it. Appears to be a conflict with your thisworkbook sh change macro. Why pay when free ways. Check...
  2. When you say you need to match what do you do...

    When you say you need to match what do you do when you match. Do you keep the data or if it cancels out to 0, delete all pertinent entries.
    row 2 -34.56
    row 22 +10
    row 42 +24.56
    or ??

    Daily...
  3. Something wrong with the file.

    Something wrong with the file.
  4. Replies
    4
    Views
    70

    [SOLVED] If you are talking about the top macro button to...

    If you are talking about the top macro button to printout the sheet then this does it. You also need to make your sheet 1 page tall so you don't print 2 sheets. And, a further look indicates that you...
  5. I can suggest TRIM and then test with LEN >0

    I can suggest TRIM and then test with LEN >0
  6. [SOLVED] supply a file with before/after examples

    supply a file with before/after examples
  7. [SOLVED] If?? you are saying you want to sum .0001,...

    If?? you are saying you want to sum .0001, .01,.099, etc then try AND
    =and(>0,<=1)
  8. You should always provide an example of what you...

    You should always provide an example of what you want
    By which column(s) do you want to match for the debit/credit
    Several ways to do this.
  9. Although I might do it differently here is the...

    Although I might do it differently here is the combined code you need

    Private Sub Workbook_BeforePrint(Cancel As Boolean)
    With Range(Cells(Rows.Count, 1).End(xlUp)(2, 1), Cells(18,...
  10. Replies
    2
    Views
    77

    Are you saying that the 1st set is in rows and...

    Are you saying that the 1st set is in rows and you want it in columns as shown in 2nd set?
    Attach file.
  11. Sub bordersaround() With Selection.Borders ...

    Sub bordersaround()
    With Selection.Borders
    .LineStyle = xlContinuous
    .Weight = xlThick
    End With
    End Sub
  12. Replies
    5
    Views
    155

    I have NO knowledge of excel for apple but in...

    I have NO knowledge of excel for apple but in regular excel you could use a worksheet event such as select, double click, right click, etc. to mark a cell.
  13. Replies
    5
    Views
    333

    To repeat what I said, if this is all the data...

    To repeat what I said, if this is all the data you anticipate for each then simply use ONE sheet & add a column to identify and then use AUTOFILTER. MUCH BETTER. Same with your files feeding it....
  14. Replies
    5
    Views
    333

    Depending on your volume, you may?? be creating a...

    Depending on your volume, you may?? be creating a lot of extra and unnecessary and undesirable work. You have 22 or so working days in each month. How many entries for each day_______? What goes on...
  15. This should explain...

    This should explain
    http://superuser.com/questions/450014/clearmytracksbyprocess-all-options
  16. [SOLVED] A possible????? You have windows 64 bit and excel...

    A possible????? You have windows 64 bit and excel 32 bit. I have heard others like me say that you should NOT install excel 32 bit in the 64 bit. If so, try uninstall and re-install in 32 bit.
    This...
  17. Try tablerange2 ...

    Try tablerange2

    ttp://www.globaliconnect.com/excel/index.php?option=com_content&view=article&id=154:referencing-an-excel-pivot-table-range-using-vba&catid=79&Itemid=475
  18. Replies
    5
    Views
    123

    Best to import your data to this sheet. However,...

    Best to import your data to this sheet. However, IF you want to use elsewhere you need to make sure that range(i1:j4) remain as they are without ANYthing in the blank cells on row 1 or 3. If not i1...
  19. Replies
    5
    Views
    123

    Try attached to see if if works in xl2000

    Try attached to see if if works in xl2000
  20. Look here under D for data validation...

    Look here under D for data validation
    http://www.contextures.com/tiptech.html
  21. I am commissioned to do a lot of external queries...

    I am commissioned to do a lot of external queries (mostly stock market) related but I don't see how I can be of help unless I see and test the actual file or at least an actual url
  22. First you send a file that doesn't pertain and...

    First you send a file that doesn't pertain and then one I can't open
  23. Replies
    5
    Views
    123

    You should always supply your excel version. It...

    You should always supply your excel version.
    It appears that you no longer need the formula so you should use a macro to supply the text and color based on your criteria for that text. Supply...
  24. You should NOT ask a different question in the...

    You should NOT ask a different question in the tread of the 1st question. Anyway, I have attached a file for your question about copying data from one sheet to 2 based on criteria. It uses findnext....
  25. You don't mention your excel version nor the type...

    You don't mention your excel version nor the type of web query. Can you provide a file or dummy file with code to look at. It probably can be streamlined.
Results 1 to 25 of 64
Page 1 of 3 1 2 3