|
|
|
|
|
by zentiggr
2001 days ago
|
|
It sounds like you missed the point of GP's post. He was talking about avoiding manual weekly data copy-paste errors by writing code to do it in a predictable format. I think you assumed that they meant the code would never have to be changed again, when they were actually talking about being able to standardize the data update process. I don't think they said anything about never having to change the code, just that running a software process saves each user from manually pasting data every week. |
|
However, if you, or bash-j, believe Excel is incapable of avoiding manual data updates, that's simply not correct. Excel provides at least 3 ways of bypassing manual data entry in favor of automated imports from an external data source -- VBA code, ODC (not to be confused with ODBC) data connection definitions, and PowerQuery (I think that is the current name, haven't used it in a long time).