dallas

I am building a workbook as an add-in that will provide specific site information such as address, phone, etc. I'd prefer to not store that data in a sheet, and instead would like to store it in VBA, since it doesn't change. What's the best way to do that? In an ideal world, I'd love to write...

<colgroup><col><col><col><col></colgroup><tbody> Store Average Daily Sales Inventory Days On Hand (Inv/Sales) New York, NY 20 40 2 Seattle, WA 25 200 8 Detroit, MI 75 225 3 Dallas, TX 5 50 10 Total 125 515 4.12 </tbody> How to calculate what each stores weight is in the aggregate...

The Following rows are manually highlighted based on text value in Column B. I know how to conditional format for duplicates, but I don't know how to conditional format when there is more than one version of duplicates, in alternating sequence, with variable number of rows. is there a way to do...

Hi Guys, Little problem that I've not quite figured out. Lets say I have a Sheet called "Data" which holds my source data...something like this in 3 Columns Team PointsHome PointsAway Atlanta 25 13 Buffalo 45 24 Cleveland 24 35 Dallas 13 39 So then in a 2nd sheet called "Fixtures" I want a...

I have a workbook (A) that contains multiple tabs, where each needs to be linked to an external workbook (B) that also contains the division revenue on multiple tabs (Dallas, Houston, etc). In workbook A, the user will select a division (Dallas for example), which will look up the corresponding...