Sending one group of entries to other sheet through UF.

**vapxl** · 10-02-2018, 03:29 AM

Hi
This is the first time having a question.

I have my standard records in MasterList sheet. In the second column
throughout I have the company names. In sheet4 I have listed down all
the company names and given a name range (A4:A50) as CompanyList
Adjuscent to all the company name on the right column I have mentioned the range of
excel row numbers where this company name exists .
Company(A4:A50) ExcelRowNo(B4:B50)
ABC 10-50
KKR 55-75
XYZ 100-200
and so on...
In sheet5 named as Sorted , I have userform1 with combobox1(with company names)
and command button.
When I select the company name in combobox1 and run the command button , it
matches the company name with the number of records mention in excel row number
and copies all the record to Sorted sheet from row three onwards. If command run again
it delets the old records

Have a nice day
vapxl

**Olly** · 10-02-2018, 03:38 AM

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**vapxl** · 10-04-2018, 08:24 AM

Small mistake in the explanation in the previous message.
I have attached a sheet. Required result is in Sorted sheet where any old records first
gets deleted and new is pasted.
Button for UF in Sheet4 where I select the name. Require code for command button.

Thanks