Results 1 to 3 of 3

Macro for looking for new rows in import files and then adding them in master sheet

Threaded View

ammartino44 Macro for looking for new... 03-18-2015, 06:43 PM
ammartino44 Re: Macro for looking for new... 03-19-2015, 12:53 PM
simarui Re: Macro for looking for new... 03-19-2015, 05:03 PM
  1. #1
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    Macro for looking for new rows in import files and then adding them in master sheet

    Spreadsheet attached.


    Hello. I have to update financial statements every month. I usually use vlookup to import the date. Unfortunately, line items are occassionally added and deleted (I want to keep the added but I do NOT want to delete anything that has been deleted) so my main tab doesn't have all the line items. I have two questions.

    1) Ideally what I would like to get to is a macro that compares the list for each month and ADDS a row for the new items. For example in February, Sales 7 is added after Sales 3. I would like the previous row to be the reference point for where the new item is added.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Adding or deleting rows in master sheet and automatically update target sheet
    By RLR31064 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-26-2014, 01:39 PM
  2. [SOLVED] Adding rows while merging sheets into a master sheet
    By sbidgol in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-11-2014, 10:00 AM
  3. Import datas form multiple excel files to master sheet for consolidation
    By laxmananm in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-06-2014, 11:11 AM
  4. macro to add new sheet to many excel files from a master file
    By ldsone in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2013, 01:28 PM
  5. [SOLVED] A macro to Import data from many unique files into one master file
    By Researcher007 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-16-2012, 12:48 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