My first query..

I have 2 excel Workbooks. Need to copy data from one to another based on the condition getting satisfied. Below are the details.

Source excel has 5 worksheets. I need to do the following for each worksheet. If value in a cell of column P is "#N/A" then the corresponding row's value from column J should be picked up and pasted into another workbook's worskhseet. Again the target workbook has many worksheets.

For the source, my headers are till row 6. So values to be checked start from P7. In the target my headers are till row 2. So forst cell available for pasting is A3.