+ Reply to Thread
Results 1 to 2 of 2

Update data from different sheets

  1. #1
    Registered User
    Join Date
    06-15-2016
    Location
    Ahmedabad
    MS-Off Ver
    2016
    Posts
    1

    Update data from different sheets

    Hi,

    I'm new to Macro and VBA, I need help with the following task.

    I wanted to pull data from multiple excel spreadsheet into one master workbook based on the courses and day wise. Instead of going through hundreds spreadsheet copy and pasted, is it possible to use Macro or VBA to perform this task? I'm using Excel 2013 & 2016. Attached you will find the master file and the two spreadsheets where i want the data to pull from and this process continue every end of the month so next data pulled under the last update data.Any help would be greatly appreciated.

    thanks,
    Attached Files Attached Files

  2. #2
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,146
    Hello sachin3467,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    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]

+ 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