Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Hi Yav ..if you could supply say, two samples...

    Hi Yav

    ..if you could supply say, two samples of the datafiles you want to merge, then it would be much easier for us to help you with your automated processing tool. You could put 'dummy' data to...
  2. Replies
    24
    Views
    531

    Fred ..are you mad???? His wife is a...

    Fred

    ..are you mad???? His wife is a psychology teacher. We could get locked up.

    Vincenzo - please don't tell your wife about us
  3. Hi Try this. 1. Open the file as posted. 2....

    Hi

    Try this.
    1. Open the file as posted.
    2. Click on the Supplier Address Label, then select any other Supplier from the displayed Supplier list.
    3. Now re-select Ken Smith from the displayed...
  4. Hi ..if you get any glitches, let us know...

    Hi

    ..if you get any glitches, let us know here.
    We are glitcher-fixers.

    zeddy
  5. Replies
    24
    Views
    531

    Hi RG ..so in addition to the other methods...

    Hi RG

    ..so in addition to the other methods given, my attached version uses VBA advanced filter to extract the data to a specified location, and then apply a sort.
    If Topics have the same Rating...
  6. Replies
    24
    Views
    531

    Hi RG ..I accept the challenge, and will...

    Hi RG

    ..I accept the challenge, and will assemble my team tomorrow to start this project.
    I will apply for a grant from USAID, UNDP or the European Commission and expect to submit a full proposal...
  7. Thread: Delete Button

    by zeddy
    Replies
    8
    Views
    195

    Hi Maud I remember using single buttons and...

    Hi Maud

    I remember using single buttons and changing the caption text, as you suggest.
    I used 'blue buttons' and made the caption text 'white' (to indicate the button was 'ON') and caption text...
  8. Replies
    24
    Views
    531

    Hi RG I like your quotes. My favourite is...

    Hi RG



    I like your quotes. My favourite is from Paul Getty Junior (I think) who said the three secrets to a successful life are
    1. Rise early
    2. Work hard
    3. Strike oil

    ..now, it seems...
  9. Thread: Delete Button

    by zeddy
    Replies
    8
    Views
    195

    Hi Maud good point! ..but if you have lots of...

    Hi Maud

    good point!
    ..but if you have lots of 'button functions', that method can get cumbersome to keep track.
    I have often had dozens of 'buttons' on a startup sheet, and used the login User...
  10. Replies
    24
    Views
    531

    Hi RG ..but what happens if two (or more)...

    Hi RG

    ..but what happens if two (or more) topics are, say, given the same ranking????
    (I know the poster didn't ask for this)

    zeddy
  11. Thread: Delete Button

    by zeddy
    Replies
    8
    Views
    195

    Hi zmagic see attached file for another...

    Hi zmagic

    see attached file for another approach.

    By giving names to the button shapes (right-click shape to select, then type a name in the name box to the left of the formula bar etc etc),...
  12. Hi Yes, I've been away again. I looked at the...

    Hi

    Yes, I've been away again.
    I looked at the file in your post#8.

    [Weekly Supplier Report] sheet
    ..when starting a file for a new year you should manually enter a 1 in cell [H2] on sheet...
  13. Replies
    9
    Views
    191

    ..it was another thread I was thinking about. My...

    ..it was another thread I was thinking about.
    My voice-activated-automatic-typer is going a bit death and is having truffle with my accent.

    zeddy
  14. Replies
    7
    Views
    168

    Hi Mark RG offers good advice. My method...

    Hi Mark

    RG offers good advice.
    My method would use two workbooks.
    The first workbook is a small Excel 'trigger' file, that has protected code that checks the authorisation requirements.
    If it...
  15. Replies
    2
    Views
    109

    Hi You need to use your variable ws instead of...

    Hi

    You need to use your variable ws instead of ActiveSheet in your loop:

    Sub LoopThroughSheets2()
    Dim ws As Worksheet
    For Each ws In ActiveWorkbook.Worksheets

    With ws.PageSetup
    ...
  16. Replies
    9
    Views
    191

    Hi RG ..as long as 'anything else' is...

    Hi RG


    ..as long as 'anything else' is numeric.
    so I would use
    =IF(n(P1),"Corrrect","Incorrect")
    ..just in case column A had a 'fred'

    zeddy
  17. Replies
    4
    Views
    156

    Hi Howard ..the MATCH function is basically...

    Hi Howard

    ..the MATCH function is basically MATCH(what,where,how), so in..

    =INDEX(D:D,MATCH(1,($B:$B=$C$2)*($C:$C=$E2),0))
    ..the 'where' is an array of True/False i.e 1 or 0 values (formed...
  18. Hi Jaatr ..put the cellpointer in the cell...

    Hi Jaatr



    ..put the cellpointer in the cell that has a complex formula. In the formula bar, use the mouse (or whatever) to highlight some part of the formula sections, press [F9] and it will...
  19. Replies
    7
    Views
    232

    I would do a deal with the Client so that you...

    I would do a deal with the Client so that you shared any profits together.

    zeddy
  20. Replies
    4
    Views
    156

    Hi Howard ..you can't use Vlookup like that. ...

    Hi Howard

    ..you can't use Vlookup like that.

    See attached file for my solution using array version of Index/Match for two columns..

    zeddy
  21. Replies
    1
    Views
    90

    Hi see attached file Enter this formula in...

    Hi

    see attached file

    Enter this formula in adjacent cell [B1]
    =MID(A1,2,5)*1
    ..and then copy the formula down column [B]
    (if you put the cellpointer in cell [B1] you can then double-click...
  22. Hi Great job! I couldn't remember your week...

    Hi

    Great job!
    I couldn't remember your week starting on a Thursday!!

    By keeping a copy of the year 2015 data, you can make further enhancements to the tool later on, to compare shipments in...
  23. Hi ..what is your actual start date going to...

    Hi

    ..what is your actual start date going to be for Week1 for the year 2016???
    (your Week52 for year 2015 didn't end on 31-Dec-2015)
    For example, does your week1 always start on, say, a Monday??...
  24. Hi Martin RG probably knows this method, but...

    Hi Martin

    RG probably knows this method, but perhaps, like me, forgot about the good old DOS pipe method to send stuff to the clipboard.
    Here's the method:


    Sub test()

    zVar =...
  25. Hi Howard Thanks for letting me know. Just...

    Hi Howard

    Thanks for letting me know.

    Just to recap, these are the STATUS values:
    STATUS:
    kept ;file datestamp is later than chosen date
    moved ;file moved to destination folder
    moved...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4