data indexing macro

Originally Posted by ad9051

What changes do i need to make to make reference a sheet in a different workbook?

That opens a whole other can of worms.

1) Which of the two sheets referenced in the existing macro is in this "other workbook"?
2) What's the full path and name to this other workbook?
3) Should the macro check to see if the other workbook is even open?
4) If not open, it would need to open it, yes?
5) When the macro is done, it needs to close the other workbook if it was closed originally, yes?

This simple question adds a magnitude issues. Defensive coding....