Copy data based on column header in a table to a new location

[karthik.jaish]

I need to copy data from a column in a table and paste it to a specific column, based on the

Ex Table: J1:S8

Header reference at cell C3, which is inturn dependent on the dropdown from the dashboad page.

Now the moment the dropdown is selected in the "dashboard" worksheet it changes the value at Cell C3 in the "Calc" worksheet.

Now depending on the C3 value the macro should find out the column and get the column values (except the header) and paste it from G4 in "Calc" worksheet.

Thanks,
KarthikAttachment 455195Attachment 455196

Please need help!

[Akuini]

Could you attach your workbook (without sensitive data).
If you find any trouble to use attachment, please read this info:
http://www.excelforum.com/showthread.php?t=1128657

[karthik.jaish]

someone please help

[Akuini]

Hi, Karthik
I've downloaded the workbook.
I have to change the combobox to activex combobox because it's easier to use with vba.
I don't know whether the change is suited to your need or not.
Try this. Let me know if you encounter any problem or needs some explanation about the macro.

Please Login or Register  to view this content.

This is the workbook: