Spreadsheet which automatically moves an entry when given a particular definition/title

[R.T.D]

Hi everyone.

I am looking to edit my work spreadsheet which tracks any tenders I am quoting for, which currently breaks them down via different columns (project number, name, current status, value etc.).

Under the current status I have a drop down list with multiple titles (Live, On Hold, Lost, Complete). Would it be possible for the spreadsheet to automatically move to relevant row to a new page if given a certain current status. For example could I have two additional pages, one for Lost and one for Complete, and every time I apply the Lost or Complete status to a project it will be moved over to the relevant page?

Thanks in advance.

[vcoolio]

Hello RTD,

Do you have the destination worksheets already created or are you hoping that the destination sheets can be created once you select the relevant status?

Cheerio,
vcoolio.

[R.T.D]

Hello RTD,

Do you have the destination worksheets already created or are you hoping that the destination sheets can be created once you select the relevant status?

Cheerio,
vcoolio.

Hi,

I haven't made the destination worksheets at the moment.
Thanks.

[vcoolio]

Could you upload a sample of your workbook please. Read the gold coloured banner at the top of this page which describes how to upload a sample.
Make sure that the sample is an exact replica of your actual workbook.

Cheerio,
vcoolio.