I've got the meat of my macro done, it takes data from a main log and spreads it to fund spreadsheets for a quick summary.
Account numbers coincide with the fund they are derived from.
For example. Fund 0995 account numbers must start with a 17XXX
Fund 0890 must start with a 101XX
Is there a way to write in VBA code that would produce an error if a 17XXX account was written with a 0890 account number and vice versa? Basically it would state, "Error: The following account number does not coincide with the fund provided."
Thanks in advance!
Bookmarks