look to the data matched with date in specific cell

[mazan2010]

dear All
i would like to macro code that look to date in range starting from B8:end of sheet
as in attendance sheet with date in B3 then copy only data from column starting A9 that only have present value in this date
to sheet1
then copy data in B1,2,3,4,5,6,7 to sheet1 as in my attached file

[sktneer]

Try this...

Please Login or Register  to view this content.

[mazan2010]

Dear sktneer
its work good many thanks for your help
can add to this code option that give message to delete previous data in sheet1 before adding new data or other option do you want to add to previous datya in sheet1
i mean two option
first one add new data to the current data
second clear previous data first then add new data
in both option give confirmation message

Try this...

Please Login or Register  to view this content.

[sktneer]

Then try this...

Please Login or Register  to view this content.

[mazan2010]

many thanks Dear sktneer
its work good now

[mazan2010]

do you know how can make the following code show in datepicker today as default

[sktneer]

You're welcome!

Please open a new question with your new requirement.

If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.