Macro code to filter and copy data in order

[Alaa_Ali]

Good evening

I have a data files I need to extract data from

I have provided sample files which have three sheets :

- original Data file (the file I get from the system)
- required data (the file after filter and removal of empty columns)
- data source (I need the data to be copied to that sheet in order)

I need the code to filter and remove empty cells on original Data file sheet, to become the same on required data sheet then copy the branch name (cell A2), date(Cell G5) and the data on Yellow from the Required data sheet to the data source sheet. so the branch name and date be next to the items on every row.

Note that the data size is not the same (in the sample the number of rows is 53 in any other files it could be more or less) , and that the data files are separate (Group of workbooks), so the code will work on at least two workbooks (i need to be able to add the destination and the name of the file to copy data from).

I hope I made the explanation clear.

Thanks in advance

 

[vletm]

Alaa_Ali
Two questions ...
1) Where would 'required data'-sheet need if the result should save to 'data source'-sheet?
2) Where would 'Sales Value' come to 'data source'-sheet?

 

[Alaa_Ali]

the Required data exist to show you how to filter and edit data.

So the code will work on original data sheet to make it in the same form ii the required data sheet then to be copied to data source

the sales value is the column E in the required data

i hope it's clear now

 

[vletm]

Alaa_Ali
about my questions:
1) Where ... I don't need that sheet!
2) Where ... there are NO any values in 'original Data file'-sheet!
... hmm? When do You add those values to 'required data' ... which no need?
or do I copy those from 'original Data file's I-column?