Hi, I have a data list and a userform to add additional row(s) with data. I would like an error message to pop up whenever duplicate data is entered in the according userform field on the basis of a specific column in a named table. A blank entry field is admitted, but no duplicate entries. I...
Hi,
I have a userform with text fields and checkboxes. The data entered in the userform will be transfered to a new row in the named table "tblColleagues". This table already contains a few rows with data but the named table range also covers lots of empty rows. How is it possible to make the...
Hi All,
I've been using this fantastic forum for previous VBA issues I've had, seeing other peoples posts and using the brilliant answers people have provided, however It seems Im going to need the extra help on this one!
I have a workbook that I use as a report for Aged Debtors, with a query...
I am working with an absence tracker and am currently using the below VB Code so when a drop-down list item returns "Closed", it copies the row across to the "Archived Absence" sheet.
In the drop down, there is also a selection "LTS" for Long Term Sick people. When "LTS" is selected, I need it...
Hi,
I want your help.
I try to make a VBA macro that it will be searching TRD from column B and auto coloring in the same row on column A the corresponding number.
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...
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.