Import data from workbook into Active Sheet, and Allow manipulation of WB around MsgBox

[DaiyannaGrae]

I am attempting to import data out of a weekly excel sheet, into the master workbook. The goal is to have 3 things ha[[en when the user clicks the button:

1 - MsgBox pops up saying "Be sure to select the correct destination worksheet before clicking OK."
1.2 - Allow user to select correct sheet if they have not, then click OK. If this cannot be done, then is it possible to place a cancel option in the box, so that they can select the correct sheet, then try again?
2 - Import the data from the file selected into the active worksheet.
3- Force a sort so that the format of the sheet matches the rest of the master workbook.


Here is the code that I have so far.

Please Login or Register  to view this content.

Any help with this would be greatly appreciated.

Thanks,
DaiyannaGrae

[Leith Ross]

Hello DaiyannaGrae,

ihich box do you want to add Cancel to?
How do you know if the user is on the correct worksheet?

[DaiyannaGrae]

I want to add the option to the MsgBox. The intent for this file is that the user can update each week as the reports are availible, by selecting the appropriate week and importing the data that has been downloaded in an excel document. It will be up to the user to select the correct sheet, as this will be used several times each week for different groups. here is the document that I am working with, and an example of the data that will be imported.

mock week 1.xlsx
ZCN50 Weekly Tracker FY13.xlsm

[Leith Ross]

Hello DaiyannaGrae,
,

Thanks for posting the workbooks. Having them reference is a big help.

Here is the code to add a "Cancel" button to the message box...

Please Login or Register  to view this content.

I am working on the other parts.

[DaiyannaGrae]

Thank you for helping! That snippet works like a charm!