wine

As always, any and all help and suggestions are welcome. :) I'm very happy that this weekend is almost over, because my brain is full of Excel and it's made me start drinking wine already. So, in a quest that is somewhat similar to an earlier one, I need to turn all cells a medium light gray...

Hello, I have a work book that has 20 different sheets in it - all with the same data - except for one column which is the variable. In this case column f contains the name of the wine supplier for a wine. column g contains the wine name for a wine column h - the year (vintage) i - the price...

Hi, I have the following as an example of the data that I am working with. I am trying to get a formula that allows me to select the year, week number, and shop, and also allow me to dynamically select the sales (Beer or Wine or Spirits) and then sum them over a period that I define e.g. I...

Hi Mr.Excel.com Forum! I've learned so much from this forum but now I've got a question that I cannot seem to figure out. I am creating a spreadsheet that is serving as an invoice. There are two products (out of 20) that if the quantity of either one OR a combination of both add up to 3 or...

I have a California red wine collection. For each wine I have the Name of the wine (Col A), release year (Col B), Cost (Col C) and Rating on a 100 point scale from my favorite rating source (Col D). The costs of the wines in Col C have been normalized to same year dollars. It has always been...

Hi! I am new to this group and hoping some of you might help answer a Microsoft Excel VBA related question. I am using Microsoft Excel 2010 on Ubuntu using Codeweaver. The Excel VBA seems to integrate nicely with Ubuntu and runs just fine, except that am unable to figure out how to open an...