Extracting Data from Sheet to Sheet

[323100N]

Good day,

I have this Monthly Reporting sheet and I want to eliminate manual data scraping from RawData to specific date range.

1. Extract all data depending on Start Date and End Date in Macro Tab

Thank you.

Please see attached file for references.

[BellyGas]

You may have attached the wrong workbook as that one doesn't have a VBA project attached to it. At the very least we're going to need to see your code in order to offer advice.

If you haven't written any code yet please start here: https://www.excelforum.com/excel-pro...materials.html

[323100N]

You may have attached the wrong workbook as that one doesn't have a VBA project attached to it. At the very least we're going to need to see your code in order to offer advice.

If you haven't written any code yet please start here: https://www.excelforum.com/excel-pro...materials.html

Thank you for the references, I have attached updated workbook with code that I found in google but I cannot extract all the information needed in the RawData. Only the header was extracted from the RawData.

[Anupam Preeti]

Hi,

I need to read multiple Dat files and serach for particular text from the list captured into one excel sheet . If match is not found I need to capture file name for that dat file.

Could some one pls help .

[BellyGas]

Anupam, you're going to need to start a new thread for your request.

[alansidman]

@Anupam Preeti
Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

[323100N]

any idea guys?

[JeteMc]

If a formula based solution is acceptable you might try the following, as modeled on Sheet3:
1. Populate A5 and down using:

=IFERROR(INDEX(Table1[Client Name],AGGREGATE(15,6,(ROW(Table1[Client Name])-MIN(ROW(Table1[Client Name]))+1)/(Table1[Due Date]>=$B$1)/(Table1[Due Date]<=$B$2),ROWS($A$1:$A1))),"")

2. Populate columns B: (starting with row 5) using: =IF($A5="","",INDEX(Table1[Pipeline Description],MATCH($A5,Table1[[Client Name]:[Client Name]],0)))
Note that zero values are hidden using conditional formatting.
Note that some columns containing dates need to be formatted as such.
Note that this proposal assumes 'Client Names' are unique and selection of rows should be based on 'Due Date'.
Let us know if you have any questions.

[jindon]

vba

Sub Button1_Click()
    With Sheets("RawData").ListObjects("Table1")
        .Range.AutoFilter Field:=23, Criteria1:=">=" & Sheets("macro").[j8], _
                    Operator:=xlAnd, Criteria2:="<=" & Sheets("macro").[j9]
        .Range.SpecialCells(12).Copy Sheets.Add.Cells(1)
        .AutoFilter.ShowAllData
    End With
End Sub

[323100N]

Both works perfectly, Thank you!

[JeteMc]

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.