VBA find empty row in closed workbook

Hi Norie

Apologies for my delayed response

I want the other workbook to be where data is stored outside the other workbook. Essentially, the first workbook does all sorts of formulas and workings-out, which are then taken, and transferred into a table into the other workbook (like an audit trail of whats being worked-out)

I don't want it in the same workbook as i don't want people to see the history

It's hard to explain without knowing the history of why. But if this is at all possible it would be ideal


I hope that makes sense?