1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

which program?

Discussion in 'Business Applications' started by crashdown, Jan 15, 2013.

Thread Status:
Not open for further replies.
  1. crashdown

    crashdown Thread Starter

    Joined:
    Oct 22, 2012
    Messages:
    58
    i was wondering if there was software that can do what im looking for
    though it may be obvious - i dont know

    At the moment im using many excel workbooks to hold lots of data
    each book is identically set up
    each book is for an instrument and holds the nessesaries for it in it
    the front sheet of each summarises
    another book pulls each summary to one
    another book is used as INPUT - margins etc

    the problem is for each job different combinations of instruments are needed so this template is copied to a named folder
    randomly links follow or not. and to change a margin % on the input sheet i need to open each instrument book so the final summary updates. copying in this whole template is a massive use of memory

    i know that i can set excel to update links automatically - though i dont know if each would still need to be opened

    what i would like is some sort of program where this all works within it instead of across windows

    i may not make sense and what im after may not exist

    all constructive comments welcome

    Many says ACCESS - is there any one with pointers for this - iv never used access before
     
  2. 20_2_Many

    20_2_Many

    Joined:
    Jun 29, 2012
    Messages:
    518
    This sounds to me like a candidate for MS Access. Some extremely good Access assistance can be found here, hope one of them jumps on this thread for you!
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1085284

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice