Let's look at an example. Download Excel spreadsheet(as demonstrated below) In our spreadsheet, we have two sheets called Sheet1 and Sheet2. We've placed a button on Sheet1 that when clicked will move through each sheet in the spreadsheet updating each value to proper case. This macro wil...
Most people are telling me I shouldnt have to code anything, but I have a lot of data that I need to export to MANY excel files, so if there was a way to do it, it would make my life easier. Do a GOOGLE search with the something similar to the subject heading of this thread ...