Excel programming question

**Marvinator** · November 25th, 2003, 11:25 AM

I'm working in Excel for a client. The current workbook has 10 sheets each with special data.

I want to be able to go through each of the 10 sheets and extract lines of information according to the information in one cell. If the cell says "Follow-Up" then i want the entire line included. If the Cell DOES NOT say "Follow-Up" I don't want it included.

What sort of formula or extra programming work would this take?

**Chuckiechan** · November 28th, 2003, 12:14 PM

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?

**Marvinator** · November 28th, 2003, 01:41 PM

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.

**jpk067** · November 29th, 2003, 02:26 AM

...
Take a look on the workbook a attached here.
I made that exemple in a french version of Excel, if there is a problem with opening it, let me know.
I don't use any macro, just an automatic filtering on the last worksheet.

**jpk067** · November 29th, 2003, 02:31 AM

oops, i could't attach my file, if u want it, send me a email (jpk067@hotmail.com)

**Chuckiechan** · November 29th, 2003, 03:20 AM

That's a tough one.

Although it is not my place to make suggestions, why are you using Excel rather that Access db? It is too easy to scramble your information on Excel when trying to sort data.

Access, at least locks your data rows together as rows, rather that cells like Excel.

I'll try to think something up on the weekend.

You got a PM...