Excel VBA Question

[hascons]

Hello,

I'm trying to create a macro takes data from an access database record-set and fill out a form using this data.

I get the record-set into excel alright I'm not sure about how to go about transferring the data over.

I've enclosed the excel spreadsheet which has 2 sheets on for receiving the record-set and one is the final form. I've manually transferred the information on the main (red Font) to show what the final form should look like.

Essentially I believe I have to loop through the record-set and move all the records that pertain to each individual to the main form and correctly move the only Different information (this case hours worked) to the appropriate day column on the main form. Am I thinking about this correctly or is there an easy way to do this with copying and pasting.

Thanks For any help you can give me

 

[HiTechCoach]

I am not sure exactly what you are wanting.

options:

1) This could all be handled from within Access. You can use automation to place the data into the desired cells in the worksheet. See: Example

or

2) Write excel VBA Code (Macro) to take the data from one sheet and place it in the other sheet.


Which one are you trying to do?