branch

  1. K

    Is it possible?

    Hi, I want to know if what I am thinking is possible and if so what should I Google to find out more? I have 5 workbooks, each workbook represents five different branches of a company and each workbook has worksheet tabs from January to December (12 tabs in total) in which an invoice is for...
  2. B

    Multiple DGET use in one sheet

    Hi, I have a workbook with 2 sheets. One is a database sent to me that contains BRANCH CODE and BRANCH columns: The other is the sheet that I'll actually be working on: So what I want to do is when I key in the number on the SITE COD columns, the SITE NAME column automatically gives me the...
  3. sleek12

    Serial number tracker

    Can i get any link to download or know where i can find such a database ? I need a serial number tracker and to allocate certificate to a branch & then branch to allocate it to an agent .
  4. K

    Lookup value at intersection of two locations in mileage chart

    I have an expense form that includes a mileage chart. I have "From Branch" and "To Branch" columns, each of which uses the same list of branches as data validation. <tbody> From To Mileage Main Ditch Road 12.51 The Other Branch Main 16.86 </tbody><colgroup><col><col><col></colgroup> I...
  5. K

    Excel Crashing 1 out of 5 times

    Hello all, I am still very new to VBA and am probably making terrible mistakes in the below code, but am willing to learn. So this is pulling some summary numbers from reports that are generated on a per facility basis. All the reports are named the same thing, but are in separate locations...
  6. J

    Adjust value depending on month selected in sheet

    I am trying to create a master document that itemizes all of the stationery ordered from a branch within a particular month. I currently have a spreadsheet for each branch that lists the product code, description and quantity for all stationery. Each branch has exactly the same information...
  7. S

    Tree sumation in Excel (with or, if possible, without VBA)

    Hello everybody, I have to model branched water supply network showed in picture attached here https://goo.gl/jJFhMx. Node numbers are written in brackets, while pipe numbers are written in red and rectangled. Water demand is defined in nodes and marked with an arrow. So, input data are pipe...
  8. S

    getting unorganised data analysed

    My data looks like <tbody> Branch name AA | | Total 1 2 3 4 Branch name AB | | | | Total 5 6 7 8 Branch name AC | Total 9 10 11 12 </tbody> The branch name and one of the totals fall in...

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