help, Extracting words from string and populating identical data in different form

Hi


I want to improve a current process ( file attached )

The process begins by exporting data from SAP and posting the data into the (outstanding tab), where you then take the GL balance and make it rec.

Then an export from K8 occurs where you have to then manually look for the depot and where the depot is sending the cash (K8 tab).

So flicking between the two manually going through on the outstanding tab and filling in the depot using the K8 information.

Sometimes when a depot does more then 1 entry and k8 will show this however SAP wont and a split has to occur where you split the cost down breaking it up into entries.

e.g
SAP-
bradford 1400

K8-
bradford to alton 1000
bradford to charlton 400

I want to be able to export the data from k8 and for there to be some way where it will work it out its self.


I have given it a go using formulas to export the depot name on k8, but need to somehow feed it into the outstanding and also when a split occurs how to deal with that.


Any ideas or suggestions please let me know.



Thanks

Originally Posted by xladept

Hi edmondsr,

Can you post a relevant example? Bradford isn't on either the K8 or the SAP tab

The depots on the k8 download will match the sap download, the k8 has been split where as the sap is the amount as a whole,


Thanks