Urgent Help Required - Will reward

[thewarning]

Hi all,

I really hope you can help me. I have unfortunately gotten in over my head at work and require some urgent assistance. I'm more than happy to pay/reward people for their services if need be - I just really don't have much time.

The problem:

I have a spreadsheet that contains a whole bunch of survey questions, these survey questions are broken into 7 categories and each question can be answered using a drop-list option with either A, B or C and then a final accumulated answer is given (which ever was the most common across that Topic) Up until this stage, this is all manual.

Example:

Topic
Question [drop-down list] - A
Question [drop-down list] - C
Question [drop-down list] - A
Total [Drop-down list] - A (being the most popular in this Topic)

Topic
Question [drop-down list] - B
Question [drop-down list] - B
Total [Drop-down list] - B (being the most popular in this Topic)


Further there are 21 worksheets (3 for each topic) that has details on each Topic.

What I need to do:

I need to build a series of check-boxes (A/B/C) for each topic (7) that allows the user to select the two topics they wish to learn more about.

The macro will then look at the two check-box Topics that were selected and provide them the correct sheet based on the "Total" associated with that Topic (Being A B or C)

I want it to take them to a sheet where both topics are available, one after the other.

Please let me know if anyone can help, or if I can provide clarification!

Thanks,

[nathansav]

Do you have a sample workbook?

[Richard Buttrey]

Hi,

Given the subject title, this might be better in the Commercial Services forum. I can't just move it for you since you need to indicate how much you are prepared to pay.

On the other hand you might just want to leave it here to see if you get any free assistance. If you do raise it in the CS forum then post back here and I'll remove this thread.

[thewarning]

Link to example document:

https://www.dropbox.com/s/rxih5cmdqg...s_example.xlsx

Thanks,

[thewarning]

Hi,

I am currently working on using the TickBox.

So far I have gotten it to Unhide, copy to a new workbook, hide again and then go back to the original workbook. Code is below:

Sub CheckBox1_Click()
If ActiveSheet.Shapes("Check Box 1").ControlFormat.Value = xlOn Then
Sheets("CM Competencies").Select
Sheets("Emerging SM ").Visible = True
Sheets("Emerging SM ").Select
Sheets("Emerging SM ").Copy
Windows("Competencies.xlsm").Activate
Sheets("Emerging SM ").Select
ActiveWindow.SelectedSheets.Visible = False

End If

End Sub

However, I need to figure out how to add a second criteria,

So, in plain english: If The Tickbox is selected, and the 'Total' for Topic Catergory 1 is 'A', show worksheet 1A

Else, If The Tickbox is selected, and the 'Total' for Topic Category 1 is 'B' show worksheet 1B.

Any ideas?

[zbor]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[zbor]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[zbor]

I suggest you as Richard Buttrey said to open new question in Commercial Services subforum and start all over again but first, please read Forum rules.