HI All
I would be grateful for the advice on the following:
I have two "For Next" Statements nested inside each other.
The outer loop takes a phone number from a spreadsheet, then looks the number up on a messaging service.
The inner loop identifies the message conversations and drops each...
I have a table of workstreams that on the go. There is a main page with all the workstreams on at the moment, and then sheets name depending on the reference for ease of tracking. So 'Home', 'ABC001', "ABC002' etc.
Could I create a macro that would make a new row and record the next available...
Hello, i plan to make a macro where the data will be place in multiple row after click the submit button.
below is the current situation:
Private Sub CommandButton1_Click()
Dim Pocl3 As Object
Set Pocl3 = Sheet2.Range("A99999").End(xlUp)
Pocl3.Offset(1, 1).Value = Me.TextBox1.Value &...
I need a formula that will place a text string in a row specified by the number from an adjacent column within a look-up table.
Additionally, I also need a formula that will return a text string based on the same row number described above, plus a match of the ID number with the same ID #...
I would like to find a better way to record when a new row of information is populated in a data set. Currently I have some code that checks when the values are populated in adjacent columns C,D and E, once a value is populated in all of them it records the sheet name and row address in a...
I have this code here that copies, and pastes from one sheet to another if the match is not found. However, I cant seem to get the row counter to reset to the top of the row. Once it is done looping through a row, it should reset to the second row (as the first row will be a header row)...
What I'm attempting to do: copy all the rows from an open workbook, insert them into my other workbook that is a template, between to placeholders with formulas. my data in the template goes from A:CE. I've got the first part working where I insert the rows, but I don't know how to paste formats...
This might be a silly question , but i am not able to add a border between a Row,
Here I Want to Add a Line Between two dates(Where i have highlighted with red color)
Please Guide Me on the Issue.
Thanks
Hello everybody :)
In VBA Code i need to check if there is any cell in column B that is equal to the letter "S", and if so delete the entire row.
I think it should be with the FOR function since in each time I have a different number of lines.
One time I have 2 lines and another time I have 15...
Hi,
Is this possible to detect this kind of sequence in 250k-750k row data.
1) Count start at least the sequence of up-down
2) Stop the count if next value is not in squence of, increasing(up)-decreasing(down)-increasing(up)-decreasing(down),.... , example:
i- up-down->down
ii-...
Hi All, Good Day .. :)
I just started learn more about excel deep nowadays, I got promotion in office.
I was assigned to small task in excel, which a am suck now, can anyone just lift me up from this issue.
I have some multiple sheets with dynamic rows to be updated daily and another mail...
dear experts,
i have to make this (sample) data from this:
to this:
so,
1. the date just has to be unique,
2. the start time is from the first column, and then the end time is from the last column (of the date).
3. the row A and B must be from the summary.
i just confused about how to...
Each row in the database is assigned a unique ID number (5 digits long)
I want to be able to enter than ID number in a textbox in a userform and have the row information (4 columns total) displayed in a listbox.
I want the listbox to update after each 5 digit long ID number entry so I can keep...
Hi guys I need to insert two rows after a row with some content like this:
To this:
I haved found this code:
Sub InsertRows()
Dim Rw As Long
Dim Rng As Range
Set Rng = Sheets(1).Range("A4")
Rw = Rng.Row
Do...
Hi all,
I am wondering if anyone can help with this following spreadsheet VBA – my knowledge to date, has been web searched, combined with a mixture of cut and pastes solutions posted on this forum ?. Unfortunately, my own knowledge doesn’t extend past that and I have been unable to get my...
Hello,
I'm defining my max rows via a basic lookup =LOOKUP(8,1/('Data'!A:A<>""),ROW('Data'!A:A))
This will be named "Rownum" to call globally. So for instance Rownum = 345 or however long Sheet "Data" col A is.
I'm looking to change the hard-coded "z20" and "aa20" to still reference the...
Dear all,
I am a beginner here. I would like to ask a help for someone who can help me to solve the problem. I have around 800 data in excel and I want to move data from one column to different column and row.
It is difficult to say here, I will give the example in the table below.
Please...
Can anyone help me with this code that I have problems doing for the last 2 days. What I need to do is find the last column in that particular row starting from column H onwards, if there is any text that shifts down the row in column G and repeat the action; when it finds the text in a cell it...
Hi all,
I'm new to VBA so trying to learn as much as I can but I'm stuck on this one.
I'm trying to create a macro that when the appropriate button is pressed, resets the formulas in a column that have been overtyped.
I can do this for a single cell, though I want to create one that performs...
Good evening everyone, I'm looking for some code in vba that can find specified dates in a line, if the date is not the same I need to delete the 3 columns, I want to leave only dates in the line that correspond to date1 and date 2 as in the example
before
later
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.