Creating a List that updates automatically on one sheet, using Data from another sheet.

[benslaw]

Hi all, seeking some more novice advice

I need to create a list that will automatically update using data from another sheet. Also, I need the list to be generated using data in one cell, but displaying information in another cell (in the same row) for the list itself.

IE

I have a client list as my main worksheet with a statistics sheet. I need the list to generate on the statistics sheet using data found in column H in the client list worksheet but displaying the data in column A of the client list worksheet, for the list itself.

If anyone is able to help it would be greatly appreciated Thanks guys!

[FDibbins]

i would suggest you include in your sample work book, some examples of what your expected outcome is, and how you arrived at that

[benslaw]

Sorry, thought it was a bit easier to understand. Here is something that should be clearer.