Macro to pull in data from excel file

Is this any help? You will need to edit the code to choose what to do with the array. Note I haven't added any proper error checks if the drive/folder/file is not found.

This is the code i have so far below. In workbooks.open, I have inputted the path to the spreadsheet I want. How do I make it so that it will always pull the most recent date that is dropped?
Also, in my other worksheet I will create a macro button, and I want the data from the finalizeddetails file to pull into this worksheet begining in column I row 7.

import

Please Login or Register  to view this content.

Thank you

This will attempt to open the dated file with the latest date in the past 7 days. The macro should be IN the workbook that is the destination. The macro will paste into column I starting at the empty rows it finds from jumping UP column I from the bottom of the sheet, so make sure there is nothing else in column I. If you want the paste to start at row 7, then I6 should be the last used cell in that column.

Please Login or Register  to view this content.

Anything after a ' is a comment, explanation of what the code is trying to do.


I found some tiny errors in the xlUp references, so copy the code from above again. I don't expect there to be any code changes needed, try it again.

Originally Posted by cartica

This is the code i have so far below. In workbooks.open, I have inputted the path to the spreadsheet I want. How do I make it so that it will always pull the most recent date that is dropped?
Also, in my other worksheet I will create a macro button, and I want the data from the finalizeddetails file to pull into this worksheet begining in column I row 7.

Here is a revised version. Note that it only works if the import file has todays date.

JBeaucaire-

your macro worked in my s/s. Thank you. My only question is what would I ammend in below so that in the worksheet when I run macro the data starts to past in Column I row 7. right now it's pulling in row6.

Please Login or Register  to view this content.

When you joined the forum recently you agreed to abide by the Forum Rules, but in haste I fear you might not have actually read them. Please stop and take a moment to read them now. We all follow these rules for the benefit of all, as must you. Thanks.

(link above in the menu bar)

Your post #9 does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here


I already corrected your post #1 as a courtesy demonstration, now it's your turn.

Originally Posted by cartica

mc84excel-

When I run the macro you attached, I receive an error. It says could not create array from finalizeddetails072413.xls Sheet1

Sorry to hear that. Unfortunately I can't tell where it's breaking without a copy of the WB you are trying to import. To maintain the confidentiality of your information, I suggest you step through the code to see which line the code is breaking on and what the messages say when you mouse hover over the variables on that line. If you can let me know that, I may be able to solve it. (It would be much much easier for me if you could upload the import WB - even if you have to replace any confidential data with dummy figures/strings).

It means find the range that encompasses A2 down to the last used cell in column P, copy that range, then paste it into the new sheet starting at the next empty cell in column I.

If those are 5 unmerged cells, maybe:

Please Login or Register  to view this content.

If those cells are actually one big merged cell, even simpler:

Please Login or Register  to view this content.