master

I am working on a Classroom Files. Where i have many files containing report of each test like Test 1, Test 2, Test 3... I have to make a Master workbook that will contain the Mark Columns from All the Test Files I tried the PowerQuery ( I am very much new to PQ) but failed as it was...

Hi I am trying to create a userform in a MASTER workbook where I want help in listing all Open workbooks including CSV files listed in a Userform combo box. This combobox should include all open workbooks including the ones which are not saved in the local drive. The master WB should be...

Hi, thanks for looking? When I download some nominal data from the finance systeminto excel the supplier number (which is a mixture of letters and numbers) appearseither at the start, middle or the end of a text string including otherinformation. Therefore if I am wanting to do a vlookup against...

Hello again - I have several individual password protected workbooks - one for each employee, each with a unique password - that collect that employees timekeeping data. I'm trying to make a master sheet that will pull data from each of these individual files into one master file for me (the...

Hello Team, I have workbooks stored in the folder with the different names, i have to create a master out of those in one workbook. Workbooks stored in the folder contains name starting from Apples_x.xlsx ddd_Apples_Y.xlsx CCC.Apples.xlsx Grapes_dd.xlsx Grapes_PP.xlsx Each workbook contains...

I am just discovering the power or Power Query for Excel I need to run merge queries to populate data on my daily file from the same master file every day and am trying to streamline the process. My current process Open my daily file Get & Transform From Table/Range In power query editor.. New...

So I have an interesting one for you all. I have a master workbook I made for a gradesheet and put it in the public folder. When a new class starts the instructor will make a new folder for that class and copy the master book into that folder. It is still in beta mode, so as the classes have...

Hi All, Virgin poster here, rookie VBA user...please be gentle... I have a Master workbook which automatically compiles various worksheets drawn from different Project workbooks (no code involved, just links) Besides the linked data, I also need to copy/paste tables and graphs depending on...

Hello So I have manged to find a formula to help produce a list of unique names based on rules, but i can only get it to return the first name from the whole list. {=IFERROR(INDEX(Master!$B$2:$B$500,MATCH(0,COUNTIF(H$2,IF(Master!A$2:A$500=H$2,Master!B$2:B$500,H$2)),0)),"")} "Master B" is the...

I have a file that i was wondering if there was a way to write this code differently or easier. The file has 7 worksheets and a button page. i want to clear all worksheet and end up on cell A2 of the button page. Here is the code: Dim sht As Worksheet For Each sht In ActiveWorkbook.Sheets...

Hello All, I have a requirement, where in i have a master sheet, with Sheet Name reference, column Name, what i have to do is =Sum(sheetname reference with indirect formula),column Name reference in master sheet, where the columns in data sheet is in A5:D5).

Hi all, New to this board, and hoping to get some good advice. My team conducts a lot of data pulls to create reports, and they are all very time consuming. I'm trying to better educate myself in becoming more efficient in excel. One of the reports we do, is a Reconciliation between two...

I am a novice formula writer and I am working on a spread sheet for a non-profit group. I am trying to search a name in a certain column on a master sheet and return the entire row to another sheet. The column on the master sheet contains more than one row with the name I want to search. Can...

Hi all, New to this board, and hoping to get some good advice. My team conducts a lot of data pulls to create reports, and they are all very time consuming. I'm trying to better educate myself in becoming more efficient in excel. One of the reports we do, is a Reconciliation between two...

Is it possible to use structured references between workbooks. I have a data work book which is pulling data from a table in a master sheet using row / column references and this is causing me an issue if a column gets added in the master sheet and I want to use structured references to get...

I have a master schedule file to compile projects from various managers. There are four phases with start/end dates. I'd like to be able to enter the dates for the phases, and have the colors change in the cells to the right of the dates based on the entered dates. Is this a stacked conditional...

Hi there I have several workbooks in one folder that I need to open and copy a number of cells (G2:O2) from the same sheet name ('Output Create') for all of the workbooks into a 'Master' spreadsheet. Within this Master spreadsheet Column A contains a name of a place, which partially matches the...

Hello all, first time here! I'm not proeficient much with VBA, hopefully someone can help me. I need a VBA script to create a dynamic amount of sheets at once based on 12 different cells value, from 3 different template sheets (I need to keep those 3 templates formula intact) and based on some...

Hi - any idea how to vlookup or sumif or ... from multiple .csv files into one master file? The master and .csv files would be saved in the same location, and the filename of each .csv would be stored in a cell in the master file. The .csv files would not be open when the master is open (and...

i am sent a spreadsheet each day of performance. I have a recorded macro that deletes all the data not relevant to me which leaves me with 5 rows/10 columns of data. The columns are constant each day. I would like the macro to proceed in copying that days data onto a separate master spreadsheet...