mulitple sheets

  1. M

    Consolidate text/strings of employee info from multiple data sources

    So I was given 3 different files to create a single employee list. While some of the columns on all 3 files are similar (like employee number, first name, last name), most of them are different or omitted. For Example: File A <tbody> Employee Number Employee Last Name Employee First Name...
  2. D

    Create Adjacent Lists from One Master List

    Looking to create individual lists adjacent to each other from one master list based on year. The master list contains the names of all worksheets in the workbook as they appear in order from left to right. As you can see from the example shown, most of the names represent the month and year...
  3. A

    Adding cells in Column B on multiple sheets where Column A matches

    Sheet 1 called January <colgroup><col><col><col></colgroup><tbody> Sum of Hours Sum of Closed Tix Smith, John 156.5 68 Doe, Jane 176 35 Sizzors, Edward 11.5 4 White, Bryce 144 33 Bravo, Brenda 158.5 56 Deed, Richard 183.25 105 Thelusma, Jessica 160.25 37 0 0 0 0 0...
  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. S

    VBA: loop thru all worksheets, pull values

    Greetings, I am trying to make a macro that will be able to run on a workbook that contains multiple worksheets. It will loop through all of the worksheets and copy values then insert them on a new sheet. The first value is always in J2. (it is a date) The other values are located in columns...
  6. L

    MAcro for Multiple Sheets with defined names

    Good morning, I need a macro to combine multiple sheets into one combined sheet. I need it to only combine the Tabs that have "Debit Balance" in the name and move it into a sheet called "Debit Balance Summary" I am using Excel 2003. The active rows varies on all sheets but the columns remain...

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