I am looking for help with a code to write all data from visible sheets except the one called "ART Control" into a database in access. On each sheet it has a header in A3:K3 and the data right below it. Each month these sheets are cleared, so it would only need to go down to about 250. Each sheet is called a location (example: Tampa Bay, FL would be one sheet name). I would like a button that scans through each sheet & copy it to the databased called "ART_Triage" located on my desktop. The data base has the exact same headers are these sheets. Any help would be greatly apricated & I have uploaded my workbook so you can see what I am doing! Thank you so much in advance for any help you can provide!
Bookmarks