В работе

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 excel prove test, excel prove test, excel prove practice test, user friendly gui excel, excel tweak template, php upload time remain, copy paste excel, excel sheet cities world, client database excel, excel template service, customxml excel, creation excel file, excel keyword, office excel time management, macro excel cells, differences excel files, php excel pdf, excel vba xml

О работодателе:
( 2 отзыв(-а, -ов) ) Regents Park, Australia

ID проекта: #11772506

Поручено:

elqueabandona

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 отзывов(-а) )
6.4

13 фрилансеров(-а) подали заявки на эту работу; средняя заявка - $93

P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$150 USD за 2 дней(-я)
(99 отзывов(-а))
6.2
rengrish

Hi , I can provide you solution within 1 hours. Went through the description completely. I have 10+ years of experience in Excel & VBA. Please check my past reviews and ratings. Please ping back to discuss the re Больше

$77 USD за 0 дней(-я)
(112 отзывов(-а))
5.7
$100 USD за 3 дней(-я)
(116 отзывов(-а))
5.5
vlayausa

Hey, this looks familiar! :) I believe I wrote this macro that you use. I will be glad to help you make modifications in my code. Please contact me to clarify what exactly do you need. I am sure we can do it Больше

$35 USD за 1 день
(66 отзывов(-а))
5.0
abdolah2014

HI I am an excel-vba Expert and I can finish your project so fast pm me I am ready to start ........................................................................................

$55 USD за 3 дней(-я)
(27 отзывов(-а))
5.0
royalcalif

Hi Mr. Employer I have lot of experience in excel spreadsheet and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Excel . https://yout Больше

$120 USD за 3 дней(-я)
(12 отзывов(-а))
3.6
TulyakovN

Hello. Understand, how to do this job. Skills in VBA, experiance of working in word, excel, access. No problem with this job and those tasks from discription.

$50 USD за 5 дней(-я)
(5 отзывов(-а))
2.9
Arouss

hello sir, I can do you excel work I am very good at excel, contact I am available now

$35 USD за 2 дней(-я)
(1 отзыв)
0.5
metcan185

Actually, I find it hard to explain a life with certain word that can sum up their own life, their own ideas with a set of words. In this letter I will try to explain my motives for becoming a freelancer. I'd love to b Больше

$111 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
russelgazipur

DEAR HIRING MANAGER, I READ THROUGH THE JOB DETAILS EXTREMELY CAREFULLY AND I AM ABSOLUTELY SURE THAT I CAN DO THE PROJECT VERY WELL. I HAVE WORKED ON SIMILAR PROJECTS TO WHAT YOU ARE LOOKING FOR. I AM CONFIDENT I C Больше

$67 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
wsfuhrman

Hello, My name is William Fuhrman. I'm currently studying Business Management and Computer Science at Michigan State University. I have a vast amount of knowledge in Excel and would love to help you out with your proj Больше

$100 USD за 1 день
(0 отзывов(-а))
0.0
asin1987

Dear Employer, I am an excel expert and I am here to help you with any and every excel query. Please share the work details and we can start the work at the earliest. If you are still not sure, I have 10 years of Больше

$155 USD за 3 дней(-я)
(0 отзывов(-а))
0.0