Macro to return data

[ramo114]

Hello helpers,

Thanks in advance for your help.

I have two tables (table 1 and table 2). Based on a drop down list, I want a macro that would copy and paste table 1 into table 4 and table 2 into table 5 at one go. Table 4 depends on the itemcode in cell Q2 while table 5 depends on groupcode in cell Q3 which depends on cell Q2.

[MrChulo]

Hello ramo,

I think the help I provided you with the other day should suffice as guidance. You should be able to create what you need from that.

Specifically "based on a dropdown list" just mean in VBA the worksheet_change event, same as we used in that other example. Adjust the Target.column and Target.row to cover the dropdown and apply the same type of code I have given you..

You can easily have to different checks in a Worksheet_Change event, like so:

Please Login or Register  to view this content.