hobbies

  1. R

    How to output the result from existing sheets to new worksheet

    How to output the result from existing sheets to new worksheet ? What is the code in need to add in ? [Sub MissingHobbies()Dim c As Integer, h As Integer, ans As Integer ans = 9 For c = 2 To 11 ' candidates For h = 3 To 6 ' hobbies Cells(8, 1) = "Hobbies" Cells(8, 2) =...
  2. R

    Writing VBA macro for generating missing variable

    Hello members, I would like to write VBA macro for listing the missing variables as per below. Among candidates A, B C, D and E. I would like to list down the missing variables (Hobbies), accompanied by the candidates name. <tbody> Hobbies A B C D E Swimming Y Y Y N N Tennis N Y Y Y...
  3. A

    Vlookup Drop Down List Multiple Condition

    Hi, so I got this raw data <colgroup><col span="2"><col></colgroup><tbody> Name Class Hobbies Andrew Apple Swimming Ricky Apple Reading Edwin Orange Tennis James Pear Reading </tbody> and I want to make drop down list with multiple condition (in this case, class and hobbies will be...

We've detected that you are using an adblocker.

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.
Go back
Back
Top