find date, copy refering to the heders and one condition(in last row)

Hi All,

I'm stock in this and I'd like to ask for help from experts.
Copy data refering to the date.
I'd like to update File_1 every day with a data from yesterday.
I'm trying to do something like "slide table".

I'd like to copy data by date from one workbook(BASE) to workbook (FILE_1).
(from A do B).
*In FILE_1 (DAY is on row 3) Headers (on row 5)
**Each range for day is on the same size.
*** DATE is on first column in a range
*** BLUE color - cells to paste data form BASE
*** YELLOW color - cells with data. Not to replacing each cell with data.
but Empty cells I need to replace from BASE.

For every cells on range (yesterday date in FILE_1 i A1)
copy/paste and replace any data if something on there.
Only in Row CONDITION - replecing only empty cells.

Thanks in advance.

Maybe somebody could help me just for only transfer those data.
without conditions in row 13.
Just copy from a to b in right places.

I'd like to find data by date in Cell (A1) on FILE_1 and copy from BASE (date in Column B).
Search for a date in row 3 (FILE_1) and paste data in right places (headers in row 5)

Thanks in advance.

With my vba basic knowledge i try by using GetValue works in closed file.
But I still don't get how to modificited it to find each date.
To works in dynamic range in both files.

Please Login or Register  to view this content.