excel 2010 & vba

Hello, I am fairly new to VBA and I was given a task regarding it, I am using MS Excel 2010. Here is my attempt to explain my end goal and code I've written till now to reach the same. Workbook1 has Sheet1, Col A has `uniqueProductID` from company A Col B has `Price` Col D has `uniqueProductID`...

Hello. BC201132435465798798109112123134145159167178 In column B2 I have this array and in C the answer. Trying to count how many cells are until a value is found. this is the try: Sub Locat() Set rngData = Range("b2:b25") For Each cell In rngData If cell = 9 Then Range("c2").Value =...

I have a code that run the index match and vlookup function, but the problem is that the data I receive is not always the same (sometimes only 3 or 5). When I run the code, the code always ask me to update the value of the unavailable sheets. here's my code Sub Function() Dim ws As Worksheet...

I have posted the problem before on https://www.mrexcel.com/board/threads/formula-to-autofill-with-condition-and-skip-blank-cells.1194817/ It used the if function and it works perfectly The problem is that the data that taken to the master data is automatically run by VBA and it can't add the...

Hi Everyone, Please need someone's assistance, I don't know anything yet about VBA coding, is there any VBA codes or file that fits to my situation? Because, I need to send an email to specific users with their unique login credentials and a PDF manual. Also, i will resend the same email...

Hi, I have an idea about how I want my spreadsheet to work but I'm just not sure about the best way to go about it. As I will be arranging large volumes of data, I would like to keep it as simple as possible and avoid too many IF Statements which can cause the file to get too big. Can you...

Hi, Currently I have a code which unhides the row below if cell J45 is populated. However, I would like it to unhide a block of rows. So instead of just unhiding 1 row below, it unhides 21 rows below (rows 46:66). Is there anyway to amend this code to do that? Private Sub...

Hi, At the top of my spreadsheet I am going to have the Clients name. The client name information is taken from a sheet in the workbook which hasn't yet been created. For example, in Sheet1 Cell D6 will have the following formula: "=ABC!B3" which will bring through the clients name. However...

Hi there, I can see myself spending (more) hours on this so before I do, I thought I'd check if there's any clever cookies who know how to do this. I would like to calculate the compounding interest on a Overdrawn Loan account. I would like the interest incurred to be shown quarterly. In...

Hi, I have a spreadsheet which I have created large IF Statements in. It was all good until I tried to open it again and it took 10 minutes to open! I then realised the size has increased to 10k KB! Here is one of my multiple IF Statements (one of the smaller ones). In column B are 3 digit...

Hi there, I have the following VBA coding on my spreadsheet which functions as I want it to. The only problem is, it is quite slow and flickers a lot. Even when data is entered into a basic cell with no VBA coding attached to it, it acts like it is having a good think about it. Is there anyway...

Hi there, I'm trying to set the format of the cell to format numbers into the following; 00-0000-0000000-000 So when 16 numbers are entered (no hyphens), it automatically comes out looking like this, for eg. 12-1234-1234567-123 But if only 15 numbers are entered, the third to last number...

Hi there, I have the below macro assigned to a Check Box on sheet "G2". The Check Box is Unlocked. I would like both sheets "Beef" and "G2" to be protected. However, the below macro will not run if sheet "G2" is protected (it runs fine with sheet "Beef" protected and sheet "G2" unprotected). I...

Hi, The only data I would like inputted into cell F15 are numbers 840, 841,842, 843 & 844. Also, you can only input into this cell (F15) if cell B15 is populated. Little stumped on this. Can someone help me with the data validation formula please? Thank you!

Hi, Is it possible to run more than one macro on a Command Button and if so, how do I go about doing it? My Code below works for one macro (PDFRentalStmtNo1) but returns an error once I add the other two (Asset_Hide_Pro_1 and Asset_Hide_Chat_1). Thank you! Private Sub CommandButton1_Click()...

Pesky formula! Can anyone see where I am going wrong please? ="Book Value as at "&TEXT((DATE(YEAR(D7)-1,month(d7),day(d7)),"dd/mm/yy")

Greetings, Thanks, in advance to those who might be able to help. I'll make it as concise as I can while providing context when needed. Scenario: I work for a Distribution Centre with about 10,000 unique location in the warehouse (4 different sizes and storage capacity [full, half, quarter...

Hi there, Trying to get this code to work but not having much luck. It currently does nothing. Can anyone see where I am going wrong please? Thank you! Private Sub Worksheet_Change(ByVal Target As Range) If Target = Range("d8") = 1 Then...

Hi there, I have a basic formula =IF(D181=B268,B181,) This correctly returns "Dairy Foods" However, when I try to extend the range =IF(D181:D182=B268,B181:B182,) It returns #VALUE !, instead of "Dairy Foods". Does anyone know why it's going that? Thank you!

Hi there, I would like to have a drop down list with options No.1 to No.10 but once a number has been used, it is removed from the drop down list. I have found one way to do it but I'm hoping there's a better way. Drop down lists go in cells D180:D260. Currently my data validation list is...