copying between workbooks

Hello! I've been struggling with this code: Sub Select_File_Or_Files_Mac() 'Select files in Mac Excel with the format that you want 'Working in Mac Excel 2011 and 2016 and higher 'Ron de Bruin, 20 March 2016 Dim MyPath As String Dim MyScript As String Dim MyFiles As...

Hey everyone, this is my first post here since I'm new to VBA. I'm not good at coding but I will provide you with all the information I have right now. Summary: My goal --> Macro Step 2: Trying to create a macro to consolidate data from multiple workbooks / Suppliers into one Master-File...

Hi All I have a piece of code which simply copies data from all cells in one workbook and pastes it into a table in another. However I am finding that one column (Column N) which is in a "MMM-YY" format keeps changing the Year part from 17 to 18 when it paste values over. On the raw file all of...

Hello, I'm trying to literally copy a worksheet (a) onto a completely new workbook (b) and have workbook (b) update automatically with any changes from worksheet (a). i don't care if the formatting from the worksheet (a) doesn't follow through to the workbook (b). I have been copy and pasting...

Hello Excel Gurus, I have a Workbook at my office that produces TV Edit Reports based on what the employee enters. Upon clicking a save button, the sheet saves a certain range of cells in that sheet (with their values & formulas) to a brand new shiny workbook, saves it and closes it. Another...

Hi, I have vba code that sits in a specific worksheet called 'tracker' that I now want to copy and save to the 'tracker' worksheet of some 500+ workbooks. These workbooks are already populated with data so the vba is to be inserted into the 'tracker' worksheet and then saved. The files are in...

Dear all, First off, thank you in advance to anyone who posts an answer to this question - I really appreciate your help! I am using Excel 2010 to try and make a macro that will try and automate a rather tiresome process of creating many excel workbooks with certain information extracted from...

So here is my issue. I have fumbled around multiple forums trying to find the answer. I am new to vba for excel and I have hacked together a macro from bits of code I found in these forums. It does what I need it to except for one caveat, the second part of the macro uses a set range but i...

Heya, I'm having an issue getting an array of cells that (the contents and range of which can change rapidly) from one work book to another and getting some quite strange results. Firstly I tried to just copy over the entire thing but it seems that the two workbooks have different formats or...

Hello, I am basically trying to do what is shown in this video. I want to do almost the exact thing except that all the files 538, series1, series2, series3 are in separate workbooks (4 different workbooks). I have tried changing the parts of the formula that make reference to the 538 tab...

Hi there. Basically, i'm trying to copy and paste certain cells from one workbook, to another, I've looked up many other threads but couldn't find anything specifically that can help me. Basically what happens in this excel workbook, is I have a Command button that will call this macro, to...