+ Reply to Thread
Results 1 to 1 of 1

Accumulation of information from 100% identical workbooks

  1. #1
    Registered User
    Join Date
    09-08-2011
    Location
    London, england
    MS-Off Ver
    Excel 2003/7
    Posts
    46

    Accumulation of information from 100% identical workbooks

    Hello, everyone,
    more than a week asked and asked for help for a macro, but apparently no one can help me.
    So please you for assistance.
    Here's my idea:
    I have a workbook (base) in which each month accumulated information from another workbook (monthly).
    Both workbooks are 100% identical sheets.
    Sheet1 - is a constant in both workbooks.
    At baseline and monthly Workbook information is the same, but when I get the new month, the file that I receive monthly, there are already new information is colored in red.
    Open both workbooks and mandatory filter monthly workbook column "B" to filter in red, then copy all the rows of A: the end of each row and set it in a sheet of the same name base workbook.
    illustrated:
    Basic Workbook
    sheets with names as:
    Sheet1 - do not do anything constant
    "Apples"
    "Peaches"
    "Oranges"
    etc
    2. Monthly workbook - which sent
    Sheet1 - do not do anything constant
    "Apples" - red text, ie new information need to copy and "paste specia value" of A: the end in the same sheet of base workbook. If no red text, move to the next sheet of the end
    "Peaches" - same
    "Oranges" - same
    etc
    I beg you for some assistance from you.
    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)

Similar Threads

  1. Replies: 1
    Last Post: 01-25-2016, 03:19 PM
  2. Replies: 3
    Last Post: 09-07-2014, 10:31 AM
  3. [SOLVED] Merging 2 non-identical workbooks?
    By LuckyMan in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-14-2012, 10:48 AM
  4. consolidate 75 workbooks - identical headings
    By lray in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 11-10-2011, 05:53 PM
  5. Running identical code in two workbooks
    By rhudgins in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-09-2011, 11:27 AM
  6. Merging the data of two identical Workbooks
    By elastic in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-10-2010, 04:18 AM
  7. Sum up identical workbooks
    By Ctech in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-20-2006, 06:54 AM

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