match cell value with work sheet

[spmurphy]

I am in need of a VBA code that will search Column “D” starting with cell D2, and match cell values with work sheet name. The sheet that needs to be searched is named “all”. The entire row will need to be copied to the sheet. If the work sheet does not exist, it will need to be created. The header is on sheet the called “All” row 1. Also, each sheet needs column “A” starting with cell “A2” for duplication. If they have duplicate values, delete the row.

 

[vletm]

1) You wrote that's good.
2) You would like (in need) to get something.
3) You need a VBA code but
You wrote to 'Ask an Excel Question'
4) Please, try to reread that Tip: above ...
Upload a Sample File to get a quicker response.
5) You could add wanted result to the Sample File.
> Ideas? Questions?

 

[spmurphy]

Here is a sample file. I would like column D cell vales search for worksheets with the same names, and copy and past the entire row past on that sheet. i will be adding data to this sheet. So, after the code copies and past. it will have to search column A on each sheet for duplicate values.


▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !

​

 

[vletm]

Something like this after press [Do it] ?