Consulting

Results 1 to 2 of 2

Thread: Solved: Match & Fill

  1. #1
    VBAX Mentor
    Joined
    Sep 2004
    Posts
    431
    Location

    Solved: Match & Fill

    Bonjour,
    The project is the following:
    Customer calls the call centre to discuss his/her account.
    When agent brings up his "profile" the missing services the company can offer are filled in yellow.
    Only the services not already billed for need to be highlighted on Sheet1
    The services are listed on Sheet 2
    The headings with the amount underneath them can be anywhere on the sheet (1)
    For this example the range of the sheet is limited to A1:H16
    Thank you
    Thank you for your help

  2. #2
    VBAX Mentor
    Joined
    Sep 2004
    Posts
    431
    Location
    On second thought I think going with conditional formats simplifies things.
    Thank you for your help

Posting Permissions

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