Hello,
I'm experienced business analyst for the worlds 3rd largest wholesale company, so this kind of Excel task is my daily work.
I need to just check with you few things:
1- do you use new version of Excel or not?
2- will you be using this macro on MacBook or just on Win computers? (writing code for Mac is little different)
3- Data for this Excel is manually entered or is it from some kind of data source?
4- Did you consider to change design of worksheet? I think that it can be a huge step forward, if we change it a bit.
I need all this info in order to estimate scope of work needed.
Hope to here from you,
BR,
Dusan