Restrict Worksheet database instances?

[Kizza]

I would like to add project name and project date as a header to my sheet list worksheet. My sheet list worksheet displays sheet number and sheet name only. This info is pulled from my title block.

Problem is, if I pull the project name and date from the title block also, I will get multiple instances of it depending on the number of sheets.

So is there a way of pulling just one instance of the project name and date and adding it to my sheet list?

i.e. edit the formula to only return one instance?

[Hippocode]

No you can't.

Just create a script to save the string into cell A1 instead.

Edited August 11, 2014 by hippothamus

[michaelk]

Actually, in this case I think you can.

The project ID and project name can go in their own database. Because they are the same for every sheet, you can sum them to get only one instance.

It looks ugly, but for this example I tacked on a "project date". First I added the P_ field in the record format, then added it to the worksheet. It's different from the date that is already in the record format: That one can be different on every sheet.

Even if the data wasn't identical, I think you could add L=A101 to the criteria to only get the first sheet and avoid duplicates?.

hth

mk

[Kizza]

MK, any chance of a 2012 file?

[michaelk]

Yep!

[michaelk]

Here's another way of doing it, using L=A101 in the criteria and making 3 databases to capture the project id, date, and name.

hth

mk

[Kizza]

Option 2 - that's nailed it. Thanks very much for that.