VBA copy paste a selection then find the current date and copy this selection row 61

Hi

Originally Posted by woocaro

....
I have a workbook with my macros
I want to get the updated information from another file sheet "raw"
open this file
then copy from raw sheet selection B1:B87 (this is fixed all the time)
then search my variable (Current_Date) in my open workbook in "Daily Input" sheet (has multiple daily columns, on top daily date (2015-09-10) and under in rows all the data i need to copy paste from the other file.
But need to copy the selection B1:B87 under the Current_date to row 61 to 147.......

Although you have explained well, . It would be much easier for someone trying to help if you give a clear picture ( Not IMAGES ) of what you have before and what you want after with reduced test data.

. So simply provide a clear before and after ... ( For example a "Before" and "After" sheet in an Excel File )

To summarise.

. The Before or Befores, should look just as it / they does before running of any macro.
.
. The After or Afters, should be hand filled by you so that it they / looks exactly as you want it to After running of any macro, based on the actual sample data in the Before / or Befores
. Make sure there is just enough data to demonstrate your need. Remember to desensitize the data if necessary, but use the typical Format type and choose your data carefully so that it can be used to test all possible scenarios.
...

Alan

P.s. some ways to provide that info: ( Most people use . 2a )
. 1 ) use the Forum Tools in my signature to produce screen shots we can copy to a spreadsheet ( NO IMAGES ! )
. 2 ) Post Files
. 2 a) To Attach a sample workbook:
View Pic
http://www.excelforum.com/members/da...ch-a-file.html
http://tinyurl.com/oenwprw
. 2 b) Send over a file sharing site, such as this free thing
Box Net,
https://www.box.com/
http://tinyurl.com/7chr7u8
. Remember to select Share and give the link / links they give..

. 3 ) - Up left in the Thread editor is a Table icon. Click that, create an appropriately sized table and fill it in. (To get the table icon up in the Reply window you may need to click on the “Go Advanced” Button next to the Reply Button)

. 4) Only as a very last resort, P.M. me and i will reply with my Email Addressee so you can send me a file
** To PM me, click on my name in the left hand margin when you are logged in, the rest should be obvious.

Hi

Originally Posted by woocaro

Finally, i have asked one of the best guy here on vba,
he resolved my issue and i will let you know in the code...

Thanks for letting us know
Alan

P.s.

Please mark the Thread as solved, thanks

ThreadSolved.JPG