| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting database with images inserted in cells
Hi!
In a plant I' working in I'm building a machinery preventive maintenance database. In the various fields i need to: a) Identify the department in which the machine is located b) Identify the machine c) Take a picture for each machine d) Identify what needs to be done on the machine e) Assign a priority f) Indicate the date of the assesment g) Indicate on a scale of 1 to 5 how fast the maintenance can be done h) Indicate a date of realization .... Essentially, I would like to be able to do various sorting of this database (by priority, the fastest/easiest maintenance that can be done (or the hardest), by department etc...). However, when I insert all the info in a row and I put an image in a cell, once I do a sort the image stays in the original cell that I put it in, it won't follow the rest of the data. Any ideas on how I can achieve this? -- Thanks ! Greywolf |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sorting database with images inserted in cells
Greywolf,
Place the image in a comment. Comments sort with the cell. Debra Dalgleish shows how here... http://www.contextures.on.ca/xlcomments02.html#Picture Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Greywolf" wrote in message Hi! In a plant I' working in I'm building a machinery preventive maintenance database. In the various fields i need to: a) Identify the department in which the machine is located b) Identify the machine c) Take a picture for each machine d) Identify what needs to be done on the machine e) Assign a priority f) Indicate the date of the assesment g) Indicate on a scale of 1 to 5 how fast the maintenance can be done h) Indicate a date of realization Essentially, I would like to be able to do various sorting of this database (by priority, the fastest/easiest maintenance that can be done (or the hardest), by department etc...). However, when I insert all the info in a row and I put an image in a cell, once I do a sort the image stays in the original cell that I put it in, it won't follow the rest of the data. Any ideas on how I can achieve this? -- Thanks ! Greywolf |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sorting database with images inserted in cells
Hi Jim!
Thanks for the tip. I should've mentionned that once the database is sorted, I would like the image to be present at all times and "fitted" in the cell that it was inserted in. Any ideas on taking this a step further? -- Thanks a million! (not dollars unfortunately!!) Greywolf "Jim Cone" wrote: Greywolf, Place the image in a comment. Comments sort with the cell. Debra Dalgleish shows how here... http://www.contextures.on.ca/xlcomments02.html#Picture Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Greywolf" wrote in message Hi! In a plant I' working in I'm building a machinery preventive maintenance database. In the various fields i need to: a) Identify the department in which the machine is located b) Identify the machine c) Take a picture for each machine d) Identify what needs to be done on the machine e) Assign a priority f) Indicate the date of the assesment g) Indicate on a scale of 1 to 5 how fast the maintenance can be done h) Indicate a date of realization Essentially, I would like to be able to do various sorting of this database (by priority, the fastest/easiest maintenance that can be done (or the hardest), by department etc...). However, when I insert all the info in a row and I put an image in a cell, once I do a sort the image stays in the original cell that I put it in, it won't follow the rest of the data. Any ideas on how I can achieve this? -- Thanks ! Greywolf |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sorting database with images inserted in cells
Greywolf,
I just did some experimenting. If all of the row heights are the same size and the pictures are fitted into the cell borders (use the alt key) then the pictures sort with the data. Jim Cone "Greywolf" wrote in message Hi Jim! Thanks for the tip. I should've mentionned that once the database is sorted, I would like the image to be present at all times and "fitted" in the cell that it was inserted in. Any ideas on taking this a step further? -- Thanks a million! (not dollars unfortunately!!) Greywolf "Jim Cone" wrote: Greywolf, Place the image in a comment. Comments sort with the cell. Debra Dalgleish shows how here... http://www.contextures.on.ca/xlcomments02.html#Picture Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Greywolf" wrote in message Hi! In a plant I' working in I'm building a machinery preventive maintenance database. In the various fields i need to: a) Identify the department in which the machine is located b) Identify the machine c) Take a picture for each machine d) Identify what needs to be done on the machine e) Assign a priority f) Indicate the date of the assesment g) Indicate on a scale of 1 to 5 how fast the maintenance can be done h) Indicate a date of realization Essentially, I would like to be able to do various sorting of this database (by priority, the fastest/easiest maintenance that can be done (or the hardest), by department etc...). However, when I insert all the info in a row and I put an image in a cell, once I do a sort the image stays in the original cell that I put it in, it won't follow the rest of the data. Any ideas on how I can achieve this? -- Thanks ! Greywolf |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sorting database with images inserted in cells
Great! Last question Jim.
I will need to print this database to show our maintenance supervisor repairs and or modifications to various machines that are in the database. Will I be able to print the pages of the database along with the pictures? -- Thanks again! Greywolf "Jim Cone" wrote: Greywolf, I just did some experimenting. If all of the row heights are the same size and the pictures are fitted into the cell borders (use the alt key) then the pictures sort with the data. Jim Cone "Greywolf" wrote in message Hi Jim! Thanks for the tip. I should've mentionned that once the database is sorted, I would like the image to be present at all times and "fitted" in the cell that it was inserted in. Any ideas on taking this a step further? -- Thanks a million! (not dollars unfortunately!!) Greywolf "Jim Cone" wrote: Greywolf, Place the image in a comment. Comments sort with the cell. Debra Dalgleish shows how here... http://www.contextures.on.ca/xlcomments02.html#Picture Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Greywolf" wrote in message Hi! In a plant I' working in I'm building a machinery preventive maintenance database. In the various fields i need to: a) Identify the department in which the machine is located b) Identify the machine c) Take a picture for each machine d) Identify what needs to be done on the machine e) Assign a priority f) Indicate the date of the assesment g) Indicate on a scale of 1 to 5 how fast the maintenance can be done h) Indicate a date of realization Essentially, I would like to be able to do various sorting of this database (by priority, the fastest/easiest maintenance that can be done (or the hardest), by department etc...). However, when I insert all the info in a row and I put an image in a cell, once I do a sort the image stays in the original cell that I put it in, it won't follow the rest of the data. Any ideas on how I can achieve this? -- Thanks ! Greywolf |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sorting database with images inserted in cells
G,
Why not try printing a page? Jim Cone "Greywolf" wrote in message Great! Last question Jim. I will need to print this database to show our maintenance supervisor repairs and or modifications to various machines that are in the database. Will I be able to print the pages of the database along with the pictures?-- Thanks again! Greywolf "Jim Cone" wrote: Greywolf, I just did some experimenting. If all of the row heights are the same size and the pictures are fitted into the cell borders (use the alt key) then the pictures sort with the data. Jim Cone "Greywolf" wrote in message Hi Jim! Thanks for the tip. I should've mentionned that once the database is sorted, I would like the image to be present at all times and "fitted" in the cell that it was inserted in. Any ideas on taking this a step further? -- Thanks a million! (not dollars unfortunately!!) Greywolf "Jim Cone" wrote: Greywolf, Place the image in a comment. Comments sort with the cell. Debra Dalgleish shows how here... http://www.contextures.on.ca/xlcomments02.html#Picture Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Greywolf" wrote in message Hi! In a plant I' working in I'm building a machinery preventive maintenance database. In the various fields i need to: a) Identify the department in which the machine is located b) Identify the machine c) Take a picture for each machine d) Identify what needs to be done on the machine e) Assign a priority f) Indicate the date of the assesment g) Indicate on a scale of 1 to 5 how fast the maintenance can be done h) Indicate a date of realization Essentially, I would like to be able to do various sorting of this database (by priority, the fastest/easiest maintenance that can be done (or the hardest), by department etc...). However, when I insert all the info in a row and I put an image in a cell, once I do a sort the image stays in the original cell that I put it in, it won't follow the rest of the data. Any ideas on how I can achieve this? -- Thanks ! Greywolf |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sorting database with images inserted in cells
Tried Print Preview, images are not there and when printing images aren't
there either (they are in the database though). -- Greywolf "Jim Cone" wrote: G, Why not try printing a page? Jim Cone "Greywolf" wrote in message Great! Last question Jim. I will need to print this database to show our maintenance supervisor repairs and or modifications to various machines that are in the database. Will I be able to print the pages of the database along with the pictures?-- Thanks again! Greywolf "Jim Cone" wrote: Greywolf, I just did some experimenting. If all of the row heights are the same size and the pictures are fitted into the cell borders (use the alt key) then the pictures sort with the data. Jim Cone "Greywolf" wrote in message Hi Jim! Thanks for the tip. I should've mentionned that once the database is sorted, I would like the image to be present at all times and "fitted" in the cell that it was inserted in. Any ideas on taking this a step further? -- Thanks a million! (not dollars unfortunately!!) Greywolf "Jim Cone" wrote: Greywolf, Place the image in a comment. Comments sort with the cell. Debra Dalgleish shows how here... http://www.contextures.on.ca/xlcomments02.html#Picture Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Greywolf" wrote in message Hi! In a plant I' working in I'm building a machinery preventive maintenance database. In the various fields i need to: a) Identify the department in which the machine is located b) Identify the machine c) Take a picture for each machine d) Identify what needs to be done on the machine e) Assign a priority f) Indicate the date of the assesment g) Indicate on a scale of 1 to 5 how fast the maintenance can be done h) Indicate a date of realization Essentially, I would like to be able to do various sorting of this database (by priority, the fastest/easiest maintenance that can be done (or the hardest), by department etc...). However, when I insert all the info in a row and I put an image in a cell, once I do a sort the image stays in the original cell that I put it in, it won't follow the rest of the data. Any ideas on how I can achieve this? -- Thanks ! Greywolf |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sorting database with images inserted in cells
Greywolf,
What is the .PrintArea set to ? NickHK "Greywolf" wrote in message ... Tried Print Preview, images are not there and when printing images aren't there either (they are in the database though). -- Greywolf "Jim Cone" wrote: G, Why not try printing a page? Jim Cone "Greywolf" wrote in message Great! Last question Jim. I will need to print this database to show our maintenance supervisor repairs and or modifications to various machines that are in the database. Will I be able to print the pages of the database along with the pictures?-- Thanks again! Greywolf "Jim Cone" wrote: Greywolf, I just did some experimenting. If all of the row heights are the same size and the pictures are fitted into the cell borders (use the alt key) then the pictures sort with the data. Jim Cone "Greywolf" wrote in message Hi Jim! Thanks for the tip. I should've mentionned that once the database is sorted, I would like the image to be present at all times and "fitted" in the cell that it was inserted in. Any ideas on taking this a step further? -- Thanks a million! (not dollars unfortunately!!) Greywolf "Jim Cone" wrote: Greywolf, Place the image in a comment. Comments sort with the cell. Debra Dalgleish shows how here... http://www.contextures.on.ca/xlcomments02.html#Picture Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Greywolf" wrote in message Hi! In a plant I' working in I'm building a machinery preventive maintenance database. In the various fields i need to: a) Identify the department in which the machine is located b) Identify the machine c) Take a picture for each machine d) Identify what needs to be done on the machine e) Assign a priority f) Indicate the date of the assesment g) Indicate on a scale of 1 to 5 how fast the maintenance can be done h) Indicate a date of realization Essentially, I would like to be able to do various sorting of this database (by priority, the fastest/easiest maintenance that can be done (or the hardest), by department etc...). However, when I insert all the info in a row and I put an image in a cell, once I do a sort the image stays in the original cell that I put it in, it won't follow the rest of the data. Any ideas on how I can achieve this? -- Thanks ! Greywolf |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sorting database with images inserted in cells
G,
Right-click picture, select Format Picture, on the Properties tab, check Print object. Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Greywolf" wrote in message Tried Print Preview, images are not there and when printing images aren't there either (they are in the database though). Greywolf "Jim Cone" wrote: G, Why not try printing a page? Jim Cone "Greywolf" wrote in message Great! Last question Jim. I will need to print this database to show our maintenance supervisor repairs and or modifications to various machines that are in the database. Will I be able to print the pages of the database along with the pictures?-- Thanks again! Greywolf "Jim Cone" wrote: Greywolf, I just did some experimenting. If all of the row heights are the same size and the pictures are fitted into the cell borders (use the alt key) then the pictures sort with the data. Jim Cone "Greywolf" wrote in message Hi Jim! Thanks for the tip. I should've mentionned that once the database is sorted, I would like the image to be present at all times and "fitted" in the cell that it was inserted in. Any ideas on taking this a step further? Thanks a million! (not dollars unfortunately!!) Greywolf "Jim Cone" wrote: Greywolf, Place the image in a comment. Comments sort with the cell. Debra Dalgleish shows how here... http://www.contextures.on.ca/xlcomments02.html#Picture Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Greywolf" wrote in message Hi! In a plant I' working in I'm building a machinery preventive maintenance database. In the various fields i need to: a) Identify the department in which the machine is located b) Identify the machine c) Take a picture for each machine d) Identify what needs to be done on the machine e) Assign a priority f) Indicate the date of the assesment g) Indicate on a scale of 1 to 5 how fast the maintenance can be done h) Indicate a date of realization Essentially, I would like to be able to do various sorting of this database (by priority, the fastest/easiest maintenance that can be done (or the hardest), by department etc...). However, when I insert all the info in a row and I put an image in a cell, once I do a sort the image stays in the original cell that I put it in, it won't follow the rest of the data. Any ideas on how I can achieve this? Thanks ! Greywolf |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| database sorting | Excel Discussion (Misc queries) | |||
| Database sorting | Excel Discussion (Misc queries) | |||
| Excel inserted 0's in cells linked to blank cells | Excel Discussion (Misc queries) | |||
| Keeping date format of a field inserted from an excel database | Excel Worksheet Functions | |||
| how do I sum inserted cells in EXCEL? | Excel Worksheet Functions | |||
![Greywolf[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
