master

I have a sheet of about 1000 rows ... So there are 11 rows of Master Order numbers but only 5 different Master Orders. Some Master orders have Slave orders, some do not. If a Master order has a Status of 12, 13 or 14 or a Type of 02 I need to remove that row. The problem Im having is...

Hi everyone, I'm going to post a link to a question I asked in the Excel subreddit. I will also paste the original question here, but note that a discussion ensued which brought me here. Please read the comments to see where myself and u/gravy_boot managed to get to, before we got stuck. OP...

Hi. I have a master postcode list and have been using Vlookup to check if my postcode is in the master list and to bring back info from neighbouring cells in the master postcode list. This was working well until I found that my postcode could occur more than once in the master list (with...

to combine multiple sheets from one workbook to another worbook. I have one SHARED workbook "Tasklist" with mulitple sheets (all sheets have the same data) and another workbook called 'Master". I would like to combine the all sheets starting from Row 2 and display it on A5 onwards in Master...

Hello all, I am a VBA newbie and I am currently trying to get my head round a code that will copy and paste data from 62 sheets into 2 master sheets within my workbook, each separate sheet has a variable amount of rows that will need to be transferred. There are 2 different data sets I am...

Hi All, I am hoping someone can help. I have a spread sheet with 30+ tabs and I want to copy certain named tabs for the same range on each selected tab into 1 master sheet. The below works if I have only 1 to exclude but I have multiple to exclude . how do I amend to either include 20+ sheets...

Hi, I’m getting tired of entering dates into a spreadsheet. I have a master date for each month (example: 1/1/2020) and want to create a formula so as I enter 5, the cell with the formula will show 5/1/2020 - relevant to the month/year of the master cell. I tried the DATE formula but could...

Hi ...My excel have multiple sheets as below: 1) Master Data 2) Region A 3) Region B 4) Region C 5) Region D I need to have a VBA coding that will COPY entire row automatically into a respective sheet if the cell value match according to the "REGION". Whenever changes was made in the Master...

Trying to write a macro that will add 2 new columns (A & B) to each sheet in the workbook, adding header names & color coding, but need it to stop when it reaches the tab named "Master" Below is the code I have so far, but keep getting a compile error in the 'Start loop' section Sub...

Hi I'm creating an Excel workbook that contains edited info from another (to send to a third party, so hiding is not an option) Both are made up of numerous tabs. My current formula is: ='[Z CONFIDENTIAL MASTER EQUIPMENT LIST.xls]B2 01'!C10 Is there a way to replace the bold tab name in the...

I'm trying to merge data from a weekly report into a master sheet that runs calculations. The weekly report is always formatted the same, and the calculation sheet will be as well. What's the easiest way to import data from the report to the master? I.E. F33 on the report will always need to...

Is it possible to have a master document that links to several other workbooks.Once someone completes a questionnaire for example,the data automatically feeds back to the master document? Anything similar will do.

Hi, I am currently working on a worksheet, and on the sheet there are 4 tabs which have the same layout but each is a different cost centre. I need to do a check to see if one number on a master tabappears on any of the 4 cost centre tabs. Basically I need a vlookup across the 4 tabs but in...

I have an Excel 2010 workbook (let's call it 'Master') with many worksheets, whatever name. Each worksheet has data structured as shown below. One of the columns has an identifier, such as a supplier code. Both sheets on the Master are sorted on Column1_header. Note: The actual structure is...

Trying to decide how to present something to my client and this question came up since I'm brand new to Queries. Say Your Master table is on one sheet and you have a query on Sheet 2. Is there any way scenario in which a person could change a cell in the Query and it updates the master? ~Todd~

II am trying to extract all data that has dates in Col 1 from multiple sheets to one master. I would also like to make that master sheet in date order and have it auto sync whenever I add anything to any of the sheets. I tried to follow a video, but it didn't work. Here's the formula I was...

Hi I have a master workbook that opens another workbook. On the opened workbook, there is a date. I want to find the column in the master workbook that contains this date and I'm having an issue with the following line of code: Week_Column =...

Hello All, I am so lost right now. Here is my dilemma, I have a file (saved as .xlsm), it has 6 spreadsheets in it. 1 - "Master Data" Sheet has all the data from the file, 44 rows of data, 15 columns wide. 1 - "Slot Analysis" Sheet that has 4 small grids of data that interact with the...

Hello All I have a sheet (Master) where I have protected with password were I do not want anyone to change or modify. However, when sheet is copied and named as "today's Date" I want it to be unprotected so that it is changeable and can be modified. Perhaps when someone attempts to change...

I have two workbooks: master and source workbooks. I am trying to have an error checking tool that when a certain cell in the source cell has value "Y", then the a cell in the master file will be highlighted red. A few things to note: 1. The two workbooks have the same worksheet names, for...