Chop all data and give me this only ( part 2 )

[makinmomb]

I am using this program written by sktneer

My boss changed his mind , he liked it , but
he wants it this way

With the attached macro he was supposed to
paste the results of sheet 2 on his file

This is how he wants it

Imagine the same file is a file without macro
I need the macro do the same task but it needs
to go fetch the details from a folder in which this
raw data sits , assume the folder name is abc

sktneer you again maybe

[makinmomb]

hemesh you wona try this maybe ?

[sktneer]

Try this code......

This code assumes that you a folder ABC in the C drive and in the folder ABC, there are multiple .xlsx files containing raw data.
You have a master file which will contain the code given below and code will be executed from this file itself. What the code will do is, it will check the folder ABC in C drive and if it finds any .xlsx file, it will fetch the data from that file and paste the required column ( I & J) on sheet2 of your master file.

See if this works as per your requirement.

Please Login or Register  to view this content.

[makinmomb]

Thanks I will try this , this end its close time , I am eager to reach home and try this out

[makinmomb]

Almost working , it gives me REF , i think its not converting the formula to values

[makinmomb]

I will need to re attach the two raw files so that you can test it out ,
i was able o reach you before 5 minutes close time

[makinmomb]

sktneer here are the two files attaching one by one

[makinmomb]

file 1 attached

[makinmomb]

file 2 attached

[makinmomb]

sktneer this than gives you the exact code modification
for the program to work as intended , thank you once
again for attending my case closer

[sktneer]

Try this code.......

Please Login or Register  to view this content.

[makinmomb]

Hi just 10% away , why there are duplicates , see 100.005.15

COST CODE
1049.22 100.005.15
957.02 100.002.95
1024.95 100.002.63
797.82 100.004.42
1024.95 100.003.34
1988.49 100.003.94
1988.49 100.003.95
1988.49 100.003.93
892.02 100.005.56
892.02 100.005.57
1658.72 100.005.91
1658.72 100.005.92
888.85 100.006.55
1498.57 100.004.92
1471.24 100.004.93
932.48 100.004.94
1807.72 100.006.56
1807.72 100.006.57
1807.72 100.005.13
809.12 100.005.15
845.89 100.000.50
706.39 100.000.53
1626.95 100.004.02
809.12 100.005.07
847.28 100.003.82

[makinmomb]

Yes it works fine

[makinmomb]

Thanks you closer skneer , for both the part 1
and part 2 fully working files answered before
the next day opening

[sktneer]

The code fetched all the Cost and Code from the raw 01 and raw 02 on the sheet 2 of master file. I don't see neither any duplicate nor any missing values. I think its working fine. Where was the confusion then?

[Old4xford]

The code fetched all the Cost and Code from the raw 01 and raw 02 on the sheet 2 of master file. I don't see neither any duplicate nor any missing values. I think its working fine. Where was the confusion then?

I do believe makinmomb was referring to this 100.005.15 duplicate(s):

Hi just 10% away , why there are duplicates , see 100.005.15

COST CODE
1049.22 100.005.15
957.02 100.002.95
1024.95 100.002.63
797.82 100.004.42
1024.95 100.003.34
1988.49 100.003.94
1988.49 100.003.95
1988.49 100.003.93
892.02 100.005.56
892.02 100.005.57
1658.72 100.005.91
1658.72 100.005.92
888.85 100.006.55
1498.57 100.004.92
1471.24 100.004.93
932.48 100.004.94
1807.72 100.006.56
1807.72 100.006.57
1807.72 100.005.13
809.12 100.005.15
845.89 100.000.50
706.39 100.000.53
1626.95 100.004.02
809.12 100.005.07
847.28 100.003.82

[makinmomb]

Its okay I created a column aside o highlight duplicate ,
what the boss will do is he will delete the one with the
lower cost

I am already using his program , works super fine