Hello,

I am trying to copy/create new worksheets that pull all the unique values from a column and use as the new page name. On each sheet I need the graph to move as well.

I have attached an example where all the data is added in & the graph is updated. (All sheet). I would like to copy 3 new sheets one for each of the currencies (USD,EUR,GBP) with the data for that sheet and the graph is updated with the corresponding values for the currency.

Any help would be greatly appreciated.

ThanksTest File.xlsx