master

  1. A

    Deleting rows based on multiple different values....

    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...
  2. O

    Child Sheet updating Master Sheet (Pivot Table / Power Query)

    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...
  3. H

    Vlookup with multiple occurances of a value

    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...
  4. V

    Macro need Help

    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...
  5. A

    Compiling 2 different sets of data from multiple sheets into 2 master sheets

    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...
  6. E

    VBA to Copy Range from Muliple Worksheets in one master

    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...
  7. M

    Enter a day number, and show day/month/year from another cell

    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...
  8. N

    Excel VBA automatically copy entire row to different sheets based on cell value

    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...
  9. S

    Macro to loop thru sheets adding new columns until it hits particular sheet then stops

    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...
  10. E

    Include sheet name in formula - look at different sheet

    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...
  11. G

    Merge data from one worksheet to another

    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...
  12. C

    Sheets feeding into master

    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.
  13. B

    Vlookup multiple sheets

    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...
  14. N

    How to split multiple worksheets of data by column value and output to separate files?

    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...
  15. ClwnMan76

    Queries - Super Quick Question

    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~
  16. M

    Importing Multiple Sheets into One Master Sheet GoogleSheets

    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...
  17. L

    VBA Match problem

    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 =...
  18. Johnny Thunder

    Excel File Size Question - Why is my file 36Mb with minimal Data in it? - Excel 2016

    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...
  19. H

    VBA allow edit only when sheet is copied

    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...
  20. E

    Highlight one workbook cell if another workbook cell has a value

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top