Hi


a sample wbook would help

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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)