master

I have a workbook with a master sheet and corresponding individual sheets based on class #'s. How do I paste multiple rows (i.e. rows 3,6,14 and 21)fro the master worksheet because they match the class number (Column B) into a new worksheet (call it class 001)? All the information in sheet 001...

So i have been trying to get a Userform which transfers a selection from 2 listboxes into a single multicolumn listbox to work. With the help of this forum i have also been able to pass that data over to another "Master" Userform. What i am now struggling to do is 2 things. 1. When the command...

Dear Sir, I need to merge excel worksheets from multiple files in a single excel (master) file accordingly to their worksheet name. - If the worksheet already exists in the master file then it will insert (merge) data / rows below to existing data row in the master sheet or if not...

Hi - looking for help I have MI on 3 tabs which I want to easily Copy and Paste into a master tab in month order please https://drive.google.com/open?id=1Q5...1aVd313i3gGa-Z

hi all, I am wanting to add a bit into the merge sheets macro I use but it throws a Next without For error. The extra few lines (below in bold) seek to not merge the sheets in the workbook where there is a match to the sheet names held in a named range. Sub CopyFromWorksheets() '/// This...

Dear All, I have two worksheet (i.e. Emp_Master & Leave_Paid) I want to update Leave_Sal paid amount from "Leave_Paid" sheet to "Master" Sheet For Example Leave_Paid sheet a2 having emp no 1111 then Macro to copy that number and search in "Master" Sheet Column "A" and then it should Copy...

Hi, Please can someone help? I am trying to create a list from a master list based on a criteria. Below is an example https://www.dropbox.com/s/ui61g35ycc...nshot.jpg?dl=0 Basically, I want to create a list from the master list in row A & B I want to use the account manager name in cell D3...

I have an issue that is similar to the one discussed in the thread at https://www.mrexcel.com/forum/excel-questions/769002-worksheet-cells-dependant-eachother-circular-reference-problem.html; however, it stretches across multiple tabs. This is a spreadsheet used as a statistical scorecard for...

Hello, I am very new at writing vba. I copied a code that takes information entered from one workbook by hitting the submit button it then takes my data, opens the master log, transfers the data onto the worksheet horizontally, saves and closes both workbooks. example below of code being used...

I am trying to automatically transfer data from multiple workbooks into one master workbook. All workbooks are in the same folder. The data is off various column and row size and contained on only one sheet in each workbook. There are a total of 6 worksheets in the master. Example of what...

I’m looking for some help in converting my current code into a range instead of a full sheet Instead of merging sheet 1 from multiple workbooks into a master workbook, I only need to copy a specific range on sheet one of each workbook and paste it within the master workbook. I need each sheet...

I am not sure if this is possible, but I have a master file with 6 columns. The first column has text corresponding to sheet names (a total of 13 sheets). What I'm looking for is a macro that would move data from the master file to the corresponding sheet based on Column A. For example, for...

Hi - I have 5 staff members that each have an individual workbook with pivot tables linked to data held another MASTER workbook that is password protected. I need VBA code that will automatically refresh all the pivot tables in the Staff workbook when it is opened - but without opening the...

Hi everyone, Not to savvy with VBA data gymnastics however I am more familiar with excel formulation. I have a bunch of workbooks in folder 'C:\Users\BCR\Desktop\TSA' i am only interested in one sheet 'Custom Award File' and only interested in columns A-I. The first row is row title and i want...

Hi, I need to combine contents to 7 of the 10 worksheets in a workbook that all have the same column headings. I would like it to combine on a master sheet that i can go in and refresh once a month. Please Help!!

Hi can you let me know how to code the below, I have 3 files named Belarus, Belarus2 and Belarus3 and i need to paste the the below from each of the files into master file.Would it be possible to execute all at once. I have all the files saved in the folder in the path "C:\Users\Priyanka...

I'm using Power Query to pull data from 3 different tables within the same workbook. Once that data is collected, I'm putting it in a master list. This master list table has additional columns of data that can only be added after the master list is compiled, and these additional columns are...

We have a master database that holds a lot of data. We want to migrate this to SQL. The issue becomes we do not know who all accesses this database and what other databases/processes have links to this database. What are your best way to determine what all connects to a master database? I...

Hello, I need help transferring results from one sheet to the master sheet. The users are only listed once on the master sheet, but some users have multiple results. Vlookup only returns the first value so I need help getting each thousands of users results in one cell in the results column...

Here's an easy one (for those of you who are not ME, that is)... I have a multi-tab workbook that includes a MASTER sheet as well as (usually) a sheet named "UNKNOWN". My code copies some data from MASTER to UNKNOWN...BUT...what happens if "UNKNOWN" isn't there? I'm sure it will crash because...