master list

  1. W

    Help creating workbook with master sheet

    We are a medical office. I am trying to create a workbook to track missed notes by each doctor. I want to enter information into a master sheet then have additional sheets populated by doctor. Master sheet Info: Patient Name Date Doctor then have a separate sheet by doctor with same info...
  2. J

    VBA - Creating Master List (from different worksheets)

    Hi All, I'm new the forum and have very limited VBA experience. Would really appreciate ANY help with my issue. Right now, I have 3 different sheets of data, with different number and order of columns. I need to create 1 master list that combines the data from 3 of these sheets, thought not...
  3. T

    Create sub list from Master list- not by any criteria

    What I need seems simple but I can't figure it out and searching with no luck on answers. For my construction business, I have a master list of all subcontractors possible to use (312 of them) with all of their contact info. For each job I want a list of the specific subcontractors working that...
  4. M

    How to copy rows from multiple tabs into one master sheet

    Hi All, First post on the site so please bare with :) Im creating a document which is going to be forecasting sales for different products and to save time and not have to manually copy and paste i would like to know if its possible if a macro/vba code could achieve this obviously i don't wan...
  5. B

    Attendence List + automatic update to master list

    Hello! I am not very proficient with excel, and im not even sure if this is possible. I am managing a training session using excel. The file as 3 spreadsheets, the first and second spreadsheets have the list of people coming to the first and second classes (around 16 people per class). There...
  6. G

    master list into sub lists

    I am working on a team list. I have the manager names and all of my agent names. My problem is that the rosters can change anywhere from a monthly basis to a weekly basis. This makes calculations on my reporting much more difficult. Is there a formula to maybe put all the managers names in...
  7. B

    Help w/simple two step macro - Excel 2013

    Hey there, I'm using Excel 2013, and hoping you can help me piece together the code to create a simple macro. I have an Excel spreadsheet that acts as a simple statement generator by populating a number of cells based on a VLOOKUP against a master list of account numbers. The user enters the...
  8. N

    VBA Exclude ROWS from copying to other sheets

    Hi All- I am trying to create Master List (sheet) that will merge all other sheets in the workbook. At same time I need it do following, i got first one to work. Exclude several sheets from showing up in Master list - Done :smile: Exclude Heading rows from all these sheets when i bring it into...
  9. M

    Master List.

    Can someone guide me in the right direction: I have a master List that has 5 columns the uniqueness of one of the columns is that it is the SS Number, what I like to do is this: If I type the SS No. in a New workbook or a new sheet, is it possible to auto fill the whole row to the left and right...
  10. C

    Take listed items from 3 worksheets, paste them all into a master worksheet macro

    Hello, I'm brand new to this forum so the usual apologies if this is not appropriate place or specific subject. I'm working on a project in excel that essentially loops through worksheets, which each have a simple list of items, and copies those items all onto a master list. I'm new to VBA...
  11. G

    Combine text cells using common id numbers

    Hi, I have 15 spreadsheets, each having a column of id numbers for chemicals and a column of corresponding chemical names. Each file is a list of chemicals that cause one condition. Each file is a list of chemicals that are either recognized or suspected of causing a certain health condition...
  12. T

    Populating Master list from multiple sheets

    Hope someone can help... i have generated a list of "Companies on the ASX" (Australian Stock Exchange) There are several work sheets (all populated from data queries) of companies within different sectors e.g all companies within the "energy" sector and so on (one sheet for each sector) i...
  13. N

    Sum Duplicated Cells & Then Delete

    Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I have read over numerous threads on how to do this, but I am still not able to piece together the correct code to make it work.<o:p></o:p> What I am trying to do is write some VBA code to...
  14. A

    Need help creating a database that will automatically update.

    I'm currently working on a database that will contain employee information. I would like to be able to update the master sheet, but have corresponding sheets for each one of our six locations. That way if I put in a new employee and assign them to LOC 1 (on the master sheet), they will...
  15. N

    Autofil/Create a sub list from a master list

    I have a master list that I use to track all clients, potential and acquired, along with additional details. I want a sublist that is automatically updated/created based on the information added to master list that contains a list of clients based on a certain criteria found in a column in the...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top