ab1

Need Help with code to monitor cell AB1, which counts certain words in a range. When AB1 is greater than zero, the system send an email to alert manager. Also Is there a way to increase the base value of AB1 as the number goes up, without manually changing it from 0 to 1 to 2 etc. Also need...

I have the following macro set up to copy data from cells AA1, AB1 and AC1 into the next open row for columns B, C and D. Code: Sub Test() Sheet1.Range("AA1:AC1").Copy Sheet1.Range("B" & Rows.Count).End(3)(2) End Sub The problem I'm running into is that cells AA1, AB1 and AC1 have...

Hello! Looking for some assistance with what is hopefully an easy macro. Looking for a macro to copy the data in cells AA1, AB1 and AC1 into the next open row for columns B, C and D. The data is all on the same sheet, but the data in AA1, AB1 and AC1 will be changing. Thank you!

Hi, I`m a beginner in VBA, but I`m trying to make my work more easily. I have an excel sheet, when changing the number in cell AB1 is pasting different data corresponding with the number inserted in AB1 from another sheet. I have an user-form inserting minimum and maximum number. Starting from...

Hi, I have in column C an amount. In Column D a start date. As headers across columns E1 to AB1 I have dates (9/1/2018, 10/1/2018, 11/1/2018....). I am seeking a formula that looks at the start date in column D, and starts the calculation the same month and year in the header row (E1 to...

Primary Key Project Code Issue Rating 123456 AB1 1 B1 123456 AB1 1 N/A 123456 AB1 2 B1 1 2 A B...

I want to search column C on for a specific string. The cells in column C can hold variable length strings such as C1: AAB1, C2: AB1, B1, C1 C3: D2, E3 etc. I want to find the first instance of a specific string and then copy cells around it. The problem I have is that, the use search doesn't...