Hi,
I'm looking for a solution to the following issue:
We currently run a report that has an NL replicator for sheets that creates a new sheet for every unique document number (going to refer to the table as DocHeader and field as No.)
=nl("Sheets","DocHeader", "No.")
(extra filter criteria omitted)
The table DocHeader also has a field called "Equipment ID" that I'd like to use as the reference for naming each of the replicated sheets.
Currently it grabs each "No." from DocHeader to use as the name of each sheet. To my understanding, I don't think there's a way to do this with Jet alone. Am I wrong in this? Probably asked before, but is there a way to do a Macro after the fact, or anything else, that could rename the sheets dynamically based on that "Equipment ID"? I would have the "Equipment ID" stored in the same cell on every sheet.
Regards,
Paul
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Try:
=nl("Sheets","DocHeader", "=NF(,""No."")&""-""&NF(,""Equipment ID""))
If you still need the No. to do other stuff with on the sheet you could use excel text formulae to split it out again (eg a combination of find and left). -
Jet Reports Historic Posts Thans for that, truly helpful.
Please sign in to leave a comment.