asked on

Microsoft Excel Formula and IF statements

Hi there

I have a spreadsheet showing fixed assets (an asset register). One of the columns shows the asset (a text field) and another shows the location the asset is in (also a text field).

I would like to have the spreadsheet so that all the assets are listed on the first sheet and if they are physically moved I can change the location on the front sheet. I would then like individual sheets for each location so that when changing the location on the front sheet the asset would automatically be recognised and so subsequently moved to the correct corresponding location sheet. Would this use an IF statement as because the fields are text rather than numbers, it is not working. I am using Excel 2003 by the way.

Any help appreciated. Thanks!

Jacobfw

On the second and subsequent worksheets, setup of a filter with criteria like this example:

http://www.contextures.com/xladvfilter01.html#ExtractWs

SOLUTION

Jacobfw

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Arno Koster

So what you want is when the location on the front sheet is updated, subsheets for each location showing the assets for that specific location will be updated as well ?

you have multiple options for this :

- macro
- formula
- filtering

or a combination of those. can you post an example sheet ?

ASKER CERTIFIED SOLUTION

Arno Koster

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

kgerb

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

markf100

ASKER

Excellent advice everyone. Thank you very much. I have split the points.