Search results

Brilliant! Thanks for your help. You were correct regarding the error handling. It was one of the things I moved at one point trying to figure out what was causing it to work some times and not others. It must have been whether the particular sheet that caused the error was the one active at...

hi Sir. Here is a link to the file. Any help you can provide is greatly appreciated. I've tried so many times to get this to work without an error popping up from Excel, but failed. It seems sometimes it works and sometimes it doesn't...

So, I just did a "step into" within the macro and watched as it successfully deleted all the intended data validation lists. There must be an issue on the opening of the spreadsheet when I repopulate the data validation lists, but one particular list is longer than Excel likes. Time to...

Hi. I grabbed a version of the following code from another forum (ozgrid, Dave Hawley/iwrk4dedpr) and tried to adapt it to my own spreadsheet. However, it seems as though the named ranges I want to delete do not always get deleted. There must be a problem with how I have the code grab the...

It does... caught that after I said "###.", but figured the "C" would be easy enough to add. Thanks again, looking forward to learning something out of this! And thanks for your clarification on this filtered list - I noticed that and didn't know what to make of it, but that explains it. Steve

I don't mind handling. Just learning macros and trying to expand on excel skills, so the practice would be good for me.

Correct. I'd like the references within B3 to be more robust, so that adding worksheets or changing the org that one is interested in is easier than I currently have it. And yes, the worksheet name (plus the ".") corresponds to the prefix within the master list of orgs and costcenters.

SirJB7, thanks for the info. A lot of that is over my head, but I look forward to dissecting it and learning a thing or 50. I appreciate it greatly! Regards, Steve

Sorry - deleted a little too much. Added some back in (included some info you may have already edited). Refer to sheet "221" and then cell B3. B3 has a data validation drop down list that refers to named range = TwoTwoOneCostCenters, which is in the CostCenters worksheet. Keep in mind...

Link to dumbed down test file. This case is org 221. See cell B3 for drop down reference. Currently, it refers to a range designed specifically for this org. In order to facilitate easier set up for new users wanting to use my spreadsheet to apply to orgs.cost centers they are concerned...

Yes. The current method is to use a filtered name range (copy and pasted) from the master list for each org set up as a separate worksheet. For org 220, relevant cost centers would be 220.0000, 220.2011, 220.4000, 220.5000, and 220.T . All orgs and related cost centers have a unique structure...

Hi, first post, thanks in advance for any help coming my way. Here's my problem I have been unable to solve. I have on one sheet a list of all my company's cost centers (defined in format ###.#### or ###.T where the first three digits relate to sub org reference and the last four as a cost...