Excel VBA- Creation of a New datablock with criteria

0 votes

I'm a freshman using VBA. I'm seeking for a macro that will generate a new sheet with only the information for a specific strategic health authority that the user selects from a drop-down menu. A brand-new sheet should be used to build the new data block.

The chosen health authority's name should be the title of the new sheet. The various health authorities are as follows:

health authorities The macro should run off a button, located on the User sheet.

I need it to run in a reasonable amount of time (<1 minute).

I already have the developer tab installed, and I know how to make a button. I'm not sure how to make the drop-down box, but. I require Excel for Mac Version 16.68 to work with Excel 2021 on a PC, but I'm currently using Excel for Mac Version 16.68.

Jan 12 in Others by Kithuzzz
• 28,900 points
37 views

1 answer to this question.

0 votes
To insert the dropdown, you can go to developer tab -> Insert -> Form controls Combo Box. Then you can reference it in VBA using Sheets("Sheet1").DropDowns(1)
answered Jan 12 by narikkadan
• 53,520 points

Related Questions In Others

0 votes
1 answer

Creating a function in excel VBA to calculate the average point in a circular set of numbers

I used the following code to determine ...READ MORE

answered Oct 28, 2022 in Others by narikkadan
• 53,520 points
166 views
0 votes
1 answer

How do I combine the first character of a cell with another cell in Excel?

Try this: =CONCATENATE(LEFT(A1,1), B1) READ MORE

answered Nov 7, 2022 in Others by narikkadan
• 53,520 points
104 views
0 votes
1 answer

How to insert a new row in the specified cell only, of Excel sheet using c#?

I have this worksheet with a matrix ...READ MORE

answered Nov 24, 2022 in Others by narikkadan
• 53,520 points
279 views
0 votes
1 answer

In a excel formula I need to create a list of names on one sheet based upon criteria/data of another sheet

The final formula is: =IF(ROWS($H$3:H3)<=$I$1,INDEX(Personnel! ...READ MORE

answered Nov 25, 2022 in Others by narikkadan
• 53,520 points
75 views
0 votes
1 answer

Can a worksheet ActiveX ComboBox work on a Mac?

ActiveX is an outdated Windows technology that ...READ MORE

answered Nov 17, 2022 in Others by narikkadan
• 53,520 points
76 views
0 votes
0 answers

Strikethrough in Excel VBA

When I enter the second date in ...READ MORE

Nov 27, 2022 in Others by Kithuzzz
• 28,900 points
70 views
0 votes
1 answer

I want to compare two Excel files and highlight the differences with VBA

The workbook doesn't have the UsedRange property ...READ MORE

answered Jan 13 in Others by narikkadan
• 53,520 points
57 views
0 votes
1 answer

VBA Export as PDF and Save to Location with name as per a Cell in the worksheet

Following is the code that gets generated ...READ MORE

answered Jan 20 in Others by narikkadan
• 53,520 points
52 views
0 votes
1 answer

Getting data out of a cell with a #NAME? error in Excel VBA

If you need VBA, use .Formula: Dim f As ...READ MORE

answered 5 days ago in Others by narikkadan
• 53,520 points
25 views
0 votes
1 answer

How to insert a picture into Excel at a specified cell position with VBA

Try this: With xlApp.ActiveSheet.Pictures.Insert(PicPath) With ...READ MORE

answered Oct 24, 2022 in Others by narikkadan
• 53,520 points
460 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP