Results 1 to 15 of 15

Copy specific data from multiple files to one file

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-02-2015
    Location
    Canada
    MS-Off Ver
    Office 2010
    Posts
    129

    Copy specific data from multiple files to one file

    Hi,

    I'm not sure if this is possible. What I have are daily deposits where I need to copy the highlighted information from these deposits onto a master excel file.

    On the master file called (for example) "DEPOSIT_SLIP_SEP_16" the information required from each of the the deposits are:

    column B "Batch Total" - total of the deposit (highlighted)
    column C - "Account_Number" - from column A on the deposit sheet (highlighted)
    column D - "Amount" - the amount from each line item on the deposit sheet (highlighted)
    column A - "Batch ID" - this indicates that row belongs to the same deposit sheet. Example Batch ID 1 is one deposit (with 2 entries but they both came from the same deposit so rows 2 and 3 both have the same number in column A),
    Batch ID 2 is another deposit, Batch ID 3 is another deposit, etc.....

    Basically every day when there are new deposits the highlighted information is moved onto the master sheet (the master sheet is overwritten every day). Is there a way to create a macro to have the highlighted information copied onto the master sheet automatically?

    I have attached the individual deposits and the master sheet (already filled out) to show as an example.

    Any help would be appreciated

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. copy specific cells from multiple .xlsx files into a table in destination file
    By khhleung in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-09-2014, 07:18 PM
  2. [SOLVED] HELP: Copy Data from Multiple CSV files to an output xls file
    By Anatawan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-31-2014, 12:33 AM
  3. [SOLVED] How to Extract Data from Multiple Files in Same Folder and Copy Data to One File
    By champ052005 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-10-2013, 01:25 PM
  4. [SOLVED] Importing specific data from multiple text files in a file directory into excel
    By abat in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 07-03-2013, 05:26 PM
  5. Using a macro to pull specific data from multiple files into a master file
    By bocaj315 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-04-2013, 09:31 AM
  6. Open a file and copy data into multiple files
    By ncduke in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-12-2010, 09:39 AM
  7. [SOLVED] How do I pull data from multiple files and copy into one file
    By JT in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-03-2005, 03:06 PM

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