dallas

  1. B

    Creating Table Data in VBA

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

    How do I compute a weighted average for the following?

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

    Conditional Format for alternating duplicates

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

    Conditional V-Lookup?

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

    Linking to External Workbook Error - Indirect Alternative?

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top