Formula/Macro that populates cells based on criteria

Hello everyone, hope you are all doing well. I have been a long time lurker here and have learned quite a lot from these forums

Here is my question:

In the attached file, I want the button in the 'Input' sheet to populate rows in the 'Database' sheet based on the date.
Ideally, I'd want to transpose paste the values because the column headings in the Database sheet will not be exactly the same as those in the input.
For now to make it easier to understand, I've left them as A,B,C,D..etc.

Thanks in advance

Forgot to attach to original post.

Please help

Someone?
This is a major roadblock for me.

This is the current code:


Sub Macro1()
'
' Macro1 Macro
'

'
Range("C6:C13").Select
Selection.Copy
Sheets("Database").Select
Range("C8").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=True
Sheets("Input").Select
Range("D13").Select
Application.CutCopyMode = False
Range("C13").Select
End Sub


As you can see, it only pastes the values. I need to add a few lines which enable it to paste based on the contents of cell C5 in 'Input' and match it to one of the rows in column B in 'Database'

In case someone has the same problem, here is the solution:

http://stackoverflow.com/questions/3...ed-on-criteria