Working over picture, listing formulas and data transfer help

**Mattance** · 07-11-2009, 10:22 AM

hi im very new to using excel so these questions are probable really easy for alot of you.

1st thing id like to know. is there any way to inset a picture (not using the background button coz i dont want to tile the pic) and then be able to work ontop of it?

2nd is there a formula to change the order of a list depending on the number (high to low) in 1 of my other box's

3rd how do i take a result from one page and copy it automaticly to another?

sorry if this is hard to understand but if u have msn i could show you what im trying to do if it makes it any easyer

thanks for reading =]

**shg** · 07-11-2009, 10:43 AM

Welcome to the forum.

Please take a few minutes to read he forum rules, and then amend your thread title accordingly.

**DaveM13** · 07-11-2009, 10:51 AM

1. Copy the picture and paste it into your sheet

2. highlight the information you want to sort, then click on data > sort

3. click on the cell you want the information to be copied into, type "=", then click on the page you want to copy from, select the cell you want to copy from and then press enter.

Hope this helps.
Dave

**Mattance** · 07-11-2009, 11:00 AM

Originally Posted by DaveM13

1. Copy the picture and paste it into your sheet

1st thing i tried. i pasted the image but my work is behind it. i tried to "send to back" but had no joy

2. highlight the information you want to sort, then click on data > sort

im working on a mini league thing for a gameing clan im part of and the info hasnt been put in yet. theres a points heading which will have players points. i want to get the position heading to work out who has the most points and then (if possible) re order the table numberd 1-18

3. click on the cell you want the information to be copied into, type "=", then click on the page you want to copy from, select the cell you want to copy from and then press enter.

thanks that worked perfect

**DaveM13** · 07-11-2009, 11:05 AM

In regards to the image, are you also using textboxes on your sheet?

In regards to the data sort, do you mean that there is a table, and you want it to automatically resort everytime more points are added?

Dave

**Mattance** · 07-11-2009, 11:20 AM

i just right click - past for the image

and yes about the points. id like it to just be a case of adding new points and the table do the rest of the work its self idealy =]

**DaveM13** · 07-11-2009, 11:29 AM

I'm afraid my knowledge of excel isnt great enough to help you on this one.

Hope you find someone whio can help,
Sorry,
Dave

**shg** · 07-11-2009, 11:41 AM

Pictures are on a drawing layer above the cells -- you cannot move it behind the cells. The best you can do is add transparency to expose selected cells.

**Mattance** · 07-11-2009, 11:58 AM

how do i do this? ive seen the transparency thing on format but what ever i do with it doesnt seem to have any effect =S

**shg** · 07-11-2009, 12:03 PM

Use the Set Transparent Color button on the Picture Toolbar

**Mattance** · 07-11-2009, 12:22 PM

hmm i cant find that button =S im using Microsoft Office Enterprise 2007 version

**shg** · 07-11-2009, 12:28 PM

Select the picture, Picture Tools > Format > Adjust group, Recolor, Set transparent color.

Please change your profile to show the version of Excel you use.

**Mattance** · 07-11-2009, 12:43 PM

ok thanks ive done that but it didnt have the desired effect.

just need help with

2. highlight the information you want to sort, then click on data > sort
im working on a mini league thing for a gameing clan im part of and the info hasnt been put in yet. theres a points heading which will have players points. i want to get the position heading to work out who has the most points and then (if possible) re order the table numberd 1-18

now =]

**shg** · 07-11-2009, 12:45 PM

Post a workbook and explain in context.

**Mattance** · 07-11-2009, 01:27 PM

ok well heres a pic of how it looks

what i want to do is have a formula in "position" that works out who has the most points, and assign them "position 1", 2nd highest points "position 2" etc etc and if at al possible move the whole row from "D" to "N" and re order accordingly

i hope this makes sense but if ur confused, let me know

**shg** · 07-11-2009, 01:46 PM

See the RANK function.

**Mattance** · 07-11-2009, 07:06 PM

soz mate but ive got no idea what a rank system is

**shg** · 07-11-2009, 08:09 PM

In N2 and copy down, =RANK(M2, M$2:M$19)

**Mattance** · 07-12-2009, 05:48 AM

fantastic! nice 1 pal =D

is there any way to make it re order the row? from c-n?

**Mattance** · 07-12-2009, 10:03 AM

this is a pic of how it looks

what i want to do is have a formula set up that works out who has the best position and then re order the number rows to put the player in position 1 at the top. so just moving cells c-n

Working over picture, listing formulas and data transfer help

LinkBack

Thread Tools

Rate This Thread

Display

Working over picture, listing formulas and data transfer help

Re: few questions

Re: Picture and formula problems

Re: Picture and formula problems

Re: Working over picture, listing formulas and data transfer help

Re: Working over picture, listing formulas and data transfer help

Re: Working over picture, listing formulas and data transfer help

Re: Working over picture, listing formulas and data transfer help

Re: Working over picture, listing formulas and data transfer help

Re: Working over picture, listing formulas and data transfer help

Re: Working over picture, listing formulas and data transfer help

Re: Working over picture, listing formulas and data transfer help

Re: Working over picture, listing formulas and data transfer help

Re: Working over picture, listing formulas and data transfer help

Re: Working over picture, listing formulas and data transfer help

Re: Working over picture, listing formulas and data transfer help

Re: Working over picture, listing formulas and data transfer help

Re: Working over picture, listing formulas and data transfer help

Re: Working over picture, listing formulas and data transfer help

Re: Working over picture, listing formulas and data transfer help

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions