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.
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.