.value

Hi, I have indexed data in K1:K7 and values in L1:L7 (incl. header row) I'd like to extract unique values from K1:K7 into column G and in column H list SUMIF values. I have the following but it returns the value for the first unique value in K2 on all rows in column H. Can someone suggest, I...

How can I get data from a closed MS Excel 2019 Workbook into an open MS Excel 2010 Workbook? Had they both been the same version I could just import the sheet. Thanks in advance for any suggestions as I will provide feedback. There are many posts with the same solution I'm using, but I need to...

I have numbers that when imported appear as text in Col F I have tried to write code to convert these into numbers, but the text for eg '1.00. '3.00 etc will not convert to 1.00, 3.00 etc Book1A1Stock Holding21.0031.0041.0051.0061.0071.0082.0093.00101.00111.00122.00131.00Sheet3 Sub...

Hello everyone, I found a Code for VBA to use double click in certain cell to activate Yes and No. However, I cannot to add to that code that it also show blank (or returns to the default result aka do not show anything). Can anyone help me please? P.s I am newbie. Code: Private Sub...

I have a workbook that has multiple sheets, and I have a macro that will copy and paste three select sheets into a new workbook. I'd like to add an automatic save on the new workbook, but i'd like it to save in two places. One being the same place as the workbook that runs the macro, the other...

Hi, I found the following code to report cell changes: Workbook event: Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) If Target.Parent.Name <> wSummary.Name Then Exit Sub Application.EnableEvents = False LogChange Target...

Hi, good afternoon, hope you can help I have the code below which is part vlookup and part vba but it doesn't work, I want it to go into cell C2 then drag it down to the last column, but all it does is paste the same code into each cell and does nothing hope you can help. [CODE]Private Sub...

Hi, good afternoon. I have got the code below where I copy data from one sheet to another but in row B the data in this is 13 numbers but it comes up as +23555 for example how can I change the value to this to show as the 13 digit number? also in Row Q is the date as 15/05/2019 but when copied...

Hi All, I am getting an "Excel Cannot Complete this Task with Available Resources" message when I attempt to run the below macro. The issue only occurs if I paste 1 line of data in the macro workbook If I have more than 1 line, everything runs as I expect. In my code below, is my If...

Hi Please can you help, I have the code below where for example in cell BK1 I have the word "ETA" and I want to copy this over in A@ and down to last row. and then I want to copy the data from "FMUI" sheet into "New" sheet, but I keep get errors. please can you help. [/CODE]Private Sub...

Hi I have the code below where I copy data from Range AL2 to paste into B2 but the numbers look like 2.7Ex12 and I want this to show as 2700444444444 for example how can I amend that in the code? it is the first line below Private Sub CommandButton2_Click() Range("AL2"...

Both of these codes go down 8 rows past the last row. My headers are in Row 4 and the data starts in 5 down Sub Find_FloorStock() 'Author: G Heyman 190221 'Update "Type" Find Floor Stock and change from B to F" With Range("G5", Range("G" & Rows.Count).End(xlUp)) .Value =...

So i've written a code to go thrue my drop down list and print every sheet. I wan't to take it to the next level and do a For loop to do this for me. Could anyone help me modify my code so that the loop goes thrue all the values but if it hits a "" space, stops. Sub NastaButik() Dim v As...

I am guessing there isn't a possibility of this based on the purpose of .value; But I am looking if there is a possibility of also taking the format on a .value = .value I am trying to avoid a copy and paste I have an example below Dim c As Range For Each c In Range("A2:B" &...

I have an issue with the formatting of data. the script I have copies data from "PASTEDAT" tab and paste into "QUASAR Script" tab. So the data from the "Data"tab can be as follows 546882 546883 '092384 Copying the 546XXX numbers are ok. However, the resultant for the last number pastes into...

Hi, I'm a newbie in Excel. Could you help me to code for hidding rows that are non consecutives ? My cell A1 is a dropdown menu, with the choice between Value1 and Value2. I found this (adapted to be simple), wich is working : Private Sub Worksheet_Change(ByVal Target As Range) If Not...

Hi Folks, with some help from here (thank you again) I have been using a macro that makes a new sheet which is named the same as the highlighted cell. Works brilliantly but I now need it to add more information (it currently pastes the sheet name only). Ideally I have another sheet set up...

How to Use COUNTIF to Count Non Empty Cells in Excel Sub CountNonBlank() Cells.Clear Range("A1:A7") = Application.Transpose(Array("A", "B", "C", "D", "E", "", "")) Range("A10").Formula = "=COUNTIF(A1:A7,""<>"""""")" ' Rong result Range("A12").Formula =...

Hello, I'm struggling with applying a formula down a column, with VBA. The formula in cell AT13 is: =IF(AL12=1,COUNTIF(R2:R11,"=1"),"0") which I can extend down to the last row of data, but I would like to use VBA, to automate it. The code below does not work, and it looks like I may need to...

Hi, I have a worksheet showing 3 tanks where they have not the same capacity and by help I got a code (below). Current code shows that the 3 tanks have a capacity of 400000. My problem is that only Tank A has that capacity. Capacity of Tank B is 272000 and Tank C is 200000. Will you please...