Search results

Hi, Here's a file you can test. Just click the "Run" button. You will need to clear the Master sheet when you test again.

Lax, Sorry for the delay again. I'm having a hard time for a solution. Perhaps another forum Member can take a look at you file to determine if they can come up with an answer. If not you may need to reformat your file.

Lax, Sorry for the delay. I've been lookin at your file trying to determine the reason for code. You have 3 sheets. You can actually narrow that to 2 sheets. "Delimited" and "Master". I reformatted the "Delimited" sheet. But, for the project I can not see why you are doing this. There must be...

Lax, Here's a copy that I think you want. If not Please correct to let use know what the "Master" should show.

Lax, In the "Master" sheet where does "Type" and "Temp" come from? Also, "Dimension" in data sheet. and too, provide what the data in the "Master" sheet that meet your request.

Hi, If you want to keep only the latest file you can loop thru the BackUp folder and delete them prior to saving the new workbook. They'r maybe code examples in this forum.

I think you need to rethink the format of your file. In the Product master you should show the "Product Name and the "Product Code". This format will made it easier to code. Also, instead of using the same id as in your file use "Product Name" as you have it now. But, for the Product Code use a...

Hi, Perhaps you need to check your request. Your showing examples that are not in the file you sent. Ie "East" you have "Deepak" posted in you example above, but not in the file. Can you recheck the file so that it matches your "Example"

Thanks for letting me know. I'm looking at your request for other settings.

Hi, The error is because you clicked the "LestSearch" 2 times. When the "Listbox" only show 1 employee. You do not need to click the "LetsSearch" again! Check this file it should show the "Header" when you select "Instant Search" Step 2 of your post will only show the employee. I think this...

Svmaxcel, I'll check on the slider. When I ran the code "My code" it seems that the slider did go from left to right. The listbox only shows selection for the desired employee. That may be the reason that you do not have top to bottom. As for the "Header" when starting you search I'll check on...

Hi, I should have mentioned that to tell I re named your userform to "frmDastForm" and changed the list box name to "lstDataResult". You should refrain from using "Me". For list box try to use "lst" for command button try to use something like "cmd". The same pattern used for other controls.

Hi, Here's a file you check. I only coded for "Instant Search". To ope

Hi, I have a code worked out for the desired selection of the "Instant" search. It will populate the listbox. But, at this time I need to modify it so that it will repopulate the list box as you type the desired name to show. I will be gone reset of today and tomorrow.

Svmaxcel, Are you wanting the "Listbox" to list the required range first and then refresh when the user make their selection and only show only their selection?

Thanks, I just sat down to work on this file and was about to create my own file. But, received mail that you were going to send a file.

Hi, I'll be out today. If possible post a sample. Else another member may help.

Can you post a redacted copy of your file.

Hi, Here' a code that you can look at. In the worksheet for the amount you will need a header. Also a header for column C. Copy code to the worksheet that you are using. Private Sub Worksheet_Change(ByVal target As Excel.Range) Dim lrow As Long If target.Address <> "$A$2" Then Exit Sub '' get...

Hi, You can use a worksheet change event to record the data each time the value is changed. You should be able to search this forum that may have the answer you seek.

rxk, Thanks for the "Like".

Hi, All you need to do is add the excluded sheet. If ws.name <> "A-List" and ws.name <> "P-List" and ws.name <> "Data-List" .

xvmaxcel, I think you need to check the "List" box column count. If it's 2 then change it to 5. This may work.

Would it be possible to redact the file and post it?

HI, Had to correct my previous. The code loops thru all work sheets that are not "P-List" and "A-List". It does not matter what the sheet name are as long as it's not "P-List" and "L-List" So I'm not sure what you mean!