file2

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...

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...

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...

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...

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...

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...