Quote:
Originally posted by Chuckiechan
I'm not sure I understand your question, but you can use a if/then formula. (=if XX=0, then "YY", "ZZ") or similiar to this.
It is saying "if there is a value in cell XX that is equal to zero, the use value in cell yy. If the value is not zero, use the value in cell ZZ.
There are other arguments you can apply, but lets start here.
How close is this to what you need to do? |
Not close. This is an arguement for checking a CELL and returning a response. This is cel by cell.
Let's look at this in story form. I have 10 worksheets in a workbook. Each sheet contains many rows of information on our clients; (one row to a client) and each row has a formula which checks the current date and indicates whether it is time for a follow up call to this client.
On page 11 I want to have ALL the followups show up on one page. so I want to be able to leave OFF any row/client that is not slated for follow up. Using the "IF" statement, I would have just as many rows as there are on all 10 pages, but there will be many blank rows on page 11 which would correspond with NON follow up rows.
I imagine that this is a VB programming macro which will go through each page, glean out the Follow up rows and place them on page 11. Then I would have to delete the information on page 11 and re-run the macro (or whatever) each day to repopulate page 11 with the follow-ups for each day.
...
Linear Mode
