Results 1 to 3 of 3

linking tabs on a spreadsheet anticipating adding lines and adding missing data

Threaded View

  1. #2
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Re: linking tabs on a spreadsheet anticipating adding lines and adding missing data

    What you are asking for is very common(at least in this forum).

    The way most Excel databases work is;
    1. On a sheet, you collect and manage records. These should be very inclusive(all related info on one line for each record.
    2. Some columns and cell get calculated using worksheet functions.
    3. The autofilter helps a great deal in filtering these records. It's a great tool.
    4. Macros are used to do things like make reports. Like deadline reports.
    Last edited by Paul; 04-06-2012 at 02:58 PM. Reason: Removed last sentence. Using PM's for assistance or offering paid services are not permitted.

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