+ Reply to Thread
Results 1 to 3 of 3

Copy Data from a fixed form of data sheet into a master excel sheet.....

  1. #1
    Registered User
    Join Date
    12-04-2012
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    1

    Exclamation Copy Data from a fixed form of data sheet into a master excel sheet.....

    Hi,
    I have a data in fixed excel template. Each time when the data will be changing i want the master sheet to be updated automatically but keeping the previous data in the master sheet. So basically the new data needs to start from next empty row

    Please find the data template in the attachment.

    Basically i need the data in the sheet 2 to be transferred in to sheet 1 but each time the data will be changing in the sheet 2 the previous data should not be erased from sheet 1 and the new data should be updated in sheet 1.

    Thanks alot.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: Copy Data from a fixed form of data sheet into a master excel sheet.....

    So each time you make an update to Sheet2, you will be changing the data between rows 9 and 42?

    Are there chances that you will already have data in Sheet2 which has already been copied to Sheet1 and then you will add some more data in the next available row in Sheet2? I am asking this to help you not have duplicates in your data in Sheet1.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Contributor
    Join Date
    08-10-2006
    Location
    The Netherlands
    MS-Off Ver
    Office for Mac 2016; MS Office 2016 for Windows
    Posts
    110

    Re: Copy Data from a fixed form of data sheet into a master excel sheet.....

    Hi Arlette,

    I've noticed this topic, which has almost a similar problem as my topic:

    http://www.excelforum.com/excel-prog...73#post3049473

    Are you able to assist me as well in this?

    Kind regards,
    Peter

+ Reply to Thread

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