Priya

It appears people are not interested in replying because the question you have raised is complex and we don't think we would learn much in doing your work for you. I believe you would have more luck if you broke this down into smaller chunks and made some initial attempts at modifying existing code you can find on this and other forums that could be adapted. Post those attempts at smaller pieces of the puzzle and I'm pretty sure people would step up and help out.

You haven't specified where all these input and output documents are coming from - how does the macro determine what are the input docs and where is the output doc? Are all these documents already open or do they get opened/closed by the macro.

Once you have the relevant input/output documents sorted, how do you identify the relevant source and target tables? Then how do you identify the relevant cells? Are you replacing the entire cell to the target cell or appending text?

What is the iteration process for the subsequent input docs?

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia