master worksheet

  1. N

    VBA for Combining 1st sheet of every workbook in folder into one master-sheet of new workbook

    Greetings, I will get directly to the point. *What I Have. 1)-I have one folder which contains multiple excel workbooks. All of them are in .xlsx format. 2) Each workbooks has multiple worksheets 3)The important sheet for me is the first one of each workbook, which has a dynamic name i.e. the...
  2. D

    Consolidate 4 Excel Project Lists (Workbooks) to a new Master Project List using VBA

    Hello all, first of all I'm a beginner in VBA and I really could need some help with a VBA code. My task is to consolidate 4 Excel Project Lists (Workbooks) to a Master Workbook. The Project Lists has a different structure and almost different content. The relevant information is always on...
  3. M

    Automatic addition or deletion of rows when master worksheet's rows are added or deleted?

    I have a school attendance worksheet with a list of names. When I add or delete rows from this worksheet (to accommodate the addition or removal of students from the school's enrollment) I want these same additions or deletions of rows to automatically take place on other worksheets that have...
  4. H

    master worksheet pulls from multiple workbooks

    Master worksheet showing a list of consolidated data , specifically daily sales ranging from first of the month to last day of the month. Master worksheet Column A has dates, Column B has cash totals, column C has Credit card totals. Column B and C ref sales totals pulled from different...
  5. C

    Random cells into master worksheet

    Please I have been searching to find a helpful marco or VB script to easy my task. I am dealing with data shattered but identical source to merge them into a new workbook, then I will use this workbook as a data toward a new Management system implemented to our company. I am request to pile...
  6. K

    copying to change master copy

    I have a spreadsheet that i would like to copy mutiple times but also have the master copy change ? Is there a way I can do this ? please help
  7. B

    Trying to stop Excel 2003 from rounding

    I have an excel spreadsheet that is automated using Visual Basic. My master spreadsheet receives data from 31 different sheets. I realized that when it is compiling it is rounding up. I have tried everything I know to get it to stop rounding because the data with rounding is incorrect. I...
  8. E

    get information from different files for master sheet

    Hello, - I have the following folder/file structure: MP1 CT CTfile1.csv CTfile2.csv CV CVfile1.csv CVfile2.csv FT FTfile1.csv FTfile2.csv ...etc - it keeps on going for more subfolders. - Every subfolder has 2 different .csv files. - Every file has the same structure. Relevant...
  9. B

    Transfer Data from Master Worksheet to Individual Worksheet

    Please Help. I receive a monthly download of individuals call-logs in one "Master File." For internal reasons, I need to separate every person's monthly call-log into individual worksheets. Unfortunately, the file is very large and copy/paste is very time consuming. I am operating on MS...
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

This Week's Hot Topics

  • link pictures from Sharepoint to Excel macro
    Hi, I need your help to fix this issue. I have a code and this is work on my computer. But now I try to link the picture from the SharePoint to...
  • lookup match return closest to x date
    Hi all, Happy New Year, this is my first post in 2022. I have two worksheets I'm working with. worksheet one is titled KPI Data - MY22 ONLY It...
  • Average hours per week
    I'm trying to find a simpler/quicker way to obtain the average number of hours per week for employees. My spreadsheet contains columns for Date...
  • Google Sheets IMAGE Function
    Is there any way to replicate the IMAGE function from Google Sheets in Excel? Maybe a VBA code? From what I can tell, the function in Google...
  • Identify equipment used -No of consecutive days
    Hello, I appreciate your time and effort. I would like to have formula for column O and P. Column A : lots of Asset Column C: date If one Asset...
  • Filling in data from source
    Hi All, I'm not quite sure what to call the following type of data manipulation so I don't quite know how to phrase my question. Below is an...

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