northern

  1. T

    Copy and pasting data to the next row in VBA Macro

    In VBA I'm trying to copy just the 21 in "Cost Center: 21 - Northern NS" and just the 30, etc, in "Cost Center: 30" as you see below. when I do this in a macro it copies the 21 all the way to the bottom and ignores the 30 and 40, how can I fix this? I tried to tag this, but I received an error...
  2. M

    SUMPRODUCT - SUMIF - MULTIPLE TABLES; To Get Results From Single Criteria

    Hi, I can get so far with my formula but not sure how to finish it off. Please help. I have 4 tables, Table 2 / 3 and 4 have data - the first table has the initial criteria and the formula next to it to bring back the result. <colgroup><col><col><col span="3"><col><col><col...
  3. A

    Transfering Data from two different sheets

    Ok so I am not an expert at excel, but I know basics on how to pull from different sheets. That being said my issue is: I have Sheet 1 (Builder List) that contains all the builders that I work with, you will notice there is an empty column that is labeled "Total YTD Price". I want to transfer...
  4. H

    Cant Get Constant in String to work

    I have a constant which I have tried to incorporate in my VBA code, but get subscript out of range Const Z As String = "BR1" nb.Sheets(1).Copy After:=Workbooks("& Z & Sales for northern region.xlsm").Sheets(1) It would be appreciated if someone could correct my code
    • howard
    • Thread
    • code constant northern region.xlsm.sheets1 string
    • Replies: 4
    • Forum: Excel Questions

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