Re: Consolidate User Input

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jim Rech (jrrech_at_hotmail.com)
Date: 02/06/04 

Date: Fri, 6 Feb 2004 17:04:30 -0500

There is no File, Combine command in Excel like in old 1-2-3. Old 1-2-3
needed this because only one file could be opened at a time. But there is
no such limitation in Excel. So, open each workbook and copy from it,
pasting into the consolidation workbook. 

-- 
Jim Rech
Excel MVP

Relevant Pages

  • Re: Consolidate User Input
    ... Thanks for the clarity between 1-2-3 and Excel, I could have spent ages ... > pasting into the consolidation workbook. ...
    (microsoft.public.excel.programming)
  • Re: What Excel 4.0 macro command do I need to use to delete a range na
    ... Thanks to Jim Rech for giving the correct answer. ... "Tom Ogilvy" wrote in message ... >> 4.0 command that will delete range names. ...
    (microsoft.public.excel.programming)
  • Re: Command Button Color Palette
    ... How do I find the color index value (i.e. for the "gold" color square ... BackColor property and select the Palette tab. ... When I go into the properties for the Command Button while in design mode, ... Excel shows a similar color palette, but not with the exact same colors as ...
    (microsoft.public.excel.programming)
  • Re: Add-In Excel Locked Up
    ... Note that Excel 2007 does not have a menubar or toolbars. ... command. ... Dim Ms As CommandBarControl ... Dim CoreCons As CommandBarButton ...
    (microsoft.public.excel.programming)
  • Re: Printing prn files
    ... I have no idea how setting a print area in Excel could relate to the problem ... Windows does not provide a way to do this directly. ... > is to use a command issued from a command processor prompt. ...
    (microsoft.public.windowsxp.print_fax)