master database

Hello, I have multiple excel files inside a single folder named "X". All those excel files have the same first row with the name of the columns. The different columns of the first row are : identifier 1/ identifier 2 / characteristic 1/characteristic 2/ characteristic 3 / characteristic 4 /...

Hello. Glad to find this forum!!! I have about 38 users each with one excel workbook that contains the 3 sheets. I would like to create a MASTER Workbook where I can have the 3 tabs and that can automatically update the information inserted in each workbook. for example if one of the tabs is...

Hello, I am a beginner to VBA, and I am currently trying to create a macro which takes data from a central folder (e.g. "7_5_2017_DatasetA.xls" will be dropped in a folder with revised information from the last entry "6_5_2017_DatasetA.xls") and pastes it into a centralized folder. However...

Hi everyone, This is my first time here and I'm a self-admitted newbie at Excel. I think this might be a simple problem but I really, really, really don't know how to proceed. Any help would be great. Honestly. I'm using Microsoft Excel 2010. Now in my Sheet 1, I have created a Table with data...

Hi everybody, I have a workbook to calculate costs and expenses of orders from different exports. Every week I receive 2 exports and put them in different tabs. Both the exports are not in the same structure so I modify one using an extra tab. And at the end I have 2 tabs exactly in the same...

Tried the below code with minor modification to select file referred from Open 132 files and copy data into master file My problem is its not copying the entire data. Copies only few 3 or 4 rows. Please help Option Explicit Public Sub CommandButton2_Click() Dim Master As Workbook Dim...