collate

  1. S

    Help collating a lot of files

    Hello, all I'm attempting to file about 1,000 employee forms in a new filing system. Each employee has one form. I want to divide the 1,000 employee forms according to the first two letters of their last name. I want to put "at most" twenty forms in each manila folder. I also want to keep...
  2. H

    calculating multipul amounts under same heading

    hi i am using excell 2008 for mac, I am imputing data into a chart where I have product sku's then number of items recieved on a specific date. I then have a long list of sku's and amounts. Is there a way excell can add up all the amounts or the same sku numbers?? SKU Code Decription...
  3. N

    VBA Code to collate data from a nr of s/s and insert in one s/s

    Each month I get circa 30 workbooks with cost data in, split by tabs in to cost heads, such as; Staff, Materials, Plant, Subcontract ...etc. I need to collate all the cost data for each cost head into one workbook (that is a separate workbook for each cost head). At the moment this is...
  4. A

    Collating information from individual spreadsheets

    hello there, new to the forum, looked through it for a solution but could not find any. So posting my question. Thank you in advance for reading this post. I have a set of 361 individual spreadsheets. Each of these contains 2 tables (roughly same position in the spreadsheet throughout the set...
  5. N

    Help! Collating with VBA (I think?)

    Hi, I need to reformat some data I received before I can put it into my statistical software. This programming stuff is all pretty new to me, so any input broken down as simply as possible would be greatly appreciated. I have data on every student that was enrolled at my school for each...
  6. K

    Collate several columns from several sheets to summary page

    I have a file with a number of sheets: Summary, Raw, and 28-31 sheets more for each day of the month. I want to collate the data from several non-adjacent columns depending on the label on the first row, i.e., columns with the headers FullName, LoggedOnTime, AvailTime, AHT, OCA, and...
  7. T

    Collate Muliple reports

    Any Help is Greatly appreciated.... I have a query where I enter 2 parameters: LanguageCode and PackageCode which then produces 2 reports. One report is a Letter and the other report has data in it. The issue I am having is that they open up seperately. I have to print both reports and manually...

Some videos you may like

This Week's Hot Topics

  • Launch Script When Tab Is Opened
    Hello all! Is there a way to launch a script or message every time a particular tab (DATA1) is selected/opened? I know it can be done when...
  • VBA that can extract words that starts with # and ends with 2021.
    Hi Everyone, I am straggling to in searching for a vba code that will extract a string that starts with # and ends with 2021. The string has no...
  • Date update overflow error ‘6’
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • VLOOKUP Formula ?
    Hi i am using this below but i need to return Column C on Detailed_view. You can see ,1 this returns D, but i need to return C before D. I tried...
  • conditional formatting the whole row
    Hello This is a question solved earlier by etaf. But I am getting some problem. I need help to correct the formula as it is not working in some...
  • Vlookup in vba
    Hi, I am new with the VBA, can someone help me, I have made this macro, but the loop across files in a directory runs only in cell G13, and I...

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
Top