Ability to sort by Sheet, Columns, Within those columns, and Operations on Info

[TopC1]

Sorry ahead of time if the title wasn't able to convey exactly what i'm going for, but in further detail...

I have 8 sheets, 1 i'm wanting desired information to be displayed on, the other 7 are for data to be entered. What i need is the ability to get the desired information (which changes) from the other 7 sheets (whcih are updated continiously) and after determining which sheets its looking at, to determine which columns in those sheets, and then what restrcitions its using to grab information from within those columns..

example, i need information from sheets 3 and 5, but only between x and y dates.

Now that information has been sorted to the appropriate ones, perform calculations on said information, average, deviation, as well as create a graph...

Uploaded current file for visual of what im trying to accomplish. The 'search' form is the visual framework for the search filters which is Sheet, and column w/in said sheets.


possible?


Thanks in advance for any assistance on where to even start with this!

[JBeaucaire]

A sample sheet with no sample data and a sample "results" sheet with no sample "results" is of minimal use.

Without doing it for you, on the DISPLAY sheet you should have same TO/FROM date cells, a way to indicate which sheets to use (perhaps by name and "x") and the standard headers used on the other sheets.

Then you can use an AUTOFILTER macro to cycle through each selected sheet, apply an AUTOFILTER on column A using the dates given, copy the visible data into the report, then repeat with each worksheet.

[TopC1]

A sample sheet with no sample data and a sample "results" sheet with no sample "results" is of minimal use.

All of the data being entered is numerical or a date

Without doing it for you, on the DISPLAY sheet you should have same TO/FROM date cells, a way to indicate which sheets to use (perhaps by name and "x") and the standard headers used on the other sheets.

There is a form already created (no code of course) that has selection options for filtering, it is titled search. Check boxes to select sheet, Start date and End date to get a range of dates. Also a Bit # option which is a numerical value that will be in column 3 of every sheet.

Then you can use an AUTOFILTER macro to cycle through each selected sheet, apply an AUTOFILTER on column A using the dates given, copy the visible data into the report, then repeat with each worksheet.

Yes, i'm able to reach the desired end result with just macros and have already made a temp file for the time being sorting it that way, but i was really interested in seeing if there was a way to perform the actions using a form instead of just using cells on the spreadsheet itself?

[TopC1]

Should i post one with sample data in it? or is no help for the problem?

[StephenR]

A good sample workbook always helps.

[TopC1]

Ok instead of doing multiple sheets, opted to just sort by producer number so all data will just be entered on 1 sheet to make it easier to filter... i can get filters set up, i just dont know how to get VB to use filters. As well as getting a form set up for the search parameters

[StephenR]

I don't really understand why you need VBA. If you want to query bits of data much easier to use AutoFilter, or even Advanced Filter.

Why do you need a form?

[TopC1]

I don't NEED to use a form, but i'd really like to since i feel it looks nicer when its all said adn done. As well as I'd really like to learn how to do it

[StephenR]

Maybe this will get you started. It only checks the Bit # field. I don't know what the others relate to. Assign this to the search button.

Private Sub CommandButton1_Click()

Dim rData As Range

Application.ScreenUpdating = False

With ActiveSheet
    .AutoFilterMode = False
    If Me.TextBox3.Value <> "" Then
        .Range("A3").AutoFilter Field:=4, Criteria1:=Me.TextBox3.Value
        With .AutoFilter.Range
            On Error Resume Next
            Set rData = .SpecialCells(xlCellTypeVisible)
            On Error GoTo 0
            If Not rData Is Nothing Then
                Sheets("Display").UsedRange.Clear
                rData.Copy Sheets("Display").Range("A1")
            End If
        End With
        .AutoFilterMode = False
    End If
End With

Unload Search
Sheets("Display").Activate

Application.ScreenUpdating = True

End Sub

[TopC1]

Thanks for getting me started!! Sorry i forgot to explain the options in the form >.< silly me! The check boxes on the left side are the producers and each has a corresponding producer number. And just wanna be able to sort the date column dates between xx/xx/xx> entries > xx/xx/xx