So, I little backstory.
My work asked for people who were good at Excel to come forward as they had a project that needed doing. I came forward knowing that I am above average on excel. I've done some database work and some general VBA codes to extract data onto a different sheet but they're now asking for something that I've got no idea how to do.
So I've got Raw Data that covers columns up to M with over 4000 separate rows worth of information. All of the rows are financial services account information generated by around 70+ financial advisers and work have requested a program where you can input a date range, choose 1 of the advisers names, choose an account status (All, Completed, Application Submitted etc) and at a click of a button it extracts all application data for that adviser between the two date ranges. They want this on a separate sheet.
I've done some fiddling and some Googling but all I've got so far is this -
But it isn't working at all as I've got no idea on how to get the VBA to look up the to and from date range.
My work asked for people who were good at Excel to come forward as they had a project that needed doing. I came forward knowing that I am above average on excel. I've done some database work and some general VBA codes to extract data onto a different sheet but they're now asking for something that I've got no idea how to do.
So I've got Raw Data that covers columns up to M with over 4000 separate rows worth of information. All of the rows are financial services account information generated by around 70+ financial advisers and work have requested a program where you can input a date range, choose 1 of the advisers names, choose an account status (All, Completed, Application Submitted etc) and at a click of a button it extracts all application data for that adviser between the two date ranges. They want this on a separate sheet.
I've done some fiddling and some Googling but all I've got so far is this -
VBA Code:
Sub CopyandFilter()
Worksheets("Raw Data Sheet").Activate
Range("A1").AutoFilter Field:=13, Criteria1:=
Selection.CurrentRegion.Select
Selection.Copy
Worksheets("KFI Data Only").Activate
ActiveSheet.Paste
Columns.AutoFit
Rows("1:1").Font.Bold = True
Worksheets("Raw Data Sheet").Activate
Sheet1.ShowAllData
Range("E23").Select
End Sub
But it isn't working at all as I've got no idea on how to get the VBA to look up the to and from date range.
Last edited by a moderator: