Dependent on drop down list column will change

**shaf1234** · 03-14-2013, 06:30 AM

Hi all,

Very new to this, anyway.

I have 3 options on the drop-down list.
If I choose option 1, I want a column to change to replicate a column on sheet 2,
Same with option 2 and 3.

The same column needs to change in sheet 1 relevant to the drop down list which is related to the column on sheet 2.

I have attached the spreadsheet I am working on.
Column E on sales Form needs to change according to whats chosen in cell B15 on sheet sales form.
The change is on sheet 1.
So if i choose "delivery note" the data should update from column B in sheet 1
"Sale Order Request Form / Purchase Order" use column C and so on.

Hope someone can help.

Thanks in Advance.

**vinodhec** · 03-14-2013, 06:58 AM

New Sales Order_Template v3_Vinodh.xlsmHi please find the attached.

Please let me know if you want different solution.

Regards,
Vinodh.T, Erode

**shaf1234** · 03-14-2013, 07:04 AM

WOW, thanks vindohec, but what did you do??

**vinodhec** · 03-14-2013, 07:06 AM

Just made it using a macro to copy paste based on the value.
If you feel i have solved your query please give a star, it will encourage me to help others.
and mark it as solved.

Thanks,
Vinodh.T, Erode City, India

**shaf1234** · 03-14-2013, 07:12 AM

Thanks I will, but how do I view your MACRO, and when i choose samples i get a box which says hi. lol

**vinodhec** · 03-14-2013, 07:15 AM

:-D I forgot to remove that message box. which i used to test whether the control is going to respective case.

Right click on the sheet click view code, you can see the code. and just remove the msgbox "hi". :-)
By the way this is code

Please Login or Register  to view this content.

**shaf1234** · 03-14-2013, 07:29 AM

Thanks for that much appreciated and you have received a star, far less than you deserve, keep up the good work.

**vinodhec** · 03-14-2013, 07:39 AM

Originally Posted by shaf1234

Thanks for that much appreciated and you have received a star, far less than you deserve, keep up the good work.

Thank you very much for your kind words,

Vinodh.T,
Erode City,
India.

**shaf1234** · 03-14-2013, 08:42 AM

No Problem, anyway just to update you, I couldn't use the macro. When I use the sales order form with the unit prices in, it then needs to change to a delivery note, which I am not allowed to do as the rows have been changed. I have a macro which deletes empty rows.

I have resolved this by using Hlookup, i have number my rows in accordance to the rows on sheet one. This has solved my issue.
But thanks again.