My name is***** will help you too the best of my ability. The best thing that you can do is wipe, what information they don't need from the workbook and send it too her as a attachment in a email. You can also, type a set of instructions in a document and proceed too do the same thing.
Yes, cause, you are actually, writing a section of vb too that worksheet. You can send her that section of code and should work if there are no issues on there end.
I am not in depth familiar with how macro's are so I can not say.
I'm not sure if you can easily, declare a variable like that. You will likely have too do this in VB and say something like A1 - A5 add them together and if cell A6 < 5 this will happen else A6 > = this will happen
That is defiantly, a older programming language. It's kind of using basic logic and things that you should know in excel formula's. Probably, the best too figure it out is google what parts your unsure of, like how too add a row of columns in excel. I don't know of any online books, that would explain it but, you could also, try youtube