Copy paste specific row of data based on user input

Hello,

I am new to VBA and I need to copy and paste the specific dates from the specific city that the user will insert in the "dash" sheet.
Basically, I need the macro to read the city and range of dates that the user will type into the "dash" sheet and copy the columns "AA" to "AD" from rows specified by the dates input. Once it has been copied, it has to be special pasted just the value onto the sheet "1" beginning at location B2.

Please note, the the data will not be available as it is vlookups to another excel sheet that i have not provided. I have deleted the data, but you can pretty much put 1's everywhere.

Thank you very much!

Hi Solus,

Thank you so much for the quick reply. I have put this code in but it does not seem to work. Is there a specific format that I need to type for the dates to work? There is also seems to be an error in the line .Range(Cells(rng1.Row, "AA"), Cells(rng2.Row, "AD")).Copy

thank you so much for your time!

Hi Solus,


It now works! However, is there anyway for the macro to work starting from the "dash" sheet? It seems to only work when you place it on the given sheet"city" and run the macro. The reason i ask is because I want to put a button on the "dash' sheet, and link it to your macro.

Thank you so much!

Here it is...when i run it, it only seems to work when i am on the specific city...If i am on the dash, I get an error....

Thank you!

Hello again

I was playing around with your code, but cannot see to figure it out. It seems to copy column B to column AD. Is there anyway it copies from column B to column CA? I have to add more raw data that takes up more columns.

Thanks!