Consulting

Results 1 to 2 of 2

Thread: open workbook

  1. #1
    VBAX Regular
    Joined
    Aug 2016
    Posts
    12
    Location

    open workbook

    hi
    i have a folder in my documents that i keep all my invoices in created in excel they all have a invoice number
    and i also have a workbook that contains a spread sheet details of the invoices also have the invoice number on it
    i wont to be able to click on the invoice number in the spread sheet to open up the invoice in the other folder
    how would i go about this

  2. #2
    VBAX Expert Logit's Avatar
    Joined
    Sep 2016
    Posts
    613
    Location
    .
    VLOOKUP the value in the clicked cell containing the invoice number.

Posting Permissions

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