Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    14
    Views
    501

    Hi fjohan The 'second' record in your original...

    Hi fjohan

    The 'second' record in your original uploaded file is not exactly the same format as the first record section (the second one has a different number of rows).
    Does the number of rows...
  2. Replies
    5
    Views
    88

    Hi KZ If you have tracking changes turned ON...

    Hi KZ

    If you have tracking changes turned ON (as Paul T mentions in post#2), this can cause considerable bloating with shared workbooks.

    If this is the case, you can 'clear' this by re-setting...
  3. Replies
    14
    Views
    501

    Hi fjohan It would be great if you could post...

    Hi fjohan

    It would be great if you could post another example .txt file, just to make sure the format is consistent.
    I want to test another solution, but would like another example.

    zeddy
  4. Replies
    14
    Views
    501

    Hi Maud A stunning piece of work that deserves...

    Hi Maud

    A stunning piece of work that deserves a proper thank you.
    ...I formatted the date cells [M2], [AM2], and [BC2], a very minor change.

    zeddy
  5. Replies
    4
    Views
    221

    Hi Grant Couldn't have done this without your...

    Hi Grant

    Couldn't have done this without your example file!

    In the attached file, I have added a custom Function named foodCount.
    On you sheet [Registration Sheet orig] in row 112 of your...
  6. Replies
    12
    Views
    330

    Slaven ..using your file as example, if you...

    Slaven

    ..using your file as example, if you require the total% of the three values in columns B, C and D to be exactly 100.00%, then perhaps the best 'solution' is to force the result to be...
  7. Replies
    14
    Views
    501

    If I had a file like that I would go back to the...

    If I had a file like that I would go back to the source that produced the txt file and see whether it had an option to 'export' it into a different format (like a spreadsheet)

    zeddy
  8. Replies
    15
    Views
    742

    Hi RG ..you could use N(C5)>0 instead of.....

    Hi RG

    ..you could use
    N(C5)>0
    instead of..
    SUM(C5)>0

    So N(C5)>0 could replace AND(ISNUMBER(C5),C5>0)

    zeddy
  9. Replies
    15
    Views
    742

    zeddy

    zeddy
  10. Replies
    15
    Views
    742

    Hi fred I don't think using a custom...

    Hi fred

    I don't think using a custom validation formula is the right approach for what you are doing.
    But, nevertheless, to give you what you ask for, see attached file.

    This allows you to...
  11. Replies
    15
    Views
    742

    Hi RG ..if you put "banana" in cell $C$5 and...

    Hi RG

    ..if you put "banana" in cell $C$5 and then, in another cell, put the formula =$C$5>0 then this formula will give a result of True. So the (OR($C$5="out",$C$5>0)) will also give True
    ...
  12. Replies
    4
    Views
    221

    Hi ..it is much easier and quicker for us to...

    Hi

    ..it is much easier and quicker for us to help if you attach a sample spreadsheet.


    zeddy
  13. Replies
    10
    Views
    220

    Hi Maud Good spot. So, if you want to keep...

    Hi Maud

    Good spot.
    So, if you want to keep the same alignments, and move them as a group, use the single line of code.
    If your checkboxes are not lined up, and you want them to be lined up, use...
  14. Replies
    10
    Views
    220

    Hi Maud ..or just use ...

    Hi Maud

    ..or just use


    ActiveSheet.CheckBoxes.Left = 0


    ..that way it doesn't matter if the check box numbers are out of sequence, or how many there are.
  15. Replies
    11
    Views
    190

    Hi RG Many thanks. Me, I'm learning too. When...

    Hi RG

    Many thanks. Me, I'm learning too.
    When I was young I could remember everything, whether it happened or not.

    zeddy
  16. Replies
    6
    Views
    125

    Hi RG Is there a code for strikethrough? :D ...

    Hi RG

    Is there a code for strikethrough?
    :D

    zeddy
  17. Replies
    8
    Views
    184

    Hi nate.. What you say is true. But if you...

    Hi nate..

    What you say is true. But if you have a carefully defined checklist of what the software is required to do, and it then passes that checklist, you have delivered 'what was asked for'....
  18. Hi Skipro So, when you overwrite the F value...

    Hi Skipro

    So, when you overwrite the F value of 'no entry', say with $10, you then have this situation:
    C = 0
    D= 0.00%
    F= $20
    G = 25.00% (or some other previous value)
    We have F=(C/D)*G
    so.....
  19. Hi Skipro oops. how did I miss that??? Must've...

    Hi Skipro

    oops. how did I miss that??? Must've been some kind of lapse.
    Of course, it should have been &.
    Trying to post back too quickly!

    Yes, you can test for row > 22 etc for specific...
  20. Replies
    11
    Views
    190

    Hi Verada/RG Here's another way, just to show...

    Hi Verada/RG

    Here's another way, just to show another method:
    I have set it up so that the User can only enter data in the 'next' available row.
    If they click on any cell, the cellpointer will...
  21. Replies
    6
    Views
    127

    or in cell O2 =INDEX(L:L,MATCH(N2,I:I,0)) ...

    or in cell O2 =INDEX(L:L,MATCH(N2,I:I,0))

    ..and if you get a #N/A, then your names aren't the same, i.e. have spaces

    zeddy
  22. Replies
    6
    Views
    127

    Hi Try making sure that what you are looking...

    Hi

    Try making sure that what you are looking up actually matches exactly the item in the range.
    If you have trailing spaces in the names, this can cause the problem.

    zeddy
  23. Hi Skipro Instead of =LEFT(Ax,FIND("...

    Hi Skipro

    Instead of
    =LEFT(Ax,FIND(" ",Ax)-1)
    I would prefer..
    =TRIM(LEFT(Ax,2)
    ..because this doesn't require us to use double quotes when building the formula in VBA.
    (You can build...
  24. Hi Skipro In this version: 1. You can change...

    Hi Skipro

    In this version:
    1. You can change the entries in range [A4:A9]
    >example, change [A5] from B to W; now change [A5] from W to D, then change from D to B
    >example, put K into cell [A8]...
  25. Hi Skipro ..I'll have the updated file posted...

    Hi Skipro

    ..I'll have the updated file posted here tomorrow.

    zeddy
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4