master

  1. danhendo888

    Copy/paste macro so that it works for active sheet

    Sub TEST() ' ' TEST Macro ' '(Deleting whatever data is in LastSheet) Sheets("LastSheet").Select Rows("2:2").Select Range(Selection, Selection.End(xlDown)).Select Selection.Delete Shift:=xlUp Sheets("Sheet1").Select Range("A1").Select Workbooks.Open...
  2. S

    How Can I get cell values from multiple copied sheets with VBA

    Hello, I've list in my Master Sheet starts at cell B4. With below code, I can create multiple sheets and give different sheet names to them according to my list. Now I want to get cell values of G13 from these copied sheets and paste these values to C4 in my master sheet . Which codes should...
  3. T

    Excel Native Query Unlink/Refresh problem (BUG MAYBEÉ)

    Hi, I have a problem with the NATIVE Excel Query as follows: I have a master file that contains 5 queries loading data from 5 tables on 5 different files on a SharePoint site. I also have a MASTER QUERY that combines these 5 queries into one Master Query. All work fine when it is all...
  4. V

    Two different sheet data to be pasted on one another sheet

    I have a excel sheet where Sheet 2 named as 'master sheet' and sheet 3 named as 'revenue data'. I want to enter the company name in cell G2 in sheet 1 which will search the same name in column F of 'Master Sheet' and paste it in sheet 1 below master header. Similary the value of G2 needs to be...
  5. J

    Create a new sheet in excel

    Hi All, I have a two sheets a master sheet and a weekly report sheet. I need to firstly recreate the previous weeks weekly report sheet based on the cell value i put on the master sheet For example Column A ( Master Sheet ) is the week numbers A2=WK27,A3=WK28 Etc when i add WK29 into cell...
  6. danhendo888

    How to update a master sheet containing data of other sheets

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col...
  7. R

    Assistance with Importing Data From Other Excel Files

    I am working on a project where I am creating 6 Excel files. Five will be used by individuals to input data, and the 6th will be a “Master,” where I will import data from the 5 files used by the individuals to the Master to aggregate and summarize the data. On the Master, I have a “Log” tab...
  8. K

    recursive function to get all possible combinations

    hello world. i am trying to get all possible combinations of a single column array which all contain one master value. $master_value = "Z" $value_array[5] = ["A", "B", "C", "D", "Z"]so the possible combinations would be something like this (all would include the "master value") Quote Z,A...
  9. V

    VBA to copy data from master workbook to another

    Hi everyone! I have a problem with the following task: I have a master workbook where I record my data in 9 columns (B4:B54 to I4:I54) each has a header. I'd like to copy the values from this sheet to another workbook (Data). I've tried the Range method, but it works only with one cell. Can...
  10. O

    Rename Worksheets Using "Master" Worksheet

    Hello, I need to change the name of the spreadsheets in the Workbook using a "Master" list created in the same Workbook. I tried to use the VBA below but got a 400 error code. I appreciate any assistance...I feel it is something simple I just cannot figure it out. I was going to attach the...
  11. J

    VBA keeps closing BOTH workbooks (only 1 specified)

    Hi all - any help would be appreciated. I have VBA that loops through a tab on a 'master sheet', changing the club on the tab, and saves down as a separate file for that club. It repeats this for each club, saving the sheet and closing it down each time to return to the 'master sheet'. I have...
  12. J

    Need help with userform vba

    Hi, I have created a userform with 2 option buttons, 1 combobox and 2 textboxes, I also have 2 sheets Transfers and Master, if I select the add stock option button and fill out the rest of the form and click submit it adds stock in the master sheet column C which works fine the part I can not...
  13. M

    Data fill based on values

    Hi I need a macro/formula to pull through names of people if they have a value against a client onto the master spreadsheet I have separate client tabs, with people putting values against an activity. I have a master sheet which lists the clients under each column. I would like to pull...
  14. M

    Master Tracker - Summary Sheet

    Hello all, first time posting here! How can I modify this code to always look for the next available line? when I run this it just overrides whatever is already there. Any help would be GREATLY appreciated! TIA Sub add_diagnosticdeliverable() ' ' add_diagnosticdeliverable Macro '...
  15. S

    Populate a Userform at open

    Morning all I have an excel workbook I am using as a database with 2 worksheets "Project Master" with 72 Columns of data and "Project Summary" with 8 Columns of selected data from "Project Master". I also have a Userform "frmViewData" which when open is populated by selecting a Project from a...
  16. S

    Need help with a worksheet please

    I have a "Master Inventory Worksheet" that I need to subcategorize into route planners by county. I need the sub worksheet to lookup a cell in the master and if that cell has the correct county, I need the line data, which is in cell format, to populate into the sub worksheet. So, If the "King...
  17. A

    Automatically adjusting tables?

    Hello all, Let's say there is new data set is put into sheet "MASTER" on a weekly basis. The rest of the sheets are all tables populated using "INDEX MATCH" pertaining to data found in "MASTER." How would you have the tables automatically adjust number of rows to account for new/deleted...
  18. M

    Sort issues with VLOOKUP

    Hi, I'm having trouble sorting data and having columns return the correct data when I use VLOOKUP and IF statements across multiple worksheets. A few details: 1. I have all worksheets formatted as a table because I will be connecting to Power BI. 2. Sheet 1 "DATABASE - MASTER" is where most...
  19. C

    Tables - Multiple Worksheets - Automatic Filtered Update

    I've created a simple action list template with source filters (the master). I need to create a separate tab for each source that shows only the actions originating from that source. Ideally when the master list is changed, the table on the source tab would update automatically. Any help /...
  20. M

    Pasting rows in new workbook from specific column items

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

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top