Creating a summary document

[abster]

Hi,

I'm sorry this is probably a stupid question.....

I have several worksheets, all with common column headings (Name, DOB, Address, customer number etc) and then some list specific columns (hence the need for different sheets). I would like to create a summary list of all the text data within the common headings, but not sure I know of a possible way to do this. Can anyone help?

I've tried Access as well, but my knowledge of that is even worse than my excel skills, but I'm willing to keep trying if someone tells me I can do what I need in there!

Thanks in advance

 

[AliGW]

Welcome to the forum!

Firstly, you'll be glad to know that there is no such thing as a stupid question. Secondly, does your dataset have a column with a unique identifier? If so, then a simple VLOOKUP or INDEX MATCH should do what you want. We'd need to see the layout and what your intended outcomes are to advise further.