+ Reply to Thread
Results 1 to 10 of 10

Importing file as temp and copy paste info into main file!!! HELP PLEASE

  1. #1
    Forum Contributor
    Join Date
    04-14-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    198

    Angry Importing file as temp and copy paste info into main file!!! HELP PLEASE

    Ok, I have a file that gets sent to me in an email... the example file attached is examplefile1... I also have the main file that I work with being examplefile2 that is attached... What I need is a macro that I can run in examplefile2 that allows me to select the examplefile1 open it as a temp file or whatever is needed to copy the order number column and paste it into the main exapmlefile2 location...

    To try to explain again, examplefile1 is emailed to me, I open examplefile2 and run a macro in which it allows me to select the emailed file that I have saved somewhere and pulls the order numbers from it and pastes them into examplefile2 in the proper area.

    PLEASE NOTE THESE EXAMPLE FILES ARE EXTREMELY SIMPLE COMPARED TO WHAT I AM WORKING WITH... I JUST NEED THE SIMPLE IDEA OF HOW TO DO IT AND I CAN GET IT TRANSLATED TO MY ACTUAL WORKSHEETS...


    Thanks,examplefile1.xlsxexamplefile2.xlsx

    TIA!!!

  2. #2
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Importing file as temp and copy paste info into main file!!! HELP PLEASE

    This is a most basic starter solution. It assumes that your rows between the two workbooks match up, and all you want to do is copy column G from one sheet to the other, which is not likely the case.

    Please Login or Register  to view this content.
    Acts 4:12
    Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.

  3. #3
    Forum Contributor
    Join Date
    04-14-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    198

    Re: Importing file as temp and copy paste info into main file!!! HELP PLEASE

    That gets me started I now need someone to help me figure out I need vba to search for say Apples and where Apples has Order Number of NOTHING OR "" and Product = product in that same row copy the order number from first file and paste it into the second file...

    Hope that makes sense...

  4. #4
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Importing file as temp and copy paste info into main file!!! HELP PLEASE

    See if I got it right.

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    04-14-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    198

    Re: Importing file as temp and copy paste info into main file!!! HELP PLEASE

    SLAUGHTER W ORDER NUM.xlsxSubmitted Orders.xlsx

    Ok, here is a better example of what I am trying to do... So the slaughter order page is the file I would be saving from my email. Once saved I will open the submitted orders file and run a macro that needs to do the following...

    Open the slaughter order temporarily to retrieve the plant name which is in cell M15 (ALWAYS) and search in the submitted orders file for that plant name as well as compare product on the slaughter sheet that DOES have an order number with the same product at that plant on the submitted order page with NO order number... then the order number will be pasted there...

    For example.

    The slaughter sheet has two 9000987 products in which only 1 of them has an order number... that means there will only be 1 in the submitted order file without an order number... so I need the macro to Say ok Find "Slaughter Gas Plant" where B(SAME ROW THAT SLAUGHTER GAS PLANT WAS FOUND) = Product from first file take (9000987) for example AND "P(SAME ROW THAT SLAUGHTER GAS PLANT WAS FOUND)" = "" then Copy from order sheet "O(whatever row the first order number is found)" and PASTE into "P(Same ROW THAT WAS RETURNED IN SEARCH)...

    This will always be a different plant name and have several different products on the list...

    Thanks for all the help

  6. #6
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Importing file as temp and copy paste info into main file!!! HELP PLEASE

    Is the Submitted Orders sheet sorted by Plant Name. In other words, are the plants grouped together, or are the scattered?

  7. #7
    Forum Contributor
    Join Date
    04-14-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    198

    Re: Importing file as temp and copy paste info into main file!!! HELP PLEASE

    scattered... but they can be sorted if needed.

  8. #8
    Forum Contributor
    Join Date
    04-14-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    198

    Re: Importing file as temp and copy paste info into main file!!! HELP PLEASE

    This is a failure of attempting to get it to do what I want... someone please help me figure it out...
    I am terrible at the find function please use it to solve this it has to be much easier than the cluster I have below!!!

    Thanks again

    Please Login or Register  to view this content.

  9. #9
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Importing file as temp and copy paste info into main file!!! HELP PLEASE

    I had code ready for you Friday and was waiting for your response about the sort, but I lost the code over the weekend, so I'm starting over. I'll get back with you shortly.

  10. #10
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Importing file as temp and copy paste info into main file!!! HELP PLEASE

    Give this a try.
    Please Login or Register  to view this content.

+ 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] Copy same range in many excel files and paste into a main file
    By dualaudio454252 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-15-2014, 05:25 PM
  2. Macro to find a partial name of file, copy info and paste it in another workbook
    By missimpulse in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2014, 02:39 PM
  3. Replies: 2
    Last Post: 02-10-2014, 11:52 AM
  4. Macro to copy range from temp file to open file
    By 4luk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-02-2013, 02:22 AM
  5. Open 2nd file(CSV) from cell reference, copy columns to main file & close 2nd file
    By Langchop in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2013, 05:09 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