Dynamically Update Information from 1 sheet to another

[Steve0]

Hi,

I have a sheet No 1 with data and wish to copy that data to another sheet - No 2.

When I update Sheet 1 and I would like the information to be updated on Sheet 2.

I am trying to create a dashboard or chart on Sheet 2 that automatically updates when I update the information on Sheet 1.

Please could a kind soul advise me accordingly. Many thanks for the help

Stephen

[Pete_UK]

There are many ways of copying data from sheet1 to sheet2, but it is difficult to advise you exactly how to accomplish this as you have given no information about how your data is laid out in either sheet. Please attach a sample workbook, and explain in that what it is that you want to achieve.

Pete