Search results for query: *

Thanks!

I am working in a workbook that is linked to several other Excel files, and I would like to open the source files quickly. I am aware of 2 ways to open a source file: "Open Source" in the "Links..." window from the "Edit" menu, and using formula auditing ("Trace precedents", double click on the...

Okay! Thanks for your help!

The quantity for component "b" IS 5! If we are making 3 of product A and 2 of product B and both product A and B require 1 b, then we need to make 5 b's.

Skip, You're right, the response I posted did not change the order of the parts--and I did see that that's what your procedure resulted in. However, I would like to keep from completely resorting the parts (they are sorted by product family and I'd like to keep them together for readability)...

Okay Skip, I'm not trying to be dense, but it's the next steps that have me confused as to what to do. So I have the components separated into different columns: Product Comp1 Comp2 Qty A a b 3 B b 2 C...

Skip, 50 of the 120 products have compound components, but none have more than 2 components. Thanks, Seth

Hello, I have a spreadsheet that calculates inventory supermarket levels for a list of products. However, some of these items are composed of multiple components which are stocked (rather than the product itself). So, I need to structure a sheet that will translate stock levels for a product...

Many thanks to all you who gave me input on how to handle this. I finally figured out a way to accomplish this exactly as I have it by writing a formula. I was able to do this by taking advantage of the row indices of the data, both of my source list and the linked list. My source list (the...

Thanks for the replies. If possible, I would like to keep the "Actual" information as close to the "Forecasted" as possible for usability reasons: for each item, the user will be going off of the forecasted information to make a decision about how much to schedule (or put into the actual row)...

Just in case it isn't clear, the "Actual" rows will be where the manufacturer manually enters production information every week. Thanks.

I'll explain more about the purpose of my question. This is for a manufacturer, who wants to monitor actual production against forecasted production for each item. The tab I am creating lists the forecast production for each item and week of the year in one row, and allows the user to input...

I would like to drag a formula (with links) into every other row. For example, I have a list of items: Apple Orange Lemon Lime . . . And I want to make a new tab that looks links to the list that looks like: Apple -- Orange -- Lemon -- Lime -- And so on, where the "--" marks indicate an empty...

Thanks to both of you for replying. Rob, I hadn't tried the import/export idea, so I did. I exported all of my forms and modules and added them back in one at a time, compiling the project after each one. This allowed me to isolate the module that was causing the problem (it wasn't the one I...

Hello all, I've got a pretty frustrating problem. I have an Excel workbook with quite a bit of VBA code behind it (it's basically an automated order-entry database, which I have to do in Excel rather than Access). Anyway, it was working great until about a week ago when I added in some...

I need to add to my post above. I am still having the problem, so it looks like this didn't fix it for me. But I do know it has worked for others, but you have to make sure that the version of MSCAL.OCX you install in your System 32 folder is correct for the version of Windows you are using...

You posted your message a long time ago and have probably fixed the problem (or scrapped your program!). But I had the same problem yesterday, and I think I found a fix for it on another forum and haven't had any problems since. The problem comes from having an old version of a small file in...

Okay, did that. Still doesn't work. It appears that the function is comparing the value in "fruit" to the Order list on the Order sheet (where the fruit value is coming from), NOT the production list (even though the code selects the production sheet). The result is that the...

Hey, I have one more question I'd like some help with... The above code from ATylman works, but is slightly inefficient for the size of list I need to use it for. The reason is that every time it is run, it checks the entire list of "Orders" (which can take quite a bit of time, given...

ATylman, Works great! Thanks! BTW, xlbo...what happened to your response?