Moving Data Extracted from a Query into separate worksheets

R

Robin

I have extracted some data from an SQL Database by a
simple query.
The data contains two sections I want to be able to move
about in excel.
1) An ID of a person
2) A Date / Time (But I only want to use the date)

There will be a separate worksheet for each month of the
year with a separate column for each date and a separate
row for each person's ID.

I want Excel to be able to fill in a colour agaist the
date / ID if it the date is present from the orignal
query. Is this is at all possible / what formula should
I be using?
Thanks
Robin
 

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

Space at end of multi page list to accommodate new entries 1
Creating a Chart on form from selected data in query. 0
Extracting data from database into separate sheets 0
Carry over YTD balance to next worksheet 4
Assignment Unique ID Different in Extract Map 0
Adding data to MS Access from csv file 0
Publisher is filling blank lines with data 2
VBA - exporting serial letters to single documents 0

Top