Results for "vba search two criteria then upadte multiple sheets"

hi,

code fixed for the update.

Thank you so much.

That has solved my problems.

That when you activate the active sheet and populate the fileds and save it. Then you should be able to edit the submitted data by activating the active sheet and search using year and month criteria to populate the other fields. Edit and hit the update button.

Thank you

hi,

It is not working as expected

How do you expect it to work?

It is not working as expected so I want to change it to the combobox. Am asking to clarify if its only the search textbox to be changed to combobox or any other one. Thank you

Hello,

First of all, is this working as expected?

Take my suggestion for what it is "I would do it differently", but if you are happy with how it works, there is no need to change.

Thank you. Please if I get you clear, you are suggesting that, the search textbox should be changed to combobox.

Kindly help me with the fixes and where to reduce the number of fields.

Thank you

Hello Vickwa,

I made some fixes to your code to make it work, but it's not optimal. I would reduce the number of fields, make use of combobox instead of textbox, ...

Please I am having problem with userform to activate a sheet then searching with two criteria that is by year and month to populate other fields and then update.Kindly assist me. Iam new to vba. Thank you

Have attached the file

I understand you. Thank you

Dear,

To solve your problems, I would completely redesign and rework your application, but that's not the kind of application I want to spend time on.

Thank you for the responds.When i select the sheet name and the year then click the filter buttonit gives me error code 1004 and hihlight as attached

The second issues is after saving data, when you search by year and month then edit the data and you forget to click the update button and clik the save button again it will save as new, but if it can prevent duplicate by year and month. I hope my explaination is clear.

Thank you

hello,

I want to filter by sheet name and year to the monthly summary.

select the sheet via the drop-downlist linked to the field insurance name.

And also want to prevent duplicate year and month when saving data on the user form.

Can you explain this with more details ? Give the steps (with data) to reproduce the issue, show the issue and document the expected result for the given data.

Please kindly assist me with error am getting and I have attached a copy.

I want to filter by sheet name and year to the monthly summary.

And also want to prevent duplicate year and month when saving data on the user form.

Thank you

Hi,

I'm not sure I understand what you're looking for, but by modifying your formula, it searches in both columns:

=ISNUMBER(SEARCH(C$1,'Two colomns'!$B2&'Two colomns'!$D2))

Dear Team,
I reach out to you to request your support !

How can i use this formula if i have TWO sheets like below:
- The rows on sheet2 correspond to the same row on sheet1
- The data on both sheets aren't start in cell A

As per my Excel sheet attached, could you help me with a formula that can allow me to splitting multiple choice in multiple colomns.

I can get result only for one colomn but i would like to get results for 2 or 3 colomns.

Thank you for your support.

corriedtoppin a écrit :

Sub Test1()

Workbooks.Open (Filename: = "C:\Users\Corey\Desktop\Anton Heatwave\PMI\Countries Indicators #1 NSB(1).xlsx") 'Filename to adapt

End Sub

Still nothing

Hello,

That one look like a valid full name. If that's not working anymore, I can't help you.

Sub Test1()

Workbooks.Open (Filename: = "C:\Users\Corey\Desktop\Anton Heatwave\PMI\Countries Indicators #1 NSB(1).xlsx") 'Filename to adapt

End Sub

Still nothing

I don't know. That's the name of the excel file: Countries Indicators #1 NSB (1)

Sub Test1()

Workbooks.Open(Filename:="C:\Users\Corey\Desktop\Anton Heatwave\PMI") 'Countries Indicators #1 NSB (1).xlsx

End Sub

I am only getting and error.

corriedtoppin a écrit :

This is the file name:

Sub Test1()

Workbooks.Open(Filename:="C:\Users\Corey\Desktop\Anton Heatwave\PMI") 'Countries Indicators #1 NSB (1)

End Sub

This is still not a valid filename...

The right syntax is simple : Complete Path + \ + Workbook name + Extension

I gave you an example : C:\User\FullPath\WorkbookName.xlsx

Your filename doesn't look like to this one !