I have a small table with pictures in column C. I want to e able to sort the table by column B and have the pictures in the cells in column C sort with their corresponding data. How do I do that? Right now, the table sorts but the pictures don't move.
View 3 RepliesI have an workbook with pictures that are linked to external picture files, and they are placed in the workbook via macro. When I email the file to another computer and open it, the pics do not display and show an error:
The linked image cannot be displayed. The file may have been moved, renamed, or deleted, Verify that the link points to the correct file and location.
I would like to be able to save the workbook with the pictures in them (without having to archive them) so that I can open it and see them on another machine.
How do I insert pictures into Excel's cells, so as to get a mosaic of say 2x3 pics?
Trying to just drag a pic onto a cell does not make the pic sticks. I need the pics to behave like in frames in HTML, including moving, resizing etc. Same for video clips that I want running within the cells.
Ive been trying to find a way of inserting a picture into a defined merged cell. Once I insert the pic I would like it to auto size/fit into the merged cells.
I have only managed to do this by either resizing the pic's first, or running a retro macro to resize the image. Just wondering if there was an easier way?
I have data on 400 rows. Each row has a maximum of 10 cells with data, but many have empty cells with no data. I would like to sort each row to show values of cells in sequence and eliminate empty cells. I can use the sort row function but its a long process for 400 individual rows. Is there an easier way?
View 1 Replies View RelatedWhat is the formula for results in C?
A | B | C
NAME|RNK|SORT
Frank|2|David
Jane |3|Frank
Lisa |5|Jane
David|1|John
John |4|Lisa
Abby |6|Abby
How do you sort a column of numbers with hyphens?
Example #####-###-####.
I want to sort by the 3 middle numbers
i have a problem to sort merged cells in the file attached. i tried via macro but could not reached a good solution. I have 30 plans inside the sheet and even manually is too hard to do it because i use some "=" to not type again every number since some are the same but when i try to sort the lines became diferent values.
View 10 Replies View RelatedI have a spreadsheet that I am tryng to sort. I am sorting a range of cells. I get my list sorted how I want but then I want to go one step further which is why I am seeking assistance. After my initial sort I want to select just a few specific cells and resort only them.
I am identifying the cells I want to sort by placing "zzzSort" in column V (V267 to V516) ("zzzSort" is placed in the desired cells automatically).
Is there a VBA code that I can place after my original sort code that would select the rows with "zzzSort" in Column V and then run only those ones through anouther sort.
How would I go about sorting a selection of non-contiguous cells?
View 5 Replies View RelatedI would like to make a piece of VBA code that will copy the data from B3:C11 (fist sheet) and put it into the individual columns (second sheet). The columns are named ID, name, e-mail, phone, value, address.
The second sheet should therefore act as some kind of database, where new entries are put below the last one. Also, it would be great if the program checked at first whether the ID is already written in the sheet2(database) and if so, it would write an error message.
Included : samplexxx.xlsx
I am trying to add a macro that will sort everything by what is in column A (not the first row though) and then have it expand the selection to the entire row and sort it. so basicly it would do the same as me clicking sort and filter and then selecting sort largest to smallest and then selecting yes to expand the selection. I have found some that sort only column A but nothing that changes it all.
View 2 Replies View RelatedI have a fairly simple sheet that I'm trying to sort (and have in the past) using Data/Sort on 3 columns.
I do not know what a 'merged' cell is, so have no knowlingly formatted a cell as 'merged'. I have populated some cells with information copied from other applications, so they may be 'merged'.
When I try to sort I get the message: - this operation requires the merged cells to be identically sized. to avoid this behavior, unmerge all the merged cella in the range or....
How the heck do I even find the merged cells that are causing the problem?
I have the problem to sort data in the single cell, i have search in this forum but no solution found for example my data like this:
CELL A1: R1, R7, R103, R50, R5
CELL A2: C8, C22, C2, C5
CELL A3: DB9, DB12, DB6, DB60, DB4
i want the macro to sort content in cell become:
CELL A1: R1, R5, R7, R50, R103
CELL A2: C2, C5, C8, C22
CELL A3: DB4, DB6, DB9, DB12, DB60
In the attached spread sheet, i have two set of data, for two different months.Columns A to D have the value for the first month and columns F to I have the values for the second month. In the first set of Values i have the dollar value in the column "D" and in the second set of values i have the dollar value in column "F".
I want a macro, to compare these two cells and arrange the data accordingly. If both the values are the same, then both the lines corresponding to the values can remain in the same row. If one value is greater that other, then the set of values which have the lower dollar value should come to the next row. I have attachec the sample data. The lines highlighted in green is the raw data and the one in yellow is the finished data.
How can I sort across 2 columns?
As an example.. If I have the word "Text" placed in columns A and B at various rows (mixed with other words)
What sorting order can I use that will sort the entire row, based on both columns A, B. ( would like initiate via vba script)
Begin with this:
A , B
.....,.....
.....,.....
Text,....
.....,.....
.....,.....
.....,Text
.....,Text
Text,.....
.....,.....
.....,.....
.....,Text
.....,.....
Text,....
After sorting order:
Text,.....
.....,Text
.....,Text
Text,.....
.....,Text
Text,....
.....,.....
.....,.....
.....,.....
.....,.....
.....,.....
.....,.....
I have just done a vba project of striping chars (QOOO1=) from each cell
and then sorting the records on column6/question6
however i have been able to do this and display results in second worksheet(Results2)
I feel there is a better way to do it and display the results on same worksheet
Could anyone take a look at the file and help.
IMPORTANT:Place curse on "Results2" worksheet and run the macro:Pres
Do not run the macro on main sheet all data will be lost and will have to download again.
File:[url]
I have been trying to sort the cells in a worksheet, but am unable to properly select the range of cells I need
For Each ws In Worksheets
If ws.Name <> "MySheet" Then Goto nxt
If ws.Name = "MySheet" Then Worksheets("MySheet").Activate
Range("A1:F" & totval).Select
Selection.Sort Key1:=Range("F1"), Order1:=xlDescending, Header:=xlYes, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
nxt:
Next ws
the code mentioned above throws an error when it gets to the range.select line. I cannot simply say usedrange.select.
It keeps throwing error 1004.
Please ignore the "& totval" in above code. That was my attempt at specifying the last row number, which i specified in the totval variable
I dont know how exactly to specify the range of cells containing data in the activated worksheet above, and then select them for sorting.
im using comments to display images for easy look up
when i save a picture i want it to be that size when i hovver over the comment
but when i insert the picture it doesnt open the size that i saved it as
i manually have to resize the image so its legible
why is this and is there a way round this?
I have grouping setup in my excel spread sheet.
1. I added pictures(print screen-->mspaint-->cut existing part of the image-->paste into excel. In excel they are called "Pictures 01 thru Picture X" with the pull points all around.
2. I located them in specific cells of the grouped type with the (-) sign appears so the group of cells are in use
3. When I close the Group(+) of cells all the pictures are jumbled above the closed cells.
Question: Is there away to keep these pictures within those cells when closing the group, so they will not been see as well?
is you had two ratings, one bad, one good, could you make a differant picture show up for the differant ratings using an IF function or simmiler fuctions (So like if a 'dance rating' is bad if it is under 13 and is good over 13 then have a picture of John Travolta for good and a picture of a hippo for bad as a bit of a joke on a identinty card sort of thing)?
I know quite alot about exel and have tried to make my formular but as it is saved on the school server i can not acsess it until tomorrow but i will try and make that work and post it if it dose
Is there a way to write code to delete all the pictures on a worksheet called "Pictures"?
View 9 Replies View RelatedI have imported and deleted several pictures into my worksheet. I want to re- name or re-order my pictures. Right now, a new pictures is name "picture 4" when there might only be two pictures in the sheet. I want to rename to say "picture 2" as I have a macro that calls for "picture 2" I know this should be simple, but I don't know how to do this.
View 4 Replies View RelatedIn the screenshot attached I want to sort on PrioCd, but I am unable to presumably because there are empty cells. How can I sort by PrioCd for each ECDNo?
pivot_sort.png
My columns are labeled A B C D etc... If the product I am creating the table for falls into one of those categories I place a 1 in the cell. For instance, ProductA falls into the A and B categories, so column A will get a 1 and column B will get a 1. This is so I can sort all of category A's Products etc...
I am looking for a formula to put in a column that would Say what categories ProductA falls into. ie Since ProductA falls into the A and B catergories but not the C and D catergories, This final column would say something like AB, or A,B or something.
Alternatively, I could make a single column entiltled 'categories' and put something like 'A B' in ProductA's column. In this case I would need a way to sort all A's or sort all B's and not just sort all 'A B'
I am working on a Golf League score sheet, and each week there may be a different amount of players that play. I have a weekly worksheet (attached) that contains the full list of golfers that had played that week and I only want to sort the columns for those golfers who have a score greater than 0 (this would be the ones who played that week). You can see that in week 1 I had more players than in week 2. So in my weekly worksheet I sort these sub grids by Score first. However I ONLY want to sort the rows that have a score greater than 0. Can this be done in VBA or am I stuck doing this manually every week?
Week1.PNG
Week2.PNG
Is there any way to allow autofiltering and sorting even with locked cells within the range to be sorted? I've conditionally locked some cells based on user input, and at the end of my vb code I have allowsorting and allowfiltering. But I want to sort cells that are locked even after that. Does anyone know if that's even possible with VB?
View 4 Replies View RelatedIn the worksheet "Batting and Pitching Register", I'd like to be able to sort the data in the two charts (APBA Batting Register and APBA Pitching Register) by simply clicking on the cells in the respective header rows.
I've set up ranges (Batting and Pitching), but have had no luck moving beyond that.
I'm using a total of 20 Rows and 2 Columns. Each row has Column A for Description and Column B for Score. There are total 10 subjects with 10 noneditable rows, and 10 editable rows.
I'd like to protect column A and B for rows 1 to 10 and unprotect only Column B for rows 11 to 20. When any cells from Column B, rows 11 to 20 updates, I'd like to automatically sort columns A+B for ONLY rows 1 to 10.
Therefore, rows 1 to 10 need to be sorted based on the scores on Column B, and since rows 11 to 20 are just input fields, they are never to be sorted.
Column B for Rows 1-10 will be formulas and are based on Column B values from rows 11-20.
When a value in any of the rows 11-20 of Column B is updated, Range A1:B10 will automatically sort from highest score to lowest score (Column B).
Since Column B for rows 1 to 10 contains formulas and not actual values, would it throw off the order of things when sorting formulas?
the macro coding to perform this task.
Here is just a visual of what the spreadsheet will look like
....A B
=======
1||A (B11)
2||B (B12)
3||C (B13)
4||D (B14)
5||E (B15)
6||F (B16)
7||G (B17)
8||H (B18)
9||I (B19)
10||J (B20)
11||A 10
12||B 9
13||C 8
14||D 7
15||E 6
16||F 5
17||G 4
18||H 3
19||I 2
20||J 1
The Bold are editable fields. and I want to use auto sort A1:B10 based on updated values of B11 to B20.
I have also attached the basic excel file that situates my concern.
Is there a way of removing empty cells from a range whilst preserving the top row? As an example, I want to change this spreadsheet...
a b c d r
rrr
rrr
[Code]....