完了

Excel tweak

elqueabandona$150 USDのためにこのプロジェクトを1日で完了しました。

このようなプロジェクトの無料見積もりを取得
作業中の採用者
プロジェクト予算
$30 - $250 USD
完了にかかった期間
1日
入札合計
13
プロジェクト情報

Sheet 1 (Order Form) - Column H19 Postcodes

When the customer fills in a postcode in this column, it automatically populates with a value in Sheet 2 (Office Use – Do Not Edit) Column AC Shipping Method, based on the postcode ranges in Sheet 4 (Postcodes).

Sheet 1 (Order Form) also has a hidden drop down in cell L16 that defaults to Standard but can change to Express. This will change the value in Sheet 2 (Office Use – Do Not Edit) Column AC Shipping Method. When the value in drop down L16 is changed AFTER the postcodes have been entered, the values in Sheet 2 do not currently automatically change but they need to.

When a customer copies and pastes the postcodes into column H19 this does not populate or change the values in Sheet 2. When the postcodes are deleted in Sheet 1, the values in Sheet 2 remain.

It seems that the values only come up correctly in Sheet 2 (Office Use – Do Not Edit) Column AC Shipping Method when the postcodes are directly entered for the first time.

There needs to be a better link between the postcodes in Sheet 1 and the result in Sheet 2.

This form is for bulk orders, with Sheet 2 being converted into a csv and uploaded into our system. I am open to any other suggestions to make this form more user-friendly!

以下の方によって完了済み:
必要なスキル

お金を稼ぎたいと思っていますか?

  • 予算と期限を設定してください
  • 提案のアウトラインを作成してください
  • 仕事の報酬を受け取りましょう

このプロジェクトにも入札したフリーランサーを採用する

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online