Consolidation Assistant for Microsoft Excel

Consolidation Assistant for Microsoft Excel

The Consolidation Assistant is designed to help you consolidate data from multiple workbooks or from multiple worksheets.Workbook consolidation can be done one of two ways:

Combining worksheets from a list of workbooks

Selecting a set of workbooks and specifying a range name that identifies the data range to be extracted.

The first approach, combining worksheets from a list of workbooks, is a two step operation. First you would run the first option on the above menu and select the files containing the worksheets to be consolidated. This creates a list of workbooks and worksheets. For those sheets you wish to consolidate, type the name to use in the consolidated file to the right of the existing name. The set of names you specify must each be unique. Once you have done this, select the range containing the new sheet names and run option two on the above menu. Blank cells in the selection will be ignored. When the consolidation is finished, you will end up with a workbook containing each of the sheets that you specified.

When consolidating workbooks, you have two choices: converting the sheets to values or copying the entire sheet. The first approach is the one to use if you have range names used in the formulas, and these range names can have different values. Excel by design will use the first range name that is copied into the consolidation workbook. This rang name may not be what you want used for every sheet. And, sometimes it creates local names, so that you end up with the global name used by some sheets, and the local names on other sheets. If you do not use range names in the formulas, then copying the entire sheet allows you to retain formulas that may be of use to you.

The Consolidation Assistant has several features that allow you to better view your data. One freeze panes on all selected sheets. Another sets the same cell on all selected sheets to the upper left corner. And at the same time sets the zoom to the same setting..

Once 29.95

Army Screen Saver
Screen Saver with pictures of Army...

ACA Screen Recorder 2.01
ACA Screen Recorder captures the action from your Windows screen and saves it as a standard, easily edited, AVI (Audio-Video Interleaved) movie file.

File Securer software
File Securer is a powerful tool designed to protect your sensitive folders and personal files. With strong security, File Securer embeds the protect into windows system kernel, both on command mode and window mode, all work professionally.

PalmSlay
Slay for the Palm handheld...

The Shakespeare Collection
A classic collection of inspiring and beautiful notecards that are formatted and ready to print as needed. These cards can be used for all occasions and all types of personal communication.

Championship Gin Pro Card Game for Palm
Discover world-class card playing action anytime, anywhere, on any device! Simple to learn, yet challenging to master, Championship Gin Pro offers a fun and exciting gaming experience for casual and hardcore fans alike.

Championship Gin Pro Card Game for Windows XP
Discover world-class card playing action anytime, anywhere, on any device! Simple to learn, yet challenging to master, Championship Gin Pro offers a fun and exciting gaming experience for casual and hardcore fans alike.

Championship Gin Pro Card Game for PocketPC
Discover world-class card playing action anytime, anywhere, on any device! Simple to learn, yet challenging to master, Championship Gin Pro offers a fun and exciting gaming experience for casual and hardcore fans alike.

Doulber Gold
In a world filled with monster guards, menacing bats, crushing boulders, blazing lava and a labyrinth of cavesAn ant with a funny name emerges, energized, and ready to combat the latest elements. Yes. Doulber is here.

PictoWin Multi desktop manager
This robust award wining multi desktop manager adds unlimited number of virtual desktops to your PC

PDFConv1.3
The Converter (PDF to HTML) software product converts PDF files to HTML files while seeking to preserve the original page layout (as best as technically possible).

Zilla Audio Converter & Extractor
Universal Audio file converter with most possible audio file settings or extract audio sound from video.

Zilla Video Converter & Decompiler
Unioversal Video File Converter & Decompiler for MPEG, MPEG-1, MPEG-2, AVI (Windows Video), WMV (Windows Media Video), ASF & RM (Real Media). Apply a variety of effects during conversion. Extract Single Video Frames to Image Files.

Chat In Flash
Web Based Visitor Chat Window Supports unlimited simultaneous chats Smiles enabled...

ShoutBox In Flash
ShoutBox In Flash and asp can create live chat room in your complete site . no database or dll required to be uploaded. all messages are stored in txt file. smilies emotions capability.

Excel Usability Enhancer
This Microsoft Excel add-in provides an amazing range all utilities and macros, especially those which make the use of Excel simpler and those which loop around objects for replication off single commands.

Dog Days
Mans Best Friend! If you are a true dog lover, Dog Days is sure to be one your favorite screensavers. Dog Days is filled with light hearted background music and inspiring quotes by Robert Frost, Lord Byron, and columnist Dave Barry.

xGomoku for Palm
Gomoku is played between two opponents on a board by making moves with black and white men called stones. One of the players has at his disposal the black stones and the other player has white stones.

JoyScreen Builder Desktop Edition
It has a fully integrated workspace that permits you to work efficiently and easily create professional screen savers in a few minutes ! JoyScreen Builder lets you create screensaver based on Shockwave Flash (no limit to your imagination!)...

Anyplace Control
Anyplace Control is a remote control program that can display a screen of another computer (via internet or network) on your screen. The program allows you to use your mouse and keyboard to control the other PC remotely.