Hi
Thanks for your response. The workbooks are large, 15MB and being new to this I don't know how to get them to you. I have done to screen shots though.
The Transaction page is the one that I want to make into 2 workbooks, 'Sales' and 'Purchases'. The stock record shows the formulae that I use to lookup data from the Transactions page.
A 'Transaction Number' from either the 'Sales Transaction Workbook' or the 'Purchases Workbook' will be copied into the 'Sales Record'
I want to change the formulae in the 'Sales Record' so that it will find a unique Transaction Number in either the 'Sales Transaction Workbook' or the 'Purchases Workbook'
Perhaps there is a 'Work Around' that will do the same job.
Thanks for your help

Attached Images

	Stock Record.jpg (238.8 KB, 15 views)
	Transaction page.jpg (282.3 KB, 15 views)