+ Reply to Thread
Results 1 to 1 of 1

Calculating over two sheets

  1. #1
    Registered User
    Join Date
    02-16-2009
    Location
    scotland
    MS-Off Ver
    Excel 2003
    Posts
    2

    Calculating over two sheets

    Help!

    I'm sure this is probaly pretty easy but not for me!

    I have a spreadsheet used for listing consumable items for photocopiers, what i would like to do is to be able to a have a second spreadsheet that whenever a product is removed from the listing it updates the second spreadsheet, which will be used for stock control and ordering replaments

    The reason for two spreadsheet is firstly for security and secondly because a single item may be listed multiple times in the first list for ease of use but only listed once in the second spreadsheet. So i would need it to calculate multiple cells in the first but add the result to only one cell in the second spreadsheet

    I've attached the first spreadsheet here, hope this makes sense once youve looked

    many thanks
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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