+ Reply to Thread
Results 1 to 17 of 17

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

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    3,128

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

    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
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    3,128

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

    hemesh you wona try this maybe ?

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,639

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

    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.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  4. #4
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    3,128

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

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

  5. #5
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    3,128

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

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

  6. #6
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    3,128

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

    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

  7. #7
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    3,128

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

    sktneer here are the two files attaching one by one

  8. #8
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    3,128

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

    file 1 attached
    Attached Files Attached Files

  9. #9
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    3,128

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

    file 2 attached
    Attached Files Attached Files

  10. #10
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    3,128

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

    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

  11. #11
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,639

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

    Try this code.......
    Please Login or Register  to view this content.

  12. #12
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    3,128

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

    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

  13. #13
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    3,128

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

    Yes it works fine

  14. #14
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    3,128

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

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

  15. #15
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,639

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

    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?

  16. #16
    Registered User
    Join Date
    03-12-2014
    Location
    Central Texas
    MS-Off Ver
    Excel 2010
    Posts
    55

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

    Quote Originally Posted by sktneer View Post
    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
    Last edited by Old4xford; 05-09-2014 at 11:53 AM. Reason: Didn't work like I hoped. HTML is a bit rusty.
    Oh! I get it. I need rep--->҉

  17. #17
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    3,128

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

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Chop all data and give me this only
    By makinmomb in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-07-2014, 08:05 AM
  2. Replies: 5
    Last Post: 03-03-2010, 03:36 PM
  3. How do i chop up a spreadsheet
    By John K in forum Excel General
    Replies: 3
    Last Post: 12-07-2006, 11:51 AM
  4. chop off extra characters in excel
    By marctaroe@gmail.com in forum Excel General
    Replies: 6
    Last Post: 06-21-2006, 11:25 PM
  5. [SOLVED] Chop off parts of the statement
    By 0-0 Wai Wai ^-^ in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-23-2006, 05:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1