Copy Entire column from different sheet if the column header matches the name based on dropdown

ssinha23

New Member
Joined
Aug 31, 2016
Messages
16
Hello I am trying to create a dynamic chart.

I have created the dropdown list, based on the column header names. Now I have all the raw data in a different sheet.
What I need is, if I select "Item A" from the drop down, it should go an search for "Item A" column header in the raw data sheet, copy the entire column and paste in designated column of the new sheet.
Idea is that everytime I select a new item from the dropdown, this column should get refreshed based on the data copied from the raw data with reference to the matching column header.
I will be using this data to create the dynamic chart.
Thanks in advance for your help.

** PLease note - I have tried out the offset formula, but that seems not to be working as I need the chart in a different sheet from the raw data sheet. Also this raw data is huge. No of columns is fixed. The first column is the daily date, and then onwards the item numbers for each column header on that respective date. I have a macro enabled that will be everyday adding a new row of data for a new date and respective date entry. So the raw data refreshes on a daily basis.
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

maabadi

Well-known Member
Joined
Oct 22, 2012
Messages
1,925
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
If your dropdown Cell is K1 & Your Data at A1:H10 then
Cell Formulas
RangeFormula
B2:H10B2="Item" & RIGHT(A2,LEN(A2)-4)*1+10
K2:K12K2=IFERROR(INDEX($A$1:$H$10,ROW(),MATCH($K$1,$A$1:$H$1,0)),"")
 

Watch MrExcel Video

Forum statistics

Threads
1,132,890
Messages
5,655,824
Members
418,239
Latest member
RSadler11

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top