-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
northern
-
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...- tanyaleblanc
- Thread
- center copy cost northern vba
- Replies: 13
- Forum: Excel Questions
-
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...- MixedUpExcel
- Thread
- england margin northern sales table
- Replies: 3
- Forum: Excel Questions
-
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...- alexB588
- Thread
- builder construction northern sheet total
- Replies: 1
- Forum: Excel Questions
-
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
