We need a excel macro to replace some manual steps on an import file. We need the following:
1) each line of an invoice starts with a 1 any other line for that invoice needs to be a 2 (this is in the first column).
2) I need a simple routine that removes partially defined text from a cell.
3) A column which automatically suggests a product code by doing a lookup (I use a vlookup) but if we can automate this then great.
I don't expect this to take very long I am happy to do a web demo and we will upload a file soon. We will require the source code and a small write up.