Update Customer Canvas

Slutfört Publicerat 5 år sedan Betalades vid leverans
Slutfört Betalades vid leverans

I would like to have a button on Performance Plot tab for importing data into the Performance Table from a separate input sheet called "CT". The order of the data in the input sheet left-to-right will be the same as the order in the Performance Table top-to-bottom.

The user is required to match up the number of rows in the Performance Table with the Columns in the input file. Don't import the data and show a warning message when they do not match.

The performance rating for the Customer Benefits are included in column A of the input sheet. The rating is at the end of the text string. For example, ?:05-VH should be translated into VH. For each product, there is a 1 in the row of the rating. The order of the Customer Benefits in the input sheet will match the order of the benefits in the Performance Table.

The import macro should overwrite all of the data in the Performance Table with the data in the input sheet. When you press the Import Data button, you should be prompted with a question that asks if you are sure you want to import new data and erase all existing data.

Excel Macros

Projekt-id: #17214498

About the project

3 offerter Distansprojekt Aktivt 5 år sedan

Tilldelades:

$30 USD inom 3 dagar
(9 omdömen)
0.0