import sheet

  1. M

    Importing sheet into workbook

    I had been previously using the code below to import a sheet into a workbook and it was working fine with the quarterly file I was using. I am now trying to import the current quarter file and I am getting a run-time error 91. Does anyone know why I would be getting this error? Dim fName As...
  2. P

    Multi-variable lookup across range of variable sheet count

    I have a three-sheet workbook intended to distribute tasks to employees. Sheet1 is a dashboard, Sheet2 is a table with primary tasks (some 1000), Sheet3 is a table with secondary tasks (some 1300). The employees are imported from another workbook via a PW-protected button as new sheets that they...
  3. B

    Select Sheet from External Workbook

    Hello. I have a userform where a user will select an external workbook that will then import the sheet to the current workbook. The issue that arises is when the external workbook has more than one sheet. So, my plan was to have another userform pop up when the external workbook's sheet count is...
  4. C

    VBA to import Sheets from other workbooks

    Hi! Could any of you please help me with this? I have a file - GetData - where I would like to run a macro that would go to a folder (has 2 files), and for each file it: copies sheet1 and pastes it into my GetDatafile. I would also like that this new information on GetData file would replace...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top