lists automatic

  1. M

    Dynamically change list values

    I have data in a spreadsheet, called volunteers. In the last 5 columns are a series of Yes/No responses, such as "Call Voters", "Work the polls", "Fundraise" etc. What I would like to do is create individual sheets based on data culled from the main sheet (volunteers), so sheet 2 would consist...
  2. A

    Turning a series of individual timesheets into a simple daily summary

    So in my spreadsheet I have a tab for each employee. Each tab is a weekly summary with a column for the date/hours/mileage/job that they worked. I want to create a separate daily spreadsheet that gives me a list of each employee that worked on a given day, and also pull the # of hours they...
  3. M

    All combinations for data in groups of different sizes

    Thank you in advance for any assistance you can offer. i'm trying to create excel (2007) spreadsheet that will list all possible combinations of 5 different groups of numbers, while filtering out some rows. Each of The 5 groups can contain between 1 and 8 possible numbers. for example: Group...
  4. B

    Macro to rotate through list of names (advanced)

    if you look at the table below, there is a date column and a name column. in a perfect world, i want to copy a list of names to my clipboard and run this macro. the macro will paste the contents to sheet1, convert as many names as i paste to a table, then on sheet 2, create these two columns for...
  5. A

    Calculate certain combinations from various lists

    Hi, I am trying to write a formula (without Macros, queries, or VBA) to create all the combinations from a list, given certain conditions. I have several plants running several production lines, and if a production line breaks it has a cost as described below: <tbody> Factory Failure of the...
  6. P

    Runtime error 462

    Hello guys! I tried several ways to fix my code but it's always give me the same error (runtime error 462) and highlight this piece of code: This happened when I tried to print an automatic numbered list on a word document...
  7. T

    Returning list with common values

    Hello All, I have searched through the posts and could not find an answer to this one. I am trying to search through data and return all of the results that have a common value. For simplicity, say I have a list of 5 people in column A (John, Mike, Jeff, Andrew, Simon) and their job title in...
  8. T

    Comparing cell contents to lists

    Is it possible to create a formula which looks at the contents of a cell and compares it to several lists (also in Excel), then enters a value. I.e. I have a list of towns in column A. I want the region to be automatically inserted into column B. The towns are listed by region in a separate...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top