VBA code

[kelvin_9]

Hi all,

i'd like to ask for any help for my request.
Sheet1, my data in/out flow frequency for every week(updated once a week)
Sheet2, my request.

i need to process sequence & accurate:
-by date, by time flow, by EP01IN/EP01OUT, EP02IN/EP02OUT.....(even more)....
-Sheet2 is no necessary to return sum, like row 19, row 37, row 55 on Sheet1

https://drive.google.com/open?id=1aKLG8KLGR4Y-U46PE_0ffisdXnLnKuLq

thanks for the great help, appreciate!

 

[kelvin_9]

Hi all,

i'd like to ask for any help for my request.
Sheet1, my data in/out flow frequency for every week(updated once a week)
Sheet2, my request.

i need to process sequence & accurate:
-by date, by time flow, by EP01IN/EP01OUT, EP02IN/EP02OUT.....(even more)....
-Sheet2 is no necessary to return sum, like row 19, row 37, row 55 on Sheet1

https://drive.google.com/open?id=1aKLG8KLGR4Y-U46PE_0ffisdXnLnKuLq

thanks for the great help, appreciate!

anyone will have any suggestion/solution?

 

[offthelip]

What are you actually asking for, the two sheets look the same apart from adding a row with some "sum" in it, but you say:"No necessary to return sum"

 

[kelvin_9]

What are you actually asking for, the two sheets look the same apart from adding a row with some "sum" in it, but you say:"No necessary to return sum"

thanks Offthelip

they look same, even exactly same.
i need a accurate data from sheet1 to sheet2
some time i wont have in/out flow from EP01 or EP02, which means data in column C would never be the same
(for instance @ column C, this time EP01 IN, next time EP03 IN......total in 10 in/out flow in my shop)
so i need to manual/auto return one time data to sheet2(as summary with all IN/OUT as heading)from sheet1, but i dont need to had a "sum" showing every day.

i was modified the file hopes easier understanding, sheet1 showing which is only EP02 & EP03 IN/OUT flow, but sheet2 showing all, sure EP01 is none.

sorry for the typo mistake / misunderstanding caused if any
thanks again, offthelip

 

[offthelip]

I am still not sure what you want, it appears that you want to copy data from sheet 1 to sheet 2, but do you want to copy all of the data or are there some conditions connected to what data to copy? If so what are the conditions to decide whether to copy the data or not?

 

[kelvin_9]

-_-"

anyother could help? please