ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Embedded objects(?) (https://www.excelbanter.com/excel-discussion-misc-queries/242956-embedded-objects.html)

Brad

Embedded objects(?)
 
Using Excel 2007

What I would like to do is to take 10 cells 5 wide 2 deep and basically take
a "picture" of this and drop this in another area of the same spreadsheet. I
need to do this because of formating issues. I would like this be smart
enough when the source data changes the "picture" changes. I've seen this
done before, but not sure how to start (or what to search for). Not sure the
subject description is entirely accurate

Jim Thomlinson

Embedded objects(?)
 
Not too sure about use of the camera tool in 2007 but here is a link to check
out...

http://spreadsheetpage.com/index.php...e_camera_tool/
--
HTH...

Jim Thomlinson


"Brad" wrote:

Using Excel 2007

What I would like to do is to take 10 cells 5 wide 2 deep and basically take
a "picture" of this and drop this in another area of the same spreadsheet. I
need to do this because of formating issues. I would like this be smart
enough when the source data changes the "picture" changes. I've seen this
done before, but not sure how to start (or what to search for). Not sure the
subject description is entirely accurate


Brad

Embedded objects(?)
 
Jim,
As always, I appreciate the help and now have the little camera on my quick
access tool bar (as a reminder).
--
Wag more, bark less


"Jim Thomlinson" wrote:

Not too sure about use of the camera tool in 2007 but here is a link to check
out...

http://spreadsheetpage.com/index.php...e_camera_tool/
--
HTH...

Jim Thomlinson


"Brad" wrote:

Using Excel 2007

What I would like to do is to take 10 cells 5 wide 2 deep and basically take
a "picture" of this and drop this in another area of the same spreadsheet. I
need to do this because of formating issues. I would like this be smart
enough when the source data changes the "picture" changes. I've seen this
done before, but not sure how to start (or what to search for). Not sure the
subject description is entirely accurate



All times are GMT +1. The time now is 02:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com