Populating multiple sheets from a data form

**Juli** · 04-01-2012, 02:24 PM

How can I populate several sheets in the same workbook from one data form? What I am trying to do is use the form "Main" to populate the majority of the information from each match. "Shooter" (Combo box) needs to populate the next line in "Match Scores" and the next line in the "Ledger" and then the match 6 score calculated on the form needs to fill in on the right shooter on the averages sheet. I can get the match scores and ledger individually to populate, but when I try to do both it wont go. I am thinking that once the score populates the match score sheet it would be easier to take it from that sheet to the Averages sheet?

**davesexcel** · 04-01-2012, 08:16 PM

You should stick to just one question per thread.
Your code

Please Login or Register  to view this content.

Does work, you have no code to place it to the other worksheet you have mentioned.
You may want to utilize this

Please Login or Register  to view this content.

You can use this to place a value from your control into the first empty cell in column A

**jaslake** · 04-02-2012, 01:07 PM

Hi Juli
You indicate

I can get the match scores and ledger individually to populate, but when I try to do both it wont go

I see the code to populate match scores but there's no code to populate ledger. Show us what code you have to populate ledger and perhaps we can make them work together.

**Juli** · 04-02-2012, 06:24 PM

Just got home from work and will work on both suggestions and post the other code. I removed some of it as I thought that was what was causing the error message...