Excel tweak



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!

Навички: Excel

Показати більше: questions on excel prove it test, excel prove it test, excel prove it practice test, do canadian it companies directly hire indian, i need to come and meet you there because i love you so much translation in spanish, it skills wanted part time graduate programming, i have an excel spreadsheet that needs some final touches to be ready i need an absolute expert at working an excel, i have a html email template i have need a expert who make it responsive for pc tablet and mobile need complete it today after t, user friendly gui excel, excel tweak template, part time data worker need, user friendly front end excel, create user friendly front end excel, php upload time remain, excel stock price graph macro real time, Copy Paste Excel, convert excel file address book, excel sheet cities world, client database excel, excel template service, customxml excel, creation excel file, excel keyword, office excel time management, excel macro fill empty cells

ID проекту: #11772506



Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega Більше

$150 USD за 1 день
(130 відгуків(-и))