Results 1 to 5 of 5
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Macro (Excel2000)

    Could you attach a small sample workbook so that we have something to work on?

  2. #2
    New Lounger
    Join Date
    Aug 2006
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Macro (Excel2000)

    Dear Experts,

    I have a workbook called
    Attached Files Attached Files

  3. #3
    New Lounger
    Join Date
    Aug 2006
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro (Excel2000)

    Sorry Hans I attached the file to the original post. Here it is again

    Cheers

    aussiehans
    Attached Files Attached Files

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Macro (Excel2000)

    See the attached version. It uses Advanced Filter to copy data to the Service Due sheet. The range K3:K5 is used as criteria range, and cell M4 contains the value entered by the user.
    I added field names (column headings) to the Service Due sheet because Advanced Filter requires them.
    Attached Files Attached Files

  5. #5
    New Lounger
    Join Date
    Aug 2006
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro (Excel2000)

    Hans

    This works great. Thank you very much

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •