b23

I have this line of code: .Range("B23").Value = "October " & Range("E18").Value E18 has the current year and I need the range in cell B23 to be October & the following year. It works to get the current year in B23 but I wasn't sure of the syntax to get the following year.

Hi I want to look up a cell value based on "B" and A7 which contains a number so that the end result should be B23. Im not quite sure how to do this although I believe you use offset. so something like "B&a7" thanks in advance for the help

Hi, I have the following formula working out a random Yes / No based on some probability. In B23 I have the following code (it sits in a table) =IF(A23="","",INDEX($A$2:$A$3,COUNTIF($C$2:$C$3,"<="&RAND())+1)) However as more data gets added below A23, it recalculates. What I'm looking for...

I am using VLOOKUP (trying to at least) to find out how many rooms a hotel suite has. So in A1, for example, is suite 3302F. On another tab with all 1,000 suites numbers, I see 3302F in A23 and in B23, it says "Twr 1B." This is a one-bedroom suite because of the 1 but how do I extract just...

I have a sheet that requires one user input value and then, based on a series of calculations, returns a value. The user entered input value is cell B5. The calculated value is cell B23. I'm trying to create a macro that passes a value to B5 from a different cell and then copies and pastes...