val

Hi All, I'm trying to load data from excel to sql server. For this I created an insert statement which is very generic means this statement can be used for any table. I just have to change the name of the sheet and it will automatically pick up the names of the columns and their values from the...

Hi, I am using the below code for content banding whenever a value changes in column B Can anybody please amend the code to look at visible rows. Like when data is filtered. Sub Colorize() Dim r As Long, val As Long, c As Long r = 1 val = ActiveSheet.Cells(r, 2).Value c = 34...

I would like to sort cell values in a single column from smallest to largest. However, I can't seem to make my code work. I would like for my column to constantly sort the column when it is updated via its formula. Below is my code. I made an If statement so that whenever the range of cells are...

So I am using the below code and it works perfectly thanks to some help on here but I want to add a check so that if the row has data but the value of ws1 column G is empty then I want to get the value of ws1 G by using ws1 E as the reference and getting the value for G from ws2 column A. The...

So I had a great deal of help coming up with this code which works flawlessly but I was wanting to know if anyone can see a way to do two changes, 1) Make it match both column A and column L so be a match and B if no match is found then add the record to the next available row? Thanks in...

I need copy data to another sheet My tab("Relatorio") hava CFOP in column M, if find any value start 1 or 2 like this( <tbody> 1253/AA 1949/ZZ 2102/AA 2353/AA 2920/AA) </tbody> Copy to tab("Saida") case start like this( <colgroup><col width="64" span="3"></colgroup><tbody>...

Hey Guys, I'm not too sure how to approach this but i think it's a VBA problem and i'm having a lot of trouble figuring it out. Apologies in advance... it's a long one lol TL;DR The problem is i'm trying to find the optimal allocations to result in the highest possible value given some...

I have a strings of text similar to the following (4010059877-TUR36036133 or TUR603916## 401007329) in column "AK".I need to Eliminate the TUR######## which can be at any point in the cell and has a different number behind it each time. Is There a way to delete only this part of the cell? I...

I can't tell whether this is the expected behavior or not, but I am getting more data than I would have expected when I do "show details" or Drill Down from within a Pivot Table. Here is a simple dataset: <colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>#DAE7F5[/URL] "]...

I have an almost perfectly functioning macro which matches rows in one table to another, and then imports any rows that aren't present in the source table onto the end of the destination table. The ONLY problem i'm having, is that one section of the very last row that gets pasted gets...

Hi, Please can someone help me? I would like to alter the following code so it searches all my workbooks sheets instead of just one. Here is my code: Private Sub CommandButton1_Click()Dim at As Long, LR As Long, x As Long, j As Long, val As Double If TextBox1.Value = "" Or TextBox1.Value =...

Hi I use below =Translate() function to translate a text the below code works on all language except english to arabic (it works arabic to english) what is wrong in this code?? or can anyone suggest a alternate code for translating english to arabic Function ConvertToGet(val As String)...

I am trying to find the minimum value on a given range. However, my range starts with a character and the row is formatted as Text. I worked around it by using the Val function but I was wondering if there is an easier way to find the minimum value. Range C21:C25 are blank in this current range...

The following macro works only about 80% of the time. I'm pretty sure the problem lies with the 3rd party software xlwings. I'm using xlwings to call Excel. The Macro is so simple that I seriously doubt the problem lies with Excel. Then again, I don't see why there should be a problem with...

Hi All, I cannot seem to figure out how to get this code to work multiple times on the same Worksheet (I am definitely a beginner when it comes to VBA). So much so, that an awesome member helped out on this forum with the below code to hide and show rows (2-43) based on a number entered into a...

Hi, I have data that looks like columns 1 and 2 of the following: <tbody> Level Value Tree Index Current Output Expected Output 1 1 1 1 3 2 1 1.1 1 2 3 1 1.1.1 1 1 1 1 2 1 6 2 1 2.1 1 5 3 3 2.1.1 3 3 3 0 2.1.2 0 1 4 1 2.1.2.1 1 1 1 2 3 2 4 2 1 3.1 1 1 3 0 3.1.1 0 0 2 1...

Lads, This post relates to my previous one as no one is replying :) https://www.mrexcel.com/forum/excel-questions/1054040-vba-runtime-error.html I need to amend code so row is added. At the moment code only removes row. Million thanks. Sub test() Dim cnt, rw As Integer Dim val As Variant...

Lads, I have issue with my manually entered data on excel spreadsheet misaligning when data is refreshed from MS query e.g row is added or removed by query. I have came across this: https://www.techsupportforum.com/forums/f57/mis-aligned-data-on-data-refresh-565373.html I have tried to follow...

Further to this thread of mine: https://www.mrexcel.com/forum/excel-questions/1020204-auto-update-udf-value.html#post4895641 I have the following in Module1: Option Explicit Function MyFn(firstval As Double, val As Double) As Double If firstval = 1 Then MyFn = val...

I have a UDF that depends on the value on another sheet: Option Explicit Function MyFn(val As Double) As Double If Sheet1.Cells(1, 1).Value = 1 Then MyFn = val + 10 Else MyFn = val + 20 End If End Function So in Sheet2, cell B2, I...