This post has been de-listed (Author was flagged for spam)
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
1
How do I list sheets containing a certain value?
Post Flair (click to view more posts with a particular flair)
Post Body
Hi, I am currently creating an excel file that has multiple sheets. I have a summary page that I want to automatically list any pages that have certain data within.
Each page is basically a list of requested work at different locations, with a drop down at the end with 5 options along the lines of: requested, quote received, submitted, accepted, complete. So I want to make the summary page to list any sheets with one of these values along with the value.
Any suggestions?
Post Details
We try to extract some basic information from the post title. This is not
always successful or accurate, please use your best judgement and compare
these values to the post title and body for confirmation.
- Posted
- 3 years ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/excel/comme...