Lookup from External Reference File

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

Guest

I have a file I use for reference in generating the headings for my excel
reports. The reference file is currently in excel, but it as easily be in
Access. The data contains the project number (used for lookup), description,
etc.
I create several report workbooks for a given project, several of which
contain multiple sheets. I would like to be able to use the reference file to
insert several pieces of project info into the individual reports.
I have searched the threads and cannot find anything that works.
This ROOKIE needs some direction.
Thanks
 
worksheets("Report1").Range("B9").Value =
Worksheets("ProjectInfo").Range("F11").value
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Does M.S. Project have to be installed in order to use the ProjectObject Reference within Excel to g 3
object library problem 2
Setting up Solver reference in a protected VBA project 1
Pull data (sumif?) from an external workbook 1
Reference Personal.xlsb in other projects... 4
Looking for some help launching files from COde & Ribbon control 0
Email From spreadsheet 2
excel and reqular expressions; what????? 1

Back
Top