Share via

Extract specific information from a main data sheet into a seperate worksheet (tab)

Anonymous
2023-04-23T09:08:33+00:00

I have a main data sheet with all of our vehicles, amount of diesel used etc. I am wanting to extract all the information for just 1 vehicle registration and extract that information into its own specific tab/worksheet on the same excel document.

I have tried =FILTER but it wont put all the information into the new sheet. How do i do this and also insures that any new data entered on the main data sheet is linked to this sheet so it is always up to date?

Date Vehicle Registration or Description
07/12/2020 DELIVERY
07/12/2020 TT23 111
07/12/2020 TT24 111
07/12/2020 TT25 111
Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points
    2023-04-23T10:39:08+00:00

    The FILTER function should do what you want, Two ways of ensuring that newly added data will be included in the formula's result:

    • Convert the source data to a table, and use structured references in your FILTER formula, or
    • Use large ranges in your FILTER formula - it doesn't matter if they currently have lots of empty rows.

    Was this answer helpful?

    0 comments