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

Hello,

The files are in separate folders and separate locations but I think we can move them to a central location if that makes it easier.
Yes we would like all the files processed please.

Thanks so much

Hi There,

Thank you for your reply. I inserted the path name as indicated. Once I hit the macro and entered the deposit date 09162016 I see the extra sheet created but the data did not transfer over.
Perhaps there is something I'm missing. Below is the code with my path name.
Thanks so much

Please Login or Register  to view this content.

Oh my gosh. It's absolutely perfect!!
You're the best!

Thank you so much.

Hello,

Apologies. When I tried with a real deposit, the Account Number and Amount did not populate and the 2 line entry batch lumped both entries in the same line on the deposit slip.
The only change I can think of is I blanked out the banking info on the deposits. The real deposits are also in protected mode and the top headers (banking info) is read only.
The Account # and Amount on the deposits also are not highlighted on the actual deposits.

I tested the other original ones I posted successfully even changed the dates up with success. Not sure if something I noted above affected the live testing?
Sorry to trouble

Hello,

I think I know what the problem is with my live deposits. The worksheet is protected. The testing deposits are not protected. Once I protect them the account number and amounts do not populate.

Is there by any chance a workaround to this?
Much appreciated

Capture.PNG

That's perfect. Thanks so much. It works great.
Appreciate all the help.

Hi. Sorry to poke one last time.
Is it possible to have the date format accept both 09262016 as well as 20160926?