I working on a macro that re-arrange a table, but can not find the code. In the attached file, my original data are on the Sheet1. I would like a macro that create as many sheet as there are different values in Column D and rename each sheets by that value.
My main objective is speed and automatization in the competition organization.
Im almost finishing it but now im stuck in this situation:
I have a table with 13 cells
A: athlete name B: athlete weight C: random number (raffle) and then from 1 to 10 is the final Groups.
E.g
Name Weight No 1 2 3 4 5 6 7
[code].....
Now i need to create a macro to display the itens in the groups when the weighing is finished...
E.g
Name Weight No 1 2 3 4 5 6 7 8 9
[code].....
The conditions are:
The numbers should be displayed in the athletes groups
The difference between all the athletes weights shouldn't be > 3 kilos If theres is more than 5 athletes per group the heaviest should go to next athletes group and pop up one message informing that maximum athletes per group was reached...
How do I rearrange the data columns in a pivot table? I have a table with year to date months, open PO's, & budget numbers, but I'd like to change the order in which they show up in the pivot table.
I have to complete a task using Excel. Normally I would complete the task using a database, but this one needs to be complete using Excel (for others to use afterwards)
I have a flat semicolon delimited text file which holds x amount of lines OR I can get the data using an ODBC connection (directly from the DB) Each line starts with a date, a name, a second name, and a price. See: 1.input.jpg
In the attached WB I managed to write some code (behind Sheet1) to change the Source table, itself, into the requested layout. My question is - could this be done by ONLY Worksheets functions - preferable without any helper column - if possible. note that all 4 columns data should be transported to the target table. The upper left cell of the target/new layout table can be put in cell G1 or in cell A15.
I have a problem whereby I have a list of data that has a date, a transaction and a balance. I want to be able to rearrange this data into multiple tables, one for each month.
The pictures below explain the situation better, on the left is the list of data I need to sort, and on the right is how I'd like the data displayed. So for the May columns I would like to display all transactions that happened in May and, depending on whether it is an income or an expense, the amount in the corresponding column.
i.e. so the finish result looks something like this:
I do not know much about macros so thats is possibly an easy problem to solve. My problem is basically rearranging the rows and columns. Example is below.
M.N= Material Name C.N= Country Name
M.N C.N 1 A 1 B 1 C 1 G 2 A 2 H 3 C 3 F 3 K 4 A 4 C 4 E
Here i have two columns. I would like to take the country list to rows as shown below.
M.N. A B C D E F* * * 1 2 3 4 5 * *
And if the country has that material name it should show "Y" in the crossing cell. ( eg 1 A, 4 C)
I'd appreaciate your help. If you can help me with how to do this kind of layout changes with macro, it'd be more useful i guess, because i come accross with this kind of issues so often.
In this example, I am attempting to look up one value based on two criteria. The month must match, and the location must match. In doing so, the value "1" should be returned in the example.
I run a spreadsheet that manages golf tournaments. i have to group the # of players evenly as possible on each hole once they are entered into the tournament. since the number of players varies from tournament to tournament the math gets complicated trying to get the groupings right. i can do the math on paper but do not know how to code the math in a macro. this would save me a ton of time if someone can figure this out. i have attached a sample .xls that includes all the info i could think of a person needs to see what is going on. If i am asking to much i understand and will remove the thread.
i have a huge data in excel some rows has been shifted down ...e.g. from column.AY3200 data shifted down :-in column B3201 & i want arranged that B3201 in AY3200,so .it;s seem like below ..
Would like to know if there is a way to arrange two different sheet under the same workbook horizontally? I have used the excel help box but did not manage to find a way.
I would like to have the cell contents show the string descriptions first then all the numbers at the back which includes the x. the lenght of the text and numbers could vary. the top 6 examples are correct i also need a space between thwe string and the numbers
I would like to have a macro to automatically generate a statistics table (on the "statistics" tab) with the 5 following fields: Fragment names / # samples / # of failed samples / % of success / # of variations in the fragment (SNP). At the bottom of this table, I would like to have a cell with the average % of success for all fragments. The data to generate these statistics are on the "gene name" tab (please note that this name will change every time I will work on a new gene). To make things easier, I think the macro should be run from this tab.
1. The Fragment names are displayed in row #5. I use one column per variation per fragment. If one fragment has 3 variations, there will be three columns and I will merge together the fragment name cells. The fact that some cells are merged can be a problem when copy-paste to the stats table (as I would like to get rid of the merging).
2. # of samples corresponds to the number of cells in blue in column A. The number of samples can change from one report to another but is always constant in the same report.
3. # of failed sequences. In the table, I type "Failed Sequence" (if the analysis has failed) and "Missing Sequence" (if the analysis has not been done). When a sample is failed or missing, it is for the who fragment, no matter how many variation there is in the fragment, so I usually merge the cells of all variations for this failed sample.
4. % of success: this is quite easy #sample/#of failed+missing sequence for this fragment
5. # of variation is equal to the number of variations for this fragment (can be 0, 1, 2, etc.). When there is no variation in a fragment, I put '-- in all cells of the corresponding fragment on the "gene name" tab. Fragment 3 on my file is an example of 0 variation.
I am starting a data sheet that I will be pasting from the internet into my data sheet daily, the problem I have is that the content data is pasting with blank rows between data and also there is one piece of data that is situated on the row below which i need moving to the end of the main data row, the idea is to have single data rows with no blank rows.
I have attached an example sheet showing the layout it repeats with only the amount of data that changes.
I have colored the data as follows:
Grey= Blank Rows Yellow= Data Move to end of main row Green= Unwanted Data
I am starting an excel file that extracts file from another worksheet, then after it is extracted, A2 cell has a value in cell B2, I wanted to copy all the cells in column A&B to column C&D in such a way that when the word "check is encountered in column A, it will arrange itself in the last with the other cells that contain same words before the word "check". I wanted to do this in macro or formula if possible.
I want to know is there any way to arrange bars in the chart with respect to their magnitude (ascending or descending) without making changes in the source data?
This is for a race track. Drivers sign in on one sheet. On that sheet there is 4 different columns. Column 1 lists the division that they race in. Column 2 is the name of the driver. Column 3 is his car #. Column 4 is the number that he draws that decides his starting position. Typically there is 2 heat races per division with the odd number that is drawn being in the first heat and the even number being in the second heat. I created a second sheet called heat races. I am using an index function with a small function with a row. I have my divisions listed separately with 2 heats per division. I want to display the car number per division but lined up by the position that they draw. I have figured out how to display all of the cars per division, but I can't figure out how to separate them by what they draw (odd and even and in order from lowest to highest).
I'm trying to write code which allows me to cut and paste arrange of data from one sheet to the next.
the critical field is MRPC column i, I need to select all data that when I apply a auto filter allows me to cut and paste from the line below the header. And repeater using the a value
>=200 Cut all cells, rows paste. then repeat this >=155 to 199 >=145
I want to take a list of phone numbers in a single column(800,000+ rows)and spread the numbers across the page horizontally to fill the page. Each of the new rows will have probably 4-5 phone numbers. below is an illustration:
Drop list. First of all I have sheet with all my data and i have define the name of each table.
I have about 15 categories table and a table with min 2 and max 100 items in each category.
I have made in a different sheet a drop list for my categories. Near this list i made another drop list with the items by using the formula =indirect() to arrange my items by categories.
The problem that i have is: - Some categories they have many items and is difficult to find some items. i need to put a formula to put some letters and find what i need easily (easy searchable).