want to link specific records in access to cells in excel

J

Jason McKenney

I have a database of client information that I would like to export into
excel spreadsheets for different purposes, ie; I need to track utilization of
service, create transportation schedules, and track service plan dates in
seperate workbooks. So, what I am hoping I could do is link a group of
records (LName, FName, ID and Available Hours) to a section of the
predesigned worksheet limited by the entry in another record related to the
entry (Service Type). Basically running an if/then fuction based on
information from the access records (if record "x" equals "PRG" then enter
records "a,b,c" into cell "b4,b5,b6"...is this even possible????
 

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

Adding records to a table 18
Populate cells in an excel spreadsheet with information from an access database 1
Deleting information in a field for a group of records 2
How to extract duplicate records from 4 spreadsheets into a separate spreedsheet? 2
HELP A NEWBIE - EXCEL TO ACCESS 5
Exporting Certain Records to Excel 3
Appending records to a table from an Excel file 16
INSERT to excel file 4

Top