strextension

Here is what I am trying to do. I have a few spreadsheets in a folder (c:\dump\tally). I am trying to grab the data found in A3:AA3 for each of these files in the "Rollup" tab and drop them into the Excel file hosting the macro in the Sheet1 tab. And since the source data is mostly formula...

Hi ... I have multiple workbooks saved in a folder and the code below seems to only work for my first file. However, I need it to work for all the files in the folder but can't seem to see where I have gone wrong. Dim wkbDest As Workbook Dim wkbSource As Workbook Dim shtcopy As Worksheet...

Hi I'm using the below code to copy data from multiple spreadsheets into a master spreadsheet. It works fine but I want to add a column (F) to state which workbook it was copied from. can some one please help me with that. so if data was copied from workbook1 column F would say workbook1. Sub...

This is a modified script from this forum and it serves it purpose well. But I the issue I am having now is that currently the script copies a bunch of values from a DIR and paste it in the main worksheet. But in this the DIR the tab names of the sheet varies so the code breaks when it...

Hi Community I would like to explore the possibility of copying data from different workbooks to a Master sheet. Based on some of the threads, i have tried the following code: Sub CopyRange() Application.ScreenUpdating = False Dim wkbDest As Workbook Dim wkbSource As Workbook...

Hello Folks, I have a folder in which i have 10 workbooks name(1 ,2 ,3 ,4......10), Each workbook has 10 sheets name (1 ,2 ,3 ,4..........10). 11th Workbook name "Master" has a command button , as soon a user clicks command button , macro loops in each workbook in folder and copy B2 :B27...

Hey all, Mumps kindly provided the below which enabled me to extract information to a Worksheet called 'Raw Data' from various sources which contained a worksheet named Sheet1. I've developed the sources worksheets in that the cells where the information is pulled through from now contain basic...

Dim wkbDest As Workbook Dim wkbSource As Workbook Set wkbDest = ThisWorkbook Dim LastRow As Long Dim strPath As String strPath = Range("G30").Value ChDir strPath Dim strExtension As String strExtension = ("*.xlsx") Do While strExtension <> "" Set...

Hi All, I m using below code for merge sheet but its asking for clipboard while paste every file (there is a large amount of information on the clipboard,Do you want to be able to paste this information in to onother program later?. I have 20K to 40K rows in every sheets.Please help Sub...

Hello, The current Macro code works and it basically copies data from closed workbooks stored in folder ("C:\Users\jsmith\Desktop\reports") into Sheet1 of the Active Workbook: Sub CopyDataClosedWorkbooks() 'Turn Screen Refresh Off Application.ScreenUpdating = False...

Hello, I have the following code that works that essentially copies and pastes from multiple closed workbooks into a workbook of my choice. I need some assistance in tweaking the code to allow a user to select a user folder of their choice instead of hard coding the folder path in the VBA code...

Hi all, I have a piece of VBA code which searches through all the .xls files in a folder and looks for a particular word then pulls out other info in the same row if it finds it. It as working great until some "useful" person on my team decided they wanted to reorder the folders and create a...

Hi All, First time user. I have the following macro below which splits the same tab from multiple workbooks and copies them into a single workbook. I have a file directory location as highlighted below which stores all the excel files that i want to split into one sheet but for some reason the...

Hi, I'm creating a macro to spool through all workbooks I have saved in a folder and paste the results into a single file. I was able to find most the code I needed from this thread: https://www.mrexcel.com/forum/excel-questions/899169-vba-copy-data-multiple-workbooks-into-master-sheet-2.html...