Search results for query: *

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...

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...

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...

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'm sorry if this gets a little long, but I want to provide enough detail to adequately communicate my question: I have two Excel tables located on different worksheets. The first table is a table that contains order information by product SKU. The other table contains production information...