b15

  1. K

    Text equations wil not evaluate

    I have equations including text, providing information on source directory & save directors the VBA processes. In some cells, they evaluate. For example: In cell B3, ="J:\ACCOUNTS\Credit Cards" & B15 & "" evaluated to J:\ACCOUNTS\Credit Cards\2018\ In cell B4, ="J:\accounts\Xero\Credit...
  2. D

    Vlookup

    I have the following VLOOKUP formula that is returning #REF and am not sure why. =VLOOKUP($B15,Case_Form!$B$2:$B$186,7,FALSE) For reference the number in B15 is present on the Case_Form tab.
  3. A

    VBA - Return part of string

    Hi everyone, I'm hoping you could help me here.. I have a string from where I want to return the characters between the first " " (space) and the second: e.g. 3_ECOB B15 5 PATAKS-PE/CLEAR - I'm trying to get B15. I'm using a combination of left and instr but I'm not able to get to the...
  4. T

    New to VB for excel..

    Hi All, So i just started learning excel and the vb part of it, im getting some of it but not all of it... what im trying to do is take a single word like blue and have it add 1 to a cell that has a number... ie if i have 15 in B15 and then change H2 to blue i would like it to add 1 to 15 to...
  5. Nelson78

    Vba: copy and past numbers stored as text

    Hello everybody. I have a huge amount of records in which a lot of number are stored as text. In order to simplify, I have created the above image: https://imgur.com/a/H5IXsEm The task is the following: for each value in colomn E, put in column F the related value as reported in column B...
  6. A

    Macro to Insert Copied Rows

    Hey All, I'm sure this has been answered 100 times but I can't find anything that is helping me really. I have data in row 23 that I want to copy and paste down X many times based on the number found in cell B15. Any help is appreciated.
  7. R

    Find a value based on two inputs

    Hi, I could use some help finding a specific average from two inputs. Not sure if it can be done, but I have been trying to use sumproduct and its not working out very well. I have a Table setup like so. B1:M1 = Jan, Feb, Mar, Apr, May, Jun, July, Aug, Sep, Oct, Nov, Dec A2= Animals B2:M2 =...
  8. R

    Change cell date when another cell value increases.

    I fave a cell A2 with a date 2-17-2017 and the other cell is summing up from 12 other cells Jan - Dec (sum cell B15) how can I change the date (A2) by a month each time B15 value is increased by $30.00. I hope I explained this well. is there a function I can use. Russ
  9. F

    Range("B" & Rows.Count).End(xlUp).Offset(1)

    Hi Guys, This is probably an easy fix, but I've been struck on this for a while now. Range("B" & Rows.Count) - This will give me the last available row in column B, but I need the paste to start at range("B12"), then B13, B14, B15 etc... Any suggestions? Thank you, FP

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