Generate Sheets For Each Name In List
Aug 20, 2007
I have a long list that is geneerated each week and I need to split them based on their category acrross a number of sheets all named by the category. These sheets don't exist at the beginning.
My list would be like:
Col A Col B
UK Dave
UK Bill
UK Ann
US Bob
AUS Sheila
AUS Bruce
I want to run a macro down the list and build sheets for each unique ColA ie UK, US and AUS and then copy the ColB values into the correct sheets so UK has Dave, Bill and Ann in colA of the sheet named UK. anyone have an example of this type of process.
View 2 Replies
ADVERTISEMENT
Mar 26, 2014
I would like to generate a dynamic list of employees on sheets based on information on Sheet A. Here is my workbook structure:
-Sheet A contains all employees information (Name, division, salary hire date, etc)
-Sheet B is named Div A
-Sheet C is named Div B
-Etc...
Here is what I want to happen:
-Sheets B should pull the employees name and salary from sheet A only for employees of division A
-Sheet C should pull the employees name and salary from sheet A only for employees of division B
-Etc..
Sheet B, C , etc. should update the info and resort every time sheet A is updated.
View 5 Replies
View Related
Mar 27, 2014
I have a large amount of data, 40,000+ rows about how students do in remedial classes including from whom they took the classes. I have pulled from it a subset of student success as relates to the separate instructors. Now I would like to extract a consolidated list of those instructors for whom the student gain on criterion based pre and post course assessments is above a specific level. I have no trouble writing if statements that will look at two types of data, the course taken and the average student increase to determine which instructors meet or surpass the criterion, but I can only do that within a list that includes all the instructors. Because there are more than an hundred such instructors, it would be easier for the dean if I could provide a short list of those that meet specific criteria. I believe that it would be an array that I should use, but I have been fooling around with this for 2 days now, and am finding myself at a series of deadends!
View 5 Replies
View Related
Jan 7, 2009
I am trying to generate a list based on the value of a cell. That list will then be used as the range for a drop-down list. Example: Cell A1 returns a value of 15
A drop-down list displays the values 1 through 15. Cell A1 changes to 20
Drop-down list displays the values 1 through 20. I assume I'll need a two-step macro to accomplish this but I can't figure out the logic to populate the drop-down.
View 3 Replies
View Related
Jul 29, 2008
I have a set of accounts (general ledger accounts) that the accounting group posts expenses to. every once in awhile a new account is added. This is captured through a pivot that i have built (sheet A).
on another sheet (sheetB) i want to display the accounts that are shown in the pivot so that i can forecast their future activity.
What i am trying to figure out is how can i make the list on Sheet B change when new accounts are added to the pivot on Sheet A (without simply referencing the pivot table making one cell equal the other)? I am not looking for a data validation pull down, i want a full list of the accounts.
View 9 Replies
View Related
Mar 12, 2014
I have a big Excel file with 20+ sheets. All these sheets have different margins and layouts.
I need to generate a Single PDF with all these sheets. Is it possible?
When I save the file as PDF, it converts only the current sheet and NOT the whole file. As I said all my sheets have different margins and layouts, I can not combine them into a single sheet.
View 2 Replies
View Related
Dec 29, 2012
if it was possible to have Excel sort and then Auto generate a work sheet.
Once a week at work I get a report that is split up via our 3 digit office codes.
Once a week I manually sort the info and split the original sheet into separate sheets based on the office code and mail it to them.
Its is simple and repetitive but takes me half a day to do due to the size.
View 2 Replies
View Related
Mar 30, 2014
I have difficulty to generate sheets on the Status of Equipment from the master sheet. I need to manage the maintenance and diagnostics of a plant, and I have a whole list of equipment, thus when any of those goes faulty, I want to enter the word "Fault" in Column G, Then It must automatically generate the Template for that tag, and name the sheet same as the Tag.
I have added an Attachment : Template for MnD_ExpertQ.xlsx‎
View 3 Replies
View Related
Feb 20, 2014
I have a workbook in which users record the time spent on various activities. I have some code which will copy the worksheet template and create a worksheet for each user (in a defined list of names). Then each worksheet needs to be password protected so only the user can see it (I can do this individually by manually writing in each sheet name and setting a password but will have 80+ users for some groups and it will take ages...)
What I would like to be able to do is also automatically generate a password for each user (combining a word and automatic number e.g. "EMidsTeam123") it may be possible to insert this into the code I already have (which I have copied )...
VB:
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Dim strPass As String
Dim lCount As Long
If Sh.CodeName <> "Sheet1" Then
'Set sLast variable to the last active sheet This is then used to return the user to the last sheet they were
[Code]....
View 6 Replies
View Related
Jun 12, 2014
I've been using excel sheets to create reports for clients based on various sized samples of bars (I'm a test engineer). The sheets are essentially the same format though information will vary (such as bar type, diameter, etc.) I've been working on automating these sheets so that I don't need so many template-like tabs (currently I have a workbook for each client setup with 5-20 different sheets just in case the client sends in those bars! Half of the sheets stay blank and it can be confusing/cluttered).
Here's what I want to do: Have one page or popup window where I can input the information (job number, bar size, bar type, etc.) press the magic button and have it spit out a new sheet with that info added into the template. Is this doable?? I've never used macros before but I'm assuming I'll need to, which is fine, how that works.
View 4 Replies
View Related
Nov 18, 2012
I am looking for a code to generate a combinations of x numbers taken 5 at the time. t
View 2 Replies
View Related
Feb 26, 2008
I have an event that is one week long (7 days), with three functions happening each day (7 days - 3 columns per day).
There are 11 groups with various number of possible attendees listed in rows. Attendees of a given function is indicated by entry of a 1 or 2 (attending partner), Blank = not attending.
I would like to show a list of the attendees for a given function by clicking or moving my mouse pointer on the event function column header.
The list would need to be automatically updated when the attendees status changes (entry or deletion of 1 or 2)
View 14 Replies
View Related
Feb 25, 2010
Find attached an example sheet. I have one list with data... Name, Handle, Result. I want to have three lists from that data
List 1 would have top ten highest results
List 2 would have top ten lowest results
Some results will be the same so I would need each Name listed as they appear in the main list until ten is reached. List 3 would have top ten handle, but would not include anyone in list 1 or 2. This will be a shared workbook
View 3 Replies
View Related
Mar 6, 2012
This is what I'm trying to achieve: Display a list box (or any other appropriate form/active X control) to get input from the users which is usually a list of several terms. Once they've input the list, upon clicking 'OK' it should add them all to Col. B.
The above request WILL be a good solution, but if there is an advanced solution to this for eg., something like a list box with buttons, for instance: click on 'Articles' and it populates 'a,' 'an,' & 'the, click on 'Prepositions' and it populates all the pre-fed prepositions, etc. that would be PERFECT!
View 9 Replies
View Related
Apr 22, 2012
How to generate a list base on the differences of another list. let me explain; I have a list of combination A1:F2200 each row of course the numbers have difference, example:
589162045620273342451261419316121721264271837414551
As you see the difference in the first row for this small example is 317425 and the list base on this difference is :
145121641256131742367141843478151944589162045691017214671011182247811
1219234891213202449101314212550111415222651121516232752131617242853
The maximum number is 53. doing this one time find, but I have to do it with my 2200 difference.
View 9 Replies
View Related
May 30, 2009
On my timesheet, there is a button that, when clicked, allows you to select a pay period end date. Our pay periods end every other Friday. When the button is clicked, it opens a form I designed that has a listbox that I manually entered every pay period for the year into. Here is the code I used:
Private Sub UserForm_Initialize()
' Populate the ListBox control.
listPayPeriodEndDates.AddItem "04/03/09"
listPayPeriodEndDates.AddItem "04/17/09"
listPayPeriodEndDates.AddItem "05/01/09"
listPayPeriodEndDates.AddItem "05/15/09"
listPayPeriodEndDates.AddItem "05/29/09"
listPayPeriodEndDates.AddItem "06/05/09"
listPayPeriodEndDates.AddItem "06/19/09"
listPayPeriodEndDates.AddItem "07/03/09"
listPayPeriodEndDates.AddItem "07/17/09"
listPayPeriodEndDates.AddItem "07/31/09"
listPayPeriodEndDates.AddItem "08/07/09"
listPayPeriodEndDates.AddItem "08/21/09"
listPayPeriodEndDates.AddItem "09/04/09"........................
What I'd like to do instead is have VBA populate the listbox (or combobox or what have you) dynamically, by using a reference point (say, the first pay period of the year) and then populating every other Friday from that point forward. Also, it would be great if it could reference the current date as to only list pay period end dates in the future (or even the two prior to todays date, and then maybe 3 or 4 pay period end dates in the future).
View 10 Replies
View Related
Aug 19, 2009
I have a database file with a list of components. Each component has manufacturers name, part number, description etc. I need to create an individual file from each of the components in the list. I would like a quick and easy way to copy the information in each Row and generate a new file for each Row containing the existing template I have.
View 9 Replies
View Related
Nov 23, 2006
I have been working on a project with 30 products and 20 different companies.
I am working on a business case, where there are launch dates for various companies with expected sales, contribution margin, NPV etc.
The idea is that I can create specific scenarios (What is Company1 doesn't launch the products, etc), and there is an accompanying each company. Because it can be difficult to see what products are included in the current calculations, I would like to use some kind of function that produces a list that matches my criteria. (In this case, all cells for a company that are larger than 0).
I would like to find a function that finds all products that have a launch date and create a list of them -- without spaces between non-matched results. And that it updates whenever data is changed (new launch year or new product in company's profile)
I have included a generic excel file to show what I am going for.
View 4 Replies
View Related
Jan 4, 2008
I am trying to create a list, I know how to do this on the same sheet, I need to be able to have the list informaiton on a data sheet that contains other information that I need to have to populate other parts of the sheet. then I need to add this list data so that I can have drop down options so that users can pick from selected work descriptions
View 2 Replies
View Related
Feb 20, 2013
Maybe this problem is not too much complicated for some of you experts. I have this:
I have in sheet "Products", in column A, a lists of Products from row 2 to N. (Product 1 , Product 2, Product 15, Product 37, etc).
How to generate in sheet "Menu" a matrix of buttons with the label of each button taken from the value of each cell in column A of sheet1.
I mean, the buttons would have the label Product 1 , Product 2, Product 15, Product 37, etc. Each button associated with macro "My_Macro".
I would like that the buttons be organize as simetrical as possible (regarding number of rows and columns)
* I'm attaching sample file with input in sheet "Products" and output desired for those few products. The real list could have 100 Products.
View 6 Replies
View Related
Feb 12, 2014
The below is causing me an issue as it is setting the ws value to equal nothing instead of sheet1 or sheet2 etc. I have my dimensions set above and there are no spelling mistakes.
It falls down on the
VB : Set LastRow = ws.Range("a65536").End(xlUp)
line but this seems to happen because ws is set to nothing.
VB:
For iramp2 = 0 To ListBox1.ListCount - 1
If ListBox1.Selected(iramp2) Then
Set ws = ActiveWorkbook.Sheets("Sheet" & iramp2)
End If
[Code] .....
View 4 Replies
View Related
Apr 21, 2014
I have 2 columns of data in one sheet that list dates (say Master Dates) and transactions (say Master Transactions).
In another sheet i would like a formula that can choose the correct transactions that fall between certain dates (call Date Beginning and Date End) and generate a list.
i have tried this array:
If((Master Dates>=Date Beginning)*(Master Dates<Date End),Master Transactions,"")
Problem with this is when used in different columns for different date ranges there are large gaps in the generated list...
View 9 Replies
View Related
Jun 21, 2007
I have a frequency list (frequency per year) resulted from previous calculation. What I want is to generate random number as many as the frequency in the specified year, so that every year I will get the same amount of random numbers as the frequency. It is kind of the opposite of FREQUENCY function (but with random numbers involved). I need to use the result for further calculation.
View 11 Replies
View Related
Jun 10, 2013
I have a folder containing about 100,000 files and subfolders. Approximately 20% of the files are duplicates. I would like to create a list of all the files with some details so that I can sort through and identify which ones are duplicates, then create a batch file to delete them. How to get a file list with additional details, like size, modified date, etc, into an excel format?
View 3 Replies
View Related
Feb 26, 2011
How to generate a list of numbers of this function in Excel: COMBIN(20,3), but i want the combinations of numbers. I want to create a list of 20 questions and every question has 3 answer. I think that are 1140 combinations.
View 9 Replies
View Related
Mar 5, 2010
I have a List like this (a large one in practical)
A B 1 cat dog 2 rat cat 3 bat cat 4 cat rat
At the bottom I want to generate an array which gives what are the text entries of this list.(ignore multiple occurrences)
so the answer should be
cat
rat
bat
dog
View 9 Replies
View Related
May 7, 2007
I am trying to make a more useful excel extracted report – what I have to start with is muck like the attached sample file. With at the bottom is what I would like to be auto done.
There is a column of names – with most names repeating so the first thing needed is to create a new summary list – can be in the same worksheet or in a new worksheet. The new list with be just a list of each name but only display each name once rather that the multiple of times as source list.
The second requirement is than once have a list of each name that appears then in columns next to each a tally /count of each non blank cell under each respective column heading - now it has to be a count of non blank cells as the content of each cell will chance – now need to understand it is not a count of numerals as such but a count of non blank cells so it is not 1 + 3 + 5 = 9 but should be 1 +3 + 5 = 3 (3 non blanks).
A idea of what I want is at bottom of sample worksheet attached
View 9 Replies
View Related
Sep 10, 2013
I have a marketing calendar that I need to update just about daily with new promotional plans because the dates change very often and there are a lot of markets that we are keeping track of. Because the format of the excel is basically a bunch of merged cells to show the range of dates of a particular promotion, it takes a very long time to unmerge and remerge everything when one date changes.
I have an example of what the graph looks like below, as well as a grid of what I would like to use to generate this graph automatically using the start and end dates so thats all you need to change. If you changed the start dates, the market name, or the promo name, the chart would reflect the updates.
View 2 Replies
View Related
Oct 20, 2013
I have a list in excel with ten values, but I need to get all combinations possible, picking 4 of 10 each combination. This must be as a combination and no permutation or variations either, I mean, values can't be repeated in a single combination.
I'm struggling to do this in a Macro but I don't get it.
View 9 Replies
View Related
Aug 17, 2008
i had a basic spreadsheet for my incomings and i got wiped with my hd exploding!! i know how much the total was i just need a way of creating a list of random amounts within a specified range over a year to give to my accountant.
View 13 Replies
View Related
