Villalobos
Active Member
Hello Forumers,
I have a question regarding the data collection.
I would like to collect the data from the first excel file in to the second file based on various criteria. Could somebody offer a simply code for that?
Example
File #1:
Cell A1 a 0
Cell A2 b 1
Cell A3 c 0
Cell A4 d 2
Cell A5 e 2
If "Cell A1 : Cell A5" > 0 then the code show this in the other file:
File #2
Cell A1 b 1
Cell A2 d 2
Cell A3 e 2
Do you have any idea?
Thanks in advance!
I have a question regarding the data collection.
I would like to collect the data from the first excel file in to the second file based on various criteria. Could somebody offer a simply code for that?
Example
File #1:
Cell A1 a 0
Cell A2 b 1
Cell A3 c 0
Cell A4 d 2
Cell A5 e 2
If "Cell A1 : Cell A5" > 0 then the code show this in the other file:
File #2
Cell A1 b 1
Cell A2 d 2
Cell A3 e 2
Do you have any idea?
Thanks in advance!