I have list of county roads and would like to organize them by odd number and pair. Macro that can change the pair number first then the odd number here is an example
ORIGINAL LIST
COUNTY ROAD 32 & COUNTY ROAD 55
COUNTY ROAD 36 & COUNTY ROAD 55
COUNTY ROAD 51 & COUNTY ROAD 48
COUNTY ROAD 48 & COUNTY ROAD 35
[Code] ...........
im having trouble trying to figure out how to organize the following data. It concernc cycling races that has its own data like type of race, country, number of mountain stages etc. but also for each race i need a subcatagorie wich holds the data of all riders that participate in it. like;
Race: Categorie race: Number of mountain stages: etc.....:
Tour de france Grand tour 8 ...
Giro d.italie Grand tour 19 ...
but also for each race:
Race: Teams (wich will need up To twenty names): Riders (For Each team up To 9 riders:
Tour de France Gerolsteiner Totschnig, Zberg, etc...
Tour de France Discovery Channel Armstrong, Beltran, etc...
How would you organize information like that, the trouble is it must be able to use all the excel functions AND be able to update the list trough an webquery and VBA code.
I did a survey of what kind of clothes people like to wear and why. So there are two things that people have to write down. ex) jeans and cus they're comfortable / shirts and cus they look good
The data that I received was organized as followed
I just put in random things just so you can get the idea of whats what
Id
jeans
shirts
cardigans
[Code].....
Okay so what I want to know is how I can get the responses from the data spreadsheet I showed you before into this organized data table above.
I have raw data converted from pdf into excel Workbook spanning into many sheets.Each sheet having 5 sets of records. It is highly disoriented.Some times it is in 4 columns and some times in three columns having 30 unique Records which I Want to put in rows neatly in a single sheet .Raw Data is like in table below.In some Columns There are only 20 Records.I want them in rows organized under headers.
Name: Aa bb
Fax:*5555
Team:United
Actor:Arnold
[Code]....
Problem is that in some columns there are only 10 fields present,eg: name field is there Add,state,Country is not.Also in some columns many fields are in a single cell,eg: Tel,fax,Email in a single cell.
Each Record That Needed to extract starts after : Also I can Replace all required fields like name ,add, city, to 1,2,3 if that is going to work.
I work as an alternative health practitioner and am making reference lists to use for working with various conditions. So far I've been using MS word and manually typing out everything into lists, but since that document is becoming hugely ungainly to work with (60+ double columned pages) I thought maybe there is an easier way to do this?
So my question is, can I use excel (or another program?) to do these things? And how would I go about doing them?
"Tag" various procedures with symptoms to alleviate. For example, can I tag Scalene trigger points (technique) with the symptoms brachial neuritis, extremity numbness, neck pain, elbow pain, wrist pain, shoulder pain, upper back pain, etc (some techniques will need 25+ symptom tags). Because of the large amount of "tags" I'll need to add, being able to quickly add them (for example, maybe typing them all in one cell separated by commas) is crucial Sort the data by symptom i.e "neck pain" and have all techniques tagged with "neck pain" show up in list form. Transfer all the data I already have sorted into the excel spreadsheet - for example I have a list of 100+ techniques for "neck pain", so I would need to be able to paste that list into excel and tag it with "neck pain" so it would show up along with anything added in excel. Be able to copy/paste the compiled list of techniques for each symptom into a document that I can print out and use as a reference at work. So for instance, be able to search "neck pain" copy the list of techniques for neck pain without including any extraneous data (such as all the tags) and paste it into ms word as text, not a table.
Edit: I have Excel 2007
i have a fingerprint time recorder that provides me time log ins and log outs of employees which i use for the computation of their salaries every end of the week (saturday). here is a sample of the file i get from the fingerprint scanner program.
[URL]
now what i want to do is for it to consolidate all the names in 1 column, total number of days in another column, total basic gross pay in the next column and total deductions base on undertimeNAME
Total number of work days
total basic gross pay
total number of hours deducted
total deductions base on undertime
here is the table for salary deductions
tardiness
08:01 - 08:30 am - 30 minutes salary deduction
08-31 - 09:00 am - 1 hour salary deduction
09:01 - 09:15 am - 1 hour and 30 minutes salary deductions
09:16 - onwards - considered as half day
undertime
03:35 pm = half day salary deduction
03:36 pm = one hour and a hlaf salary deduction
04:00 pm = one hour salary deduction
04:30 pm = 30 minutes salary deduction
I would like to automate, due to how long it would take to manually organize the data myself. I have all of the raw data needed organized into 3 columns. The problem is that some of the related data is divided up into multiple rows, based on ID number. What I would like to do is take the related CPT codes and respective descriptions, from the same ID number, and place them on the same row. I am going to include some pics and even a small chunk of the source data. Here is a pic of the raw data:
And here is the first 3 already done:
The number of CPT codes per ID number range from 2 - 5 I believe, maybe 6. Not sure if this has any bearing on how it is done.
I have a pair of digits in col B, that I would like to match with the digits in in col D, and display those matches in col E. If possible I would delete the duplicates in col E, and show results in col F.
View 9 Replies View RelatedI am trying to make code to randomly pair up players. I have found code which makes a button that randomly pairs up players in a list but I want to make it so that ? players are paired with ? other players instead of everyone at the same time so that a person dosn't get paired with more then one player at a time.
E.g. take the first 6 players in a last and pair them with the second 6.
This is the code I found:
Private Sub CommandButton1_Click()
Dim x As Range, RanRng As Range, z As Range, oRes, Ray
Dim i As Integer, j As Integer, real, oSt As Integer, cl As Range
Dim oCol As Integer
Set RanRng = Range(Range("A1"), Range("A" & Rows.Count).End(xlUp))
[Code] ........
I have two lists that represent pairs of electrical connectors. List_1 is Male Connectors, and List_2 is the mating Female Connectors. The lists are built so that when side-by-side, a mating pair line up next to each other.
I'm trying to build a User Interface that presents the connectors as pairs, but also aloow the user to select EITHER member of the pair.
My first thougt was to use a Listview or a Listbox with 2 columns. Either way, the user selects a full row, rather a single entry in a row.
I finally ended up building a userform with 2 Listboxes adjacent to each other, and a Vertical Scrollbar Control to the right of the pair. I added the following code to the form, to scroll both Listboxes simultaneously:
Private Const Display_Lines As Long = 7
Private Sub ListBox1_Click()
Me.ListBox2.ListIndex = -1
End Sub
As far as that goes, it works fairly well. The user scrolls up and down using the Scrollbar control, and paired entries remain adjacent to each other. The user can select an entry from either Listbox, and I can easily harvest that choice through code.
I was hoping, however, that I could support people who use the keyboard for navigation.
Focus on one of the Listboxes, then navigate using the up and down arrow keys. When the user gets to the end of the list, the value of the Scrollbar control increments or decrements as required, thus re-populating the lists. I just can't get this to work in a way that is not cludgey. I have worked through about a half-dozen possible methods, and each one has some hitch that makes it either hokey or unworkable.
How to make Rumble 3 digits from pair's
View 9 Replies View RelatedI have used excel to create a list of matching pairs, which I want to link together. The problem is, all I have been able to create is a very long list of matching pairs, and no way to link all the pairs together. My sheet looks like this.
a b
1 100 200
2 200 300
3 300 400
4 300 500
5 600 700
6 800 700
The first row shows that 100 goes with 200, and the other rows continue defining which blocks go together. What I need is a way to summarize all the blocks that link up, ie get 100-200-300-400-500 and 600-700-800 from this list of relationships. Can't do it with a lookup because some blocks link to multiple other blocks.
we want to add/concatenate the values of first column and show the result in next column. The problem is fully explained in the comment section of the sheet attached. But still if you are having in getting the problem
View 6 Replies View Related************************************************************************>Microsoft Excel - Book2.xls___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutB2B3B4B5B6B7B8B9B10B11B12B13B14B15B16B17B18B19B20B21B22B23B24B25B26B27B28B29=ABCD1 amount Abs amtMark x when paried up 2 (43,746.73)43746.73x 3 43,746.73 43746.73x 4 43,746.73 43746.73 5 (60,579.30)60579.3 6 (60,579.30)60579.3x 7 60,579.30 60579.3x 8 (98,416.85)98416.85x 9 98,416.85 98416.85x 10 98,416.85 98416.85 11 (500,000.00)500000 12 (500,000.00)500000 13 (500,000.00)500000 14 (500,000.00)500000x 15 500,000.00 500000x 16 (700,000.00)700000 17 (700,000.00)700000 18 (700,000.00)700000x 19 (700,000.00)700000x 20 (700,000.00)700000x 21 (700,000.00)700000x 22 (700,000.00)700000x 23 (700,000.00)700000x 24 700,000.00 700000x 25 700,000.00 700000x 26 700,000.00 700000x 27 700,000.00 700000x 28 700,000.00 700000x 29 700,000.00 700000x Sheet1 [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name boxPLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 11">****** name="Originator" content="Microsoft Word 11"> Hi everyone,
I can't figure out how to mark a "x" for the paired up figures in column A as shown in the above spreadsheet using a formula(e) and/or VBA. At the moment I'm doing this manually. Imagine doing this for thousands of line... once a week
I have a bunch of worksheets with various data that is in columns ranging from 1 upto 20 (this is different with each sheet) across and each column has data rows that has various numbers.
What I want to do is create a sheet when I need to organize some data and control A all the data and paste on to this sheet hit a macro and have it take all columns and stack them in to column A.
Each row will have a different number of populated cells and there are sometimes 5 columns up to 20 columns
Example
Column A - 100 data pieces
Column B - 325
Column C - 100
and so on...
The macro should leave all items in column A but then cut all 325 records (row 1-325) and then paste them starting in cell "A101" then move to Column C and stack those below what was moved form column B and so on.
The code will stop at the first blank space in each row and will go from right to left until it hits the first blank cell in the columns.
I have two sheets of data: sheet1 and sheet2. Data in sheet 1 and sheet 2 are in pair, ex: row1 and row2 is 1 pair, row 3 and row 4 is one pair ect…I need a program that start from each pair in sheet1 and search for it in sheet2, if that pair already exist somewhere in sheet2, then cut that pair from sheet1 and paste it into sheet3.
View 12 Replies View RelatedIn A1
01234
In B1:k1
01 02 03 04 12 13 14 23 24 34
I am looking for a formula that will combine each digit together as a 2 digit value
Is this even posible?
The value in A1 could range from a 3 to 9 digit value.
I want to create a simple worksheet that takes a list of names (All of the members of my family) and Randomly selects another name from that same list and matches them to it ( I don't want to say "paired" because I want each person to have a one way relationship to the other, in other words just because personA is matched to personB, i don't want personB to automatically be paired to personA) I hope that makes sense. Once every name on the list is matched with a person I would like to move that name to a database that I can track each year. The practical application of it is this: Each year our family randomly draws names and we are tasked to buy a new x-mas ornimate for that person, ideally you would not get the same person 2 years in a row, and the person that you have does not have you in return simply to add more variety and the database would track who had who each year.
Code:
Sub test()
Dim a, i As Long, temp, n As Long
a = Range("b2", Range("b" & Rows.Count).End(xlUp))
Randomize
With CreateObject("System.Collections.SortedList")
For i = 1 To UBound(a, 1)
[Code] ......
Excel user that has been manually computing a 6000 row spreadsheet. Here is sample data and what I need. Column A goes through the alphabet (A,B, C, etc.) and Column B is numbers from 1-65. I need Column C to count the number of rows for each alphabet/number pair. K, 28 has 3 rows; K, 33 has 1 row; L, 21 has 4 rows; etc.
Column A
Column B
Column C
K
28
3
K
28
3
K
28
3
[code]....
This is my Excel dilemma: creating roundrobin pairs.
For a given list of numbers, I need to generate pairs where each number is paired with all the other numbers without creating a duplicate pair.
For example: 1,3,4,6... (dynamic)
Pairs: 1-3, 1-4, 1-6, 3-4, 3-6, 4-6
Results should be generated in two columns. Column A would be ID1, Column B would be ID2 (the combination of both would be the pair created)
ID1ID2131416343646
I have basic ideas for a macro but the loop within a loop and the OFFSET for the next row is something I really can't put together.
I need to randomly pair players together to form teams.
For example:
Saturday morning, there are 19 golfers signed up to play together, but want to paired randomly.
This is what we currently do:
In cells A1:A27 I type their names. In B1:B27, I type their handicaps.
We then use a deck of cards to randomly draw teams. We do this by pulling 4-A's, 4-k's, 4-Q's, 4-J's, and 3-10's from the deck. We shuffle these cards and then go down the names in colum A and assign each palyer a card and place the card value into column C. We then highlight all three columns and sort by column C to form teams.
This works ok, but the problem is they all tee off at the same time and need a "super quick" process to form teams in seconds.
The only variable that I might see being a problem is the # of players vary each time they play. There might be 12 one day and 51 the next. We have to form teams into 4 somes and 3 somes, based on the total number of players we get.
I have an unknown number of rows that represent parts and 6 columns that represent part dimensions. I need to find and output matching pairs of parts that are within certain dimensional tolerance ranges.
For example:
Dimension 1 Dimension 2 to Dimension 6
Part 1
Part 2
to Part X
-I would need the code to check if Dimension 1 of Parts 1 & 2 were within a certain range and if Dimension 2 of Parts 1 & 2 were within a range etc. then (if all of them were true) output them as a pair. Otherwise, it would continue to search for paired parts. Once a pair is found, those parts can't be used again. How can I do this?
Is there any way to organize a list of various months and dates
First by creating a column of just the months, then by all of the dates, serperated by commas?
First, I tried to input Ibs, Size, Items into a worksheet with layout.
Then, calculate how many items are they and separate them into two categories - "Big" and "Small".
Final, I would like to create another worksheet to evaluate how many items belongs to "Big" and "Small" with a column chart to present.
Question : How can I accrue the total of items and sort them into the right categories automatically.
I have been trying to do this for 3 days using "Record Macro", but something always seems to be messed up. The main problem is that the worksheets are protected and the macro asks for the password.
Here is a calendar sheet that I've been working on. It contains the calendar on sheet 1(not important) and a client roster on sheet 2. The client roster gets filled quickly, and obviously gets unorganized. What I'd like to do is create a macro so that when a date is entered into column AA (when a client is discharged), that entire row is moved onto sheet 3 (Discharged). At the same time, I'd like all of the names in column A alphabetized.
I even tried to create an "Organize" button so that the users could just click it and alphabetize. The problem I ran into with that was that the users are using Office 2000, and the names get alphabetized but all of their information no longer matches up.
I have a column of numbers and I want to copy numbers, with a constant periodicity, and paste in a new column. In the example below, I copy values from column A and past in column B, picking only every third value:
A B
1 1
2 4
3 7
4 10
5
6
7
8
9
10
My sheet has a bunch of Name's in column D, either the text "Store" or nothing in column E, and a dollar value in column F. I'm trying to figure a way to display the names in order of highest to lowest dollar value based on the criteria that the name must have the text "Store" next to it in column E. If column E is blank then the name would not be included in the ranking. I thought I could use the following code to accomplish this:
View 13 Replies View RelatedI have the code below that will organize worksheets in a workbook ascending (1,2,3...) and would like to know how to deal with the For loop not initialized "Run-time error '92'" message that shows up at the end.
I'm teaching myself as I go and would like some light on this if you don't mind. Also would like to know if there is any 'better' way per-se to do this kind of task.
I am currently trying to organize numerous numbers by fractions, and it just will not set up right.
1 1/2
1/2
3/4
2
1
2 X 3/4
1 X 1/2
1 1/2 X 3/4
What would be the best code used, or method, to ensure that these numbers organize correctly?
I am having a problem in using lookup formula. Unfortunately for some entries it does not give the exact matching pair but one upper. I have attached the excel sheet. Please correct me where is the mistake. More about the sheet:
One column contains the alphabets from a certain language and second column contains corresponding unicodes. I want to search the unicode of a particulat alphabet using "lookup". Cell C4 is the key value. D4 uses lookup to get unicode value
