tinkertron
Board Regular
- Joined
- Aug 4, 2009
- Messages
- 80
I will try to best explain as good as I can. In sheet1 i do data entries. In column Q which I keep hidden, but unhide when I need to view it, I have a formula in colm Q that reads from abunch other colms to get the output that i'm looking for.
Alot of people have asked why then do I have the Q colm hidden. Well all I can say is that my database spreadsheet is large. If I go any smaller then you would need magnifying glass.
So here's my question. Can I make another sheet that will filter whats on sheet1?
Someone told me that I would have to uses Advance Filtering option.
But I seem to have a problem with that. I can't figuare out how to make it display on the sheet if it has a formula in the cells.
So say for instant:
On Sheet1 I have an entry and in colm q the formula reports back "SB880"
On Sheet2 I want any entry that shows on sheet1 with the word "SB880" to display the last name, first name and SID# of whom ever shows with the word "SB880" on sheet2
The other issue I found from other video exsample is would I have to run the filter everytime I want to see the results, or once I does this setup, it will automatically show me new entries?
The other purpose of this, as I mention that my spreadsheet is very large display and this will also help me cut back on cells that I don't need to see off hand and I can hide them, but I also run all types of filter operation. So insted of me having to run all diffenrent type of filters, I can have a sheet that will automatically filter what I need on the fly.
So please help me firgue this out and I will repay you.. lol
Alot of people have asked why then do I have the Q colm hidden. Well all I can say is that my database spreadsheet is large. If I go any smaller then you would need magnifying glass.
So here's my question. Can I make another sheet that will filter whats on sheet1?
Someone told me that I would have to uses Advance Filtering option.
But I seem to have a problem with that. I can't figuare out how to make it display on the sheet if it has a formula in the cells.
So say for instant:
On Sheet1 I have an entry and in colm q the formula reports back "SB880"
On Sheet2 I want any entry that shows on sheet1 with the word "SB880" to display the last name, first name and SID# of whom ever shows with the word "SB880" on sheet2
The other issue I found from other video exsample is would I have to run the filter everytime I want to see the results, or once I does this setup, it will automatically show me new entries?
The other purpose of this, as I mention that my spreadsheet is very large display and this will also help me cut back on cells that I don't need to see off hand and I can hide them, but I also run all types of filter operation. So insted of me having to run all diffenrent type of filters, I can have a sheet that will automatically filter what I need on the fly.
So please help me firgue this out and I will repay you.. lol