master

  1. Welsh Mark3

    Instances of DBA

    Is there a formula that can give me the string of text after an intsance of DBA. Assuming the original text is in Column A <tbody> Original Text Desired Result Elite Southern Construction LLC dba Master Roofing Master Roofing Riland Richardson, Inc. Dba C & R Trucking C & R Trucking...
  2. gheyman

    Access Query Type?

    I have two tables. Both have a field called "Quote Number". One table is called "Quotes Master Table" and the other tblProposalStatus I need a list of all Quote Numbers that are in the Quotes Master Table and not in the tblProposalStatus. I will then need to append those Quote Numbers into...
  3. H

    Copy worksheet tabs to other worksheets and rename

    Suppose I have a master workbook with 3 tabs "Master", "Quotation" and "Order" When I fill information in "Master" tab, forms will generate in the two tab. After that, I have to copy tabs to another workbooks, say "Quotation 2018.xlsx" and "Order form 2018.xlsx" (they are in the same folder...
  4. H

    update master file from multiple files

    Hi, I have a master file with headings in row 1. In another folder and its sub folders there are multiple excel files and the headings are in different columns instead of rows and their values are in in next column i.e. a heading like "Location" may be in cell B5 then its value will be in next...
  5. R

    Finding Employees on a Different Sheet

    Good day, I have a full list of employees on one sheet (master sheet). And a few other sheets (sheet 1, 2, 3, etc...) that will be filled in with the employees name. What I need is to have a formula on the master sheet that looks at Column C, Row 4 and down on each sheet to compare the same...
  6. D

    need a macro to fill data from Master table to individual sheets.

    I have Following Master Table in Sheet1 <tbody> Column A Column B Column C Column D Column E Column F Column G Row1 Cus_Code Inv_Date Inv_No Cus_Name Value VAT Row2 BBE 18/07/2018 SV4525 A CO .LTD 11899 1785 Row3 BBE 20/07/2018 SV4531 A CO.LTD 16667 2500...
  7. D

    A Macro to Fill data from Master table to individual sheet( Dynamic Table)

    I have Following Master Table in Sheet1 <tbody> Column A Column B Column C Column D Column E Column F Column G Row1 Cus_Code Inv_Date Inv_No Cus_Name Value VAT Row2 BBE 18/07/2018 SV4525 A CO .LTD 11899 1785 Row3 BBE 20/07/2018 SV4531 A CO.LTD 16667 2500...
  8. F

    Stack Multiple columns into one on Master sheet

    Hi Everyone, I would like to create a vba that helps 1) Create a master sheet 2) Loop through all worksheets starting with " Data" 3) Copy column DH onwards to last column and stack them in one column on Master sheet , pasting them as values 4) If master sheet exists, to just replace...
  9. N

    Summarized master worksheet from several other sheets from other workbooks

    Hello, My name is Niclas. I would really need some assistant on which approach to take for the bellow topic. What I would like to achieve is the following: - I have several workbooks containing one sheet, with a lot of specialized formatting with a lot of different information. - What I would...
  10. B

    Match+Indexing within conditional formating.

    Hello all, I have a spread sheet with three columns, A master list, master approvals, and a checklist. The first column is the master list of serial numbers, and the master approvals column next to it says whether or not the unit is approved (Yes, No, or blank). These two columns correspond to...
  11. E

    Consolidate multiple user's data from different sheets to single master excel sheet.

    Hi Everyone, I am trying to figure out a way to consolidate multiple user's data from different sheets to single master excel sheet using Macros. Eg: . user 1 selects particular rows and once macro is run, these data should automatically get pasted in the last empty rows in master excel sheet...
  12. T

    Macro to copy cells due to certain cell value and past to bottom of rows on a new sheet

    Hi, I am having difficulty with a copy and paste macro. I currently have a workbook in which I have a "Master" Sheet and a "ODBC" Sheet. I am wanting a macro to look at cell values on the ODBC sheet in column T and if they read "New Starter" I am wanting it to copy the aligning cells from...
  13. M

    Convoluted problem

    I have been asked to create a workbook that consists of approx. 70 different sites, each with their own sheet, that ppl can use for equipment tracking and projects. I have a "master" sheet with all of the sites and their assets and a pivot table summarizing the data from this "master" sheet...
  14. D

    NESTED IF & VLOOKUP Formulas returning the correct data, but ...

    Hi All - Please find my "code" for a working IF(VLOOKUP... that does capture the data from the references table successfully. To start at the beginning, I have 5 value tables where data is being pulled from with a master table that is pulling the data from the 5 tables. My issue is that cells...
  15. H

    Create Sheets, separate records, copy-paste cell values from master to created sheets

    Hello All, I have a master sheet with a table listing 260 items and their tech. specifications - under 20 headings. I need to create a separate sheet for each item of the 260. Naming the created sheet by its item code, which is listed in the first column in the master table. The created sheet...
  16. S

    move data from multiple files inti master

    I have 5 different files where my team make entries. I have one master which fetch data from those multiple files. Once data fetch is done. I want fetch data should delete from those 5 different files. So that when next time i fetch data it should not include data which is already in master.
  17. H

    Copy Cell Value to Master Worksheet When Changed

    I have done almost all of the things I want to do at one point or another, but never together. I have searched and seem to not be using the right terms, so if there is a better search term to use, I would love suggestions. When a cell in Sheet 2, column B or C is changed on one tab, (C5 for...
  18. V

    Modify where existing VBA pastes

    Good morning. I need some help altering existing VBA. Right now, the code will paste under the last used row. I would like to modify this so that the copied data is pasted starting at B5 of the master, with each file pasting underneath. What I currently have is this: 'set to the current...
  19. J

    Copying master page, renaming from cell in index and hyperlinks!

    Hi all, I'm very new to this with no experience of writing codes, so looking for some help please. I have created a workbook in order to log work completed per month, it has 3 sheets in, 'Master', 'Worklists' and 'Customer Index'. 'Master' is a table for entering work logs and calculating costs...

Some videos you may like

This Week's Hot Topics

Top