j.value

Hi All, I have come across a code which am having hard time with. I need the userform information to be entered into another sheet, which is not working. I need the Macro to update the table with new/edit previous information.

Hi all I have workbook with data in sheet(result) sheet(result).range(F1) have value like: yyyymm=> 201909, 201908 .... Now I want macro to check that: 1. Get 02 character from right(range(F1)) = b 2. If b <> 12 then check each cell(1,j).value from range(G1, last column) - If cell(1,j).value =...

Hi I hopeyou can help, I am trying to make a post code lookup, so for example inTextBox51 you type in your postcode like ‘WR5 3’ then automatically it updates textbox52 with the area of the postcode for example ‘Worcester’. It gets the data from my sheet called ‘PostCode’and looks at row A for...

Hello folks; My very first post here...Using Excel 2016 with VBA. I have created some code that will copy specific data based upon certain criteria. I'm not very good at VBA so it may not be the most efficient but I'm 98% there...the criteria works great! I cannot for the life of me paste the...

Thanks in advance for any suggestions for which I will give feedback. I am trying to set cell to a formula involving name ranges. Where, for example cell D53 [Cell(53,4)] formula would be = V1.Total.NPV10 + V2.Total.NPV10 + V3.Total.NPV10 + V4.Total.NPV10 + V5.Total.NPV10 since the value in...

Hi all I have sheets("data") and want macro to do that: Check data if wrong will copy to sheet("false"), check each 10 rows and again to last row have data (i = 3, i = 13, i = 23.. and continous) x = 1 to last row in sheets("false") With sheets("data") For each row i = 3 to lasrow For each...

Hi all I have workbook with 4 sheets("datanew", "dataold","higher", "lower"), now I want to find higher/lower value then copy to sheets("higher/lower") with conditions that: With sheets("datanew") lastrow = .Cells(Rows.Count, 12).End(xlUp).Row lastcolumn = .Cells(1...

Hi I have a code that works perfectly however it is long and takes a while to run - can anyone help to shorten the code? The code basically looks at different sections and hides rows if all columns contain 0. Sub HideRows() Dim i As Long Dim j As Long Dim hide As Boolean For i = 6 To 15...

Hello all I have this code which copies over values from the active worksheet to a sheet called "Actions" under the next available line if the value in "G" is equal to "A" Can anyone help me please, I want to also only copy over only unique lines. (UID) "B & E" together would be the UID but I...

Hello, I am trying to use a macro that was designed by a former colleague. It is a rather standard macro to automate data input into an IBM Emulator. Below is the script (the creator was French): The error is occurring at the MySession.SetConnectionByName (SessionName) line. The macro...

Hi guys, I can't figure out where is the do - loop error im having... my code is as follows Sub round() Application.ScreenUpdating = False Application.DisplayStatusBar = False Dim i As Integer Dim j As Integer Dim a As Integer Dim b As Integer a = 2 b = -2 i = 10...

hi guys, I have got the code of If Not IsEmpty(UserForm1.Fillin1) Then flag = False i = 0 ID = UserForm1.Fillin1 Do While Cells(i + 1, 1).Value <> "" If Cells(i + 1, 1).Value = ID Then flag = True For j = 2 To 17...

Hello i am new this is my first post, had a look and the site seems very helpful like it so far! What i want to achieve? Use patients name and retrieve 2 fields ( got it working but works with Integers only ) - this fields should not be editable After locating the patient to add in the row in...

In Excel, <tbody> AN201 BOS 306=1234 035=Yes 102=Yes 100=70 097=Yes Sometext shouldcome after a longspace thankyou AN201 BOS 306=1235 035=No 102=No 100=71 097=No This is second scenario thankyou </tbody> And the OUTPUT should be in NOTEPAD...

Hi yall, I'm working on a spreadsheet to track & map out progress for players of the Legend of Zelda Randomizer. A gamer has got into the code for the original NES Zelda game and randomized many aspects of the game including the overworld's layout (Dungeon/Shop locations) and shapes of Dungeons...

Hi i have the code below where it does a search but it will only let me enter numbers in the textbox and not letters, but i want to be able to input both numbers and letters can you help please, i am very new to VBA and still learning, i have searched for the answer alot on internet with no...

So... I've got 3 columns in my excel spreadsheet, I,J and L. Looks something like this: I J L 1 1 1 3 3 3 4 7 4 5 6 7 The column L is supposedly empty but I wanna make those numbers appear there.L would be based on I and J. The...

Hi all. I got a question regarding a file that I'm working on since yesterday. I got this table: I need the data to be like this: So If a person has 3 OK's The code needs to return the column header and create a duplicate for every column header. I got this code now. Sub BlankLine()Dim Col...