Jan Kalop
Active Member
- Joined
- Aug 3, 2012
- Messages
- 389
I have worksheet (DATE) with a lot dates and related data. To find specific values, in cell I2 I enter date which is use to generatate in cell K5 that specialy search value which depends on the entered date. Most of the time I need to go through search quite a lot of dates which are listed daily in Column Y2:Y100 and I would like to copy and paste that value from cell K5 to cells in Column Z? , next to related date. Instead doing that with many macro specialy created for each induvidual entry I would like to have one macro to be able to do that automaticly every time i clik on single macro button. To avoid manually enter each date I have automated that with Combo Box (ActiveX Control). Please help because with single Copy & Paste I have no problem but in that scenario I hit the wall. I realize that, the solution would be very useful in many other occasions.
Thankyou....
Thankyou....