Moving Large amounts of Data from one page to another, by a Name

[Icecup]

Some back ground on the project I am working on: I have an electronic manual that needs to be changed. In the electronic manual there are Catagories that people click on and that navagates them to another page where a list of documents can be found. The issue is the Catagories are terrible. So now in an excel file I have all the documents listed in the left hand column, then the next 3 columns I have the new Catagories (Titles).

What I need excel to do, is in a new sheet I need to be able to type the new titltes (there are roughly 25 of them) and have all of the documents come over into the new sheet with them. How would I accomplish this?

I was trying to find a way to do it with the Name function or with linking cells but no dice. Could I use Vlookup? I have attached a sample of what I have described to make it easier to understand.Help with Excel.xlsx

[FDibbins]

Hi and welcome to the forum

If your intent is to type in a "contents in title" and then have the rest of the cell data filled in for you, try this...

Sheet2

	A	B	C	D
1	Contents in titles	Title	Title	Title
2	A/C Warranty - Claiming Refrigerant	Technical Information (How To)	Product Knowledge	0

B2=INDEX(Sheet1!$C$2:$E$11,MATCH(Sheet2!$A2,Sheet1!$B$2:$B$11,0),COLUMN(A$1)) copied across

[Icecup]

error message.PNGThank you for the responce. When enter in that formula I get an error message about Circular Ref Warning. I have attached a picture of the warning to this thread. When I click ok my output is zero.