Copy data from one sheet to another sheet

[HaroonSid]

hi,
i have in data in sheet2, table1, header #Column5

data is in number like below
1.1.2017
2.1.2017
3.2.2017
12.11.2016

now what i need?

i want to popup a input box
i add some value like 1.1.2017
then macro search the value 1.1.2017 in sheet2, table1 and #column5

for example value 1.1.2017 found in column c2, c10, c15, c435, c436, c437, c525, c526
then copy above row range a2:j256 only visible cells

now count the visible row = row 8

now add new 8 row in sheet1 from a2

and paste it to sheet1 range a2 paste all

thanx alot
Hope you will understand, what i want?

[davesexcel]

What do you need help with?

https://www.youtube.com/watch?v=YRdpw7mn9-g

[HaroonSid]

Thanx for reply davesexcel

but my requirement is not going fullfill...


sorry

[HaroonSid]

because i am using a table
i want to instert new row to paste data

[davesexcel]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.