Search results for query: *

Good to know! It's certainly not a "for Dummies" book! [bigsmile] BTW, I'm going to hold off on testing your other code for a few days. I've sent an e-mail to the lady I work with to see if there's something she can do at her end that will keep that extra space from being inserted in the first...

Your suggested formula for dealing with the two spaces came in as I was writing the comment above. I'll give the formula a try tomorrow. Thanks.

TWO spaces! OK, that explains why the MID function was working properly for the 9-digit numbers but not the 8-digit ones. I'm still confused about the Text to Columns feature because the file I receive is NEVER a text file. I get it as an Excel file. John Walkenbach's book on VBA programming...

Success! Now, how about that annoying extra space? It's still left if the module number had 8 digits.

OK, let's try this again from the top. First, the macro I sent you is one of many I have, all of which are saved in my personal.xlsb file. I access all of the macros I use through that file. That's why you don't see this macro embedded in the file. I get a file like the one I sent you every...

The #VALUE! error messages appear in Column A AFTER the macro runs, from the first blank row to row 379. If the macro runs only in rows that have data (which will always be consecutive), this problem will be solved. And yes, the example you highlighted is what I want to get rid of. The macro...

Thank you," Dr. Vought. OK, the cells containing the #VALUE! error all fall in rows AFTER the last row of data. Of course I can (and currently do) delete all of those rows but that's extra work I don't want to do. I do need to propagate formulas in this analysis project later, and at that time...

I'm having two problems with an Excel 2010 macro. I run the macro once a month, each time on a new set of data that contains a varying number of rows. It is supposed to remove a reference number from one cell in each row. (All of these cells are in the same column.) Unfortunately, rather than...

Have to look into that. The only way I know how to access Brainshark is through my organization's link, however. I know lynda.com has some Excel courses. I've viewed parts of one of them.

I'd really stop worrying about the Summary page. It was only partially developed to begin with, and from month to month some videos are going to get viewed while (many) others are not, meaning no data for them. Just let it rest for a while. I'll be back in touch when I need your help again.

I think we need to let this sit and cool for a while, Skip. I want to do some solo research and experimenting. I'm sure there are more efficient ways to do all this but I don't know them and I don't want to just blindly follow your code without understanding it. Especially if it doesn't quite...

Currently I open the .csv file with Excel. To date I have not imported it into an existing workbook, in part because the information the .csv file contains does not provide all of the information I need or contains that isn't accurate, as described above. It's not entirely accurate to say I'm...

The file comes to me in .csv format. The filename is usually something like "June Viewing Details by Presentation.csv", sometimes with the month, sometimes not. I don't know how the staff at headquarters acquires the data. It appears the acquisition is NOT automated. I believe my contact there...

OK, answers: How do I acquire the data? It's sent to me at the beginning of the month from my organization's national headquarters. They draw the data from Brainshark, the web site that hosts the videos. How many different data sources are there? Just one, as far as I can tell: Brainshark...

WHEW! It's going to take me some time to understand all of that! Lots of research and learning to do. Here's what I'm thinking as far as dealing with each month's new data is concerned. 1. I'll build a "master" workbook that contains a blank All Data worksheet plus the individual worksheets for...

No worries! Take your time. It's not a rush at this end. Glad you were able to download it.

Yikes! Yes, I could. Got an alternative?

OK, let's not get into a urinating contest over who does or does not "get" what. I need you to understand that while I've used Excel for something like 20 years, I am neither a database manager/designer nor a VBA programming expert. I've taken on this task because I'm the one guy in my working...

Yeah, well, that's because this is the first time I'm doing this and I'm still in the process of figuring out what to do with the data to produce meaningful information. I've thought about how to do trend analysis but have been more focused on getting this basic stuff done first. Yes, I...

OK, I've looked. Turns out I've already used the structure table concept once and liked it. That said, it doesn't entirely solve my problem. While I can see a way to do away with all those extra worksheets, I think I still have the problem of defining and naming the ranges. The data that all...