Refer attached Excel file for answer to forum question on
http://excelexperts.com/creating-2nd-list-dependent-1st-list

See data validation criteria conditions on Cell A2 and B2. Also see Named ranges created (dynamic named ranges can also be used here)

Here is small Task Management Utility with facility to view Reports. Give it a try and give your feedback and suggestions.

Download the attached UK Tax Calculator Excel file having simple and comprehensive tax calculator.

Simple Tax Calculator:

Comprehensive Tax Calculator:

This is a small Leave system utility. Download the attached zip file and extract excel and access file from it. This can be used in a multi user environment as well by keeping the access database at a commonly accessible location and distributing the excel file to all users. In the access database there is a table 'M_LeaveTypes' from where you can maintain the Leave Type and Max Carry over for each type of leave. In this system an user is identified by his Windows login id.

Here is an utility to generate a simple multi choice questionnaire/survey (as you wish to use it). The survey response files can be collated using the collate responses button and selecting the created files

This is a small utility to speed up the process of buying and selling between a Shopkeeper and a Customer. There are two sections (excel files) of it - Shopkeeper and Customer.

The Shopkeeper file as shown below remains with the shopkeeper where he can add/delete/modify items (Click Manage Items) and prices in the stock. 

The Update Customer copy button allows you to choose the other customer copy provided to be updated with the updated items and prices. This updated customer copy is then emailed/sent to the customer.

Following piece of code sort the data based on custom sort order. You can provide your own sort order in a separate table. For illustration, download the attached file.

Sub TestCustomSort()

    Dim rngSortOrder    As Range

    Dim rngSortValues   As Range

    Dim arrSortOrder

Copy-Paste the following code in a general module and run. Alternatively, download the attached file to see how it works. You can pass field names (Column headers) or Column Index as function parameters.

Sub TestIt()

    Call CustomSort(Sheet1.UsedRange, True, "F1", "F4")

     'or

    'Call CustomSort(Sheet1.UsedRange, True, 1, 4)

End Sub

Put the following code in a general module and run. You can download the attachment as well to see how it works.

Sub TestIt()

    Dim rngTgt As Range

    Dim arr

'Target where you want to see filtered data

    Set rngTgt = Sheet1.Range("J2")

    rngTgt.CurrentRegion.Offset(1).ClearContents

'Calling function with parameters

This will record any cell change in the cell comment. There is a constant at the beginning of the code module; you can set the number of records in comments (history) to be maintained. Specifying 0 means no record limit. This applies to the whole workbook.

Const gc_intMaxCmtHistory As Integer = 5 'Max Comments History allowed

                                         'Change it to 0 to allow n no.

Follow these steps to create a pivot table from multiple sources (same of other file). See attached example file.

Steps :
1a In Excel 2003 open the PivotTable and PivotChart wizard by choosing Data -> PivotTable and PivotChart Report.
1b In Excel 2007, press Alt+DP, then type P to open the wizard as there is no equivalent menu option.
2 Choose Multiple Consolidation ranges
3 Open file B as well
4 Choose relevant page field option
5 Simply select and add the ranges (highlighted cells) from this and other file. You can choose to have as many files (A+B)
6 Select New Sheet & Finish

This is the solution to blog on url
http://excelexperts.com/help

Please see attached xl file.

Solution for problem posted on url

http://excelexperts.com/copy-range-data-new-worksheet-when-matching-data...

Please see attached sheet. Click on the button provided on the sheet.

Download the attached Excel workbook to see how the customised progress bar works. To implement this in your project simply copy the form (frmProgress) and general module (modProgressBar). And then, you just need to call ShowProgress procedure like this

Call ShowProgress("Task 4", 10)  

Solution for Forum Ques on url:

http://excelexperts.com/vishesh-need-macro-help

Solution for problem asked in url: http://excelexperts.com/moving-data-rows-columns-depending-unique-conten...

Pls c attached sheet. I have tried to solve it using formula only (no macros as it would need more involvement).

Paste the following code in a general module and pass the required parameters to create an chart in a cell. This code however works with Excel 2007 onwards.

Paste the following code in any module and run the Test procedure

Sub Test()
    Call TransposeBack(Sheet1.Range("A3:D10"), Sheet1.Range("I1"))
End Sub
 
Sub TransposeBack(rngData As Range, rngTarget As Range)
    Dim rngHeader       As Range
    Dim rngId           As Range
    Dim rngCell         As Range
    Dim rngDest         As Range
    Dim lngRept         As Long
 
    Set rngDest = rngTarget.Offset(1)
 
    With rngData
        Set rngHeader = Intersect(.Rows(1), .Rows(1).O

Solution for problem posted on url:

http://excelexperts.com/automating-pulling-data-website

Please use the attached xl sheet. Change the symbol and click the button to see

DO NOT take first 3 characters from a month name to get an abbreviated month name. This can give you duplicate results in some languages as first 3 characters of two months may be same.
I have encountered this with the Czech language.

So, use the following:

If the month is 1 i.e. January

So, to get abbreviated month name ALWAYS use

Monthname(1, True)

This will always return standard abbreviated month name.