Every month we have to process a very poorly formatted CSV file for use in reporting. This CSV has commas in some of its values (ex. column1, 34,000, column3). From my perspective this is a retarded export format, I think you should let the end user's program format the values. Unfortunately...
I have a monthly report that is exported for each of the sales reps, detailing their advertisers activity. I have an access report which compiles all of these reports into a single multipage PDF. Which I must then use Acrobat to break into individual PDF's. These PDF's must then be placed in...
I have a spreadsheet which contains survey results. I need to use excel to tally the results from each column and tell me the which text value occurs the most in each column.
Can this be done in excel?
Where I work we are about to finish a user survey that we used Survey Monkey to deliver. This surevey is absolutely non-scientific, but we do have to be able to tally the results. At first we were expecting something like 100 responses so downloading it into Excel and hand counting the entries...
To preface I know nothing about VBA, my primary position is a web developer using Adobe ColdFusion and some PHP. This gives me a little confidence with VBA, but I am still a complete noob and know pretty much nothing
I am trying to use MS Access 2010 to create a tool that will import a monthly...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.