Excel VBA to add data inputs of a selected date in databse sheet

[ahmedaseel]

Hello Everyone,

Hope you all safe, I would like to add some data in tab (Segments Data input) based in a selected date from drop down list. to be inserted -as values only without equations remained - in another tab in the same selected date (Segments Database).

I am trying to make a macro record but it contains copying the date and finding it in the other sheet, but unfortunately it is not capturing find activity.

the (Segments data input) sheet looks like this

and I need the data to be inserted in another sheet (Segments Database) looks like this

Thanks for your help

 

[mumps]

It's hard to work with a picture. It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your two sheets. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).