PDA

View Full Version : open workbook



rjw29bs4
11-30-2018, 03:11 AM
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

Logit
11-30-2018, 07:24 AM
.
VLOOKUP the value in the clicked cell containing the invoice number.