workbookb

  1. H

    Copy Rows from all sheets to new workbook

    Hi - I'm looking to copy columns A-Z, Rows 20-30 on every sheet in WorkbookA. I want the sheet name put in A5 of WorkbookB, and then A20:Z30 in A6. There would be 2 blank rows and the next sheet name and range would be pasted into WorkbookB and so on. thanks!
  2. J

    Copying range from every sheet in 1 workbook to another?

    Hi, I have 2 very similar workbooks with same tab names. I'm wanting to copy range (A1:S100) from every sheet in workbookA and paste at U1 in every relevant sheet in workbookB Can do it with VBA one at a time but looking to see if it can be done in one go with a loop etc. Any help appreciated
  3. O

    Cannot open hidden Excel Workbook

    Hello People, I need help. I have two Excel Workbooks (call them WorkbookA and WorkbookB). I have code in a command button in WorkbookA to open WorkbookB. Everything works fine until I hide WorkbookB (using the OS, so you cannot see WorkbookB). When I do this the VBA code behaves as if...
  4. S

    Referencing Closed via open workbook external links - VBA

    EDIT: Sorry, the title should have read: "Referencing Closed Workbook via Open Workbook's external links - VBA" --------------------------------- I have some code in WorkbookA where I ask for the location of WorkbookB (the data and location constantly change). Via a prompt I am able to select...
    • spydey
    • Thread
    • closed workbook read external link update values vba & excel 2013 workbookb
    • Replies: 1
    • Forum: Excel Questions

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