Results 1 to 2 of 2

Basic Database & Selective Tables?

Threaded View

cs03dmj Basic Database & Selective... 11-14-2007, 05:45 AM
Bjornar I don't know where you get... 11-14-2007, 07:06 AM
  1. #1
    Registered User
    Join Date
    11-14-2007
    Posts
    5

    Basic Database & Selective Tables?

    I've got a mini project whereby I need four worksheets:

    Master
    Channel 1
    Channel 2
    Channel 3

    Example data be seen on the attached screenshot.

    For the master sheet, there are three sales channels, with each of which having two plans. Each plan may or may not have an associated item, and if it does, the cost could be free.

    On the channel sheets, I am hoping to list only items that have an associated plan. Per the screenshot, Channel 1 does not list Item 2, and Channel 3 only lists Item 2. Please note that there will likely be hundreds of items in the final spreadsheet.

    Is this achievable in Excel?
    What formulas would I use so that only valid items are present on the 'Channel' worksheets?
    If I were to add items to the Master worksheet, could the other sheets automatically update?
    There will be a need to add 'Plans' in the future - will the 'Channel' worksheets cope with this?

    Any help would be most appreciated - do let me know if this is better suited to a database, though I was hoping to not having to go down that route!
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1