VBA code for copy of information based on a date criteria

[Andries]

Hi

I need some help with VBA. I am new to this so I am trying. I have a sheet with 10 columns and 3000 rows. The first column contains dates.
What the code should do is to look at what date is entered in the textbox or inputbox on sheet1 and it should then extract(copy) the information (from sheet2) that is only relevant to that specific date and paste it into sheet1.

Thank you in advance
Dries
South Africa

 

[VoG]

Have you tried recording a macro whilst AutoFiltering and copying?

 

[Andries]

Hi

I'll try and let you know

 

[Andries]

Hi

Thanks it is working perfectly. Next question...what is the code for hiding and unhiding a sheet?

 

[VoG]

Select from these

ActiveSheet.Visible = xlSheetVisible
ActiveSheet.Visible = xlSheetHidden
ActiveSheet.Visible = xlSheetVeryHidden

 

[Andries]

My ActiveSheet is called "data2"...how do I re-write the code to unhide and hide again. Obviously the macro does not work if the sheet is hidden

Sheets("Request Form").Select
Sheets("Request Form").Range("A11:J10000").Select
Selection.copy
Sheets("data2").Select
Range("e2").Select
ActiveSheet.Paste

 

[VoG]

Try this

Sheets("Request Form").Range("A11:J10000").Copy Destination:=Sheets("data2").Range("E2")

 

[Andries]

I thank you...it is alive!