Pull out data from worksheet to another worksheet

Hello All,

Im having a problem pulling out individual data from previous worksheet (Sheet 1) to another worksheet(sheet 2, 3, 4...) individually.
for example I want to pull out the values of IP B0b/C0b Hum to another worksheet separated by each day. is there an easy way to to this using a vba code or excel formulas?

please find attached file.

Thank you so much.

Try the attached file..

just select the code.. and wait for a minute or two to let excel calculate result..

and then copy the result to the new sheet as desired...

Formula used..

Formula:

Please Login or Register  to view this content.

if you wanna understand that how the formula works..
click the link below..

http://excel-buzz.blogspot.in/2014/0...-to-array.html

Don't forget to click *

Thank you so much Vikas.