Question Locked

Need a way to automate Excel worksheets

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello. I'm new to this forum, so hopefully, I'm asking in the right place. Note: I can send a sample copy of the workbook if necessary (though I'm not sure where to post it).

Dilemma:
We have a "tracking" database for employee recogniion. This means that after someone (anyone) submits as card to recognize them for doing a good job, we record it. After the 5, 10, 15th card, they can receive a bronze, silver, or gold star pins to wear on their name badge (trust me, this is a big deal in our organization). We track according to the date the card was receievd, and we need a grand total of all cards for the month.

The first worksheet list all of our employees name, department, the date of each pin received an totals. The second tab has the monthly totals. Our secretaries do not want to swtich between tabs for the monthly total. They want a way to have the spreadsheet update automatically for the month. I'm sure seeing would be better than this description, so any help would be greatly appreciated. They're ok with what I have, but I'm sure more could be done to the worksheet. Thanks in advance!

5 replies

by robo_dev

Then have the spreadsheets set to update their odbc database connections when they open.

This way the data is in one safe place, and you don't have to deal with multiple spreadsheets.

by sfreeman87

Never tried this method, but I enjoy learning new things. Will it be simple for the end user to enter data?

by robo_dev

Article: Making Excel and SQL Server talk to each other
http://articles.techrepublic.com.com/5100-6350-5165764.html

In some cases even Microsft Access can be used for small shared databases. But Access does not scale well, so the 'right' way to do it is to use SQL server, assuming that you have an existing Microsoft SQL server that is used for other applications.

by sfreeman87

I truly appreciate your help with this one. Don't be surprised when/if I submit more questions.

This discussion is closed to new replies.