Search results

Thanks Narayan! This is a great community... I'm not doing a lot with Excel right now.. I hope to be around more in the future. Wish you the best and I'll pop in from time to time :) Asa

Hi MerryBerry, A couple unclear points from your question: 1) worksheets don't really have variables 2) the closest thing to a null on a worksheet is a totally blank cell; not even containing a formula, or the cell error value #NULL! which is very rare (I don't think it's returned by any...

Congratulation Narayan. It's what you've learned integrated in your own way, plus your skill at understanding people's problems. And you're very generous. Bravo! Asa

Hi Tom and Luke; Luke I see is providing very thorough help, but would this code snippet be of any value to incorporate? Luke, you said Outlook ignores duplicate email addresses, but if there might be any reason to eliminate duplicates, you can use the following code to do so. One minor...

Hi SirJB7! Happy holidays and new year! Regarding defined names, looking in Name Manager I see you have already defined named for several tables. The Names "TablaClientesProveedores" and "TablaClientesProveedoresNombre", for example, refer to all or part of the data area on the...

Hi Sekhar, Happy holidays and new year! What I was getting at, is that you could use a macro to copy the files based on their filename. As you've indicated, the files are all coded according to their vendor unique ID, so the macro could copy the files into folders according to vendor ID...

Hi, Mark! Happy holidays & new year. Revisiting the prior limitation regarding number of assignments per pay period: The simplest workaround that comes to mind, without making deeper design changes to the workbook, would be to use an INDIRECT formula in the conditional format that would rely...

Hi, smc - Happy holidays & new year! I have some pressing matters consuming my time this season, so I hope you have been able to get any needed assistance from others. You may want to start a new topic if you still need help. You can try to reframe your question if needed, and you can link...

@sirjb7 :) Named ranges can have a workbook-wide context and be valid from any sheet, and they can even refer to other workbooks. The main thing is to pass as parameters all ranges that your function depends on. It would be acceptable without using named ranges, although I see you keep a...

Hi Sekhar, Why not just copy the files to appropriate folders? And why do you need to involve hyperlinks? Asa

The problem with switching workbooks is probably your use of Activeworkbook. In a udf, to refer to the workbook containing the udf, use Application.Caller.Parent.Parent (Application.Caller refers to the cell calling your function and you work your way up the object tree from there).

Hi SirJB7, It seems possible that your code is generating an error & terminating early. Try setting a breakpoint in your error handler to check for that, and if so, use other debugging methods to pinpoint where the error is occurring. re:Application.Volatile, it's required anytime your...

Hi Mark, Hmm... Well, conditional formats override manual formats. So, no. Not without changing the way we format the weekend colors. I've avoided suggesting macros thus far for your requests because they are a more advanced topic and I'm particularly interested in telling you about ways...

Hi Mark, Sorry I haven't been able to get back to you sooner. I'm still pretty busy.. Do you mean you don't understand why the change to C2 was in order? Well, in a conditional format rule, the formula must be written as it should be evaluated for the top-left cell in the Applies To range...

Hi smc, The problem with your problem, as I understand it, is that it requires associating purchase order items with financial accounts... usually a job for accountants, not spreadsheet formulas. If these expenses have already occurred in the past, .. you mentioned in your first post "last...

Hi Mark, Conditional brown: =LEFT(C4,2)="PL" Asa

Hi Mark, Ah!! That explains it :) I have my calendar in Microsoft Outlook set to use Chinese zodiak names... because you can... Yes, there are various ways the unused assignments can shift up, Ok, it looks like both your formula formula and your applies-to formula might need changes. For...

Hi Bekkems, Pivot table. Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one See if that suits your needs... It can transform your data in the way you describe. Asa

Hey, Mark, I like your coloring! You might want to make a little change to your Saturday and Sunday color rules. I had the Sunday rule starting on the second day of the month -- column D -- because I thought there was no point in drawing a dashed line to the left of day 1, since the line...

Same goes for any other fields you may want to include in the the comparison if the description will not be sufficient on it's own for a unique match. Asa

Hi again smc, My biggest concern is that you said the description "may not be identical", if I understood your original post correctly. It would be very helpful for some examples that demonstrate the range of differences that you want to be automatically matched. Can you list some...

Hi smc, Thanks :) I hope your schedule relaxes a bit soon! Asa

Hi Mark, Those links don't work for me -- I just get an error. If you haven't already, you'll need to tell Google to share your file before others can access it. My approach with Google Docs is: first, when uploading the file, choose not to convert to Google Docs format, unless the file is...

Glad to hear it -- sounds like a big hassle! I guess I was late with my links :) Asa

Hi Alex ... Based on Narayan's feedback, I'm thinking that there could be something else on your system causing the problem. http://support.microsoft.com/kb/329820/ Try disabling your antivirus and or any Office-file plugin or scanning features. Apparently mapped network drives for...