file2

  1. D

    A workbook from Input box to place in table on worksheet

    I have a macro that will ask for a date to append 2 workbook names and copy their data into the current workbook. I would like to add the names (File1 and File2) to a table on a worksheet in the current workbook. So this table will grow as the workbook data is added incrementally. I am having...
  2. A

    VBA Macro to Open Read Only Excel from SharePoint and Enable Edit Workbook

    Hi all, I am currently in the process of trying to create a macro to run from my current workbook (file1) and be able to open an excel file from SharePoint (file2) to refresh and update using the data from (file1). The only problem I am running into so far is when opening (file2) it is...
  3. M

    Using VBA to Create a Hyperlink

    Afternoon All, I'm trying to create a way to have my master file lets call it file1 have hyperlinked connections to some of my other files lets call it file2 with the file2 document number that will be in cell D2 to be the name displayed as the hyperlinked name. However It would be really good...
  4. B

    search entered value macro / farmula.

    Hi All, Am trying to search entered value which is "item code" in another excel file and bring the item name and put into next column. File1: A B 1 Item Code: Item Name 2 1001 Red Dress 3 1002 Green Dress File2...
  5. D

    VBA to copy/paste

    Greetings All, I have a spreadsheet which sends account information every 30 minutes 24/7 via Outlook to company executives. My original code worked but was a little buggy sometimes and tied up my clipboard until the script was through copy/pasting. I posted in this forum and received a new...
  6. D

    vba error when copy/paste without clipboard

    Hello all - I'm receiving a "missing object" error in the below code. This is only a smidgen of much a much larger code which copies 100 text files into 100 worksheets. The range in File2 may vary, but will never be larger than A1:R55. Any assistance in having this copy/paste without...

This Week's Hot Topics

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
Top