linking sheets that would correspond to one sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set up a sheet that has check marks with items which I can use in another sheet with more detail of the description to send out estimates that are repetative. So I will like to do is click on the item and it will show up with the full details on the other sheet which would be a proposal or estimate
 
You could type an x in the row that you want to print, and use VLOOKUP
formulas in the Estimate form to print the details for that item.

I just added a sample to my web site:

http://www.contextures.com/excelfiles.html#Function

Under Functions, look for 'Invoice for Marked Item' and download the
VLookuplInvMark.xls file. It contains a macro that clears old "x" marks
from the column, but you can disable the macros and clear the marks
yourself, if you prefer.
 
Back
Top