Using the Camera Tool in Excel
video description
Date: 2022-04-08
Related videos
Comments and reviews: 9
Geo
Great info! Thank You.
I am familiar with what you just demonstrated. Getting a bit deeper though I am trying to use VB code in a macro to run the Excel Camera Tool ie. Select a section of data, click the camera tool and then place it in another location on same worksheet or different worksheet... Attempted to run a macro of these actions but I get a code error. This would be a macro that captures the SAME area of data each time and would allow me to place the -Dynamic Picture- elsewhere.
reply
Great info! Thank You.
I am familiar with what you just demonstrated. Getting a bit deeper though I am trying to use VB code in a macro to run the Excel Camera Tool ie. Select a section of data, click the camera tool and then place it in another location on same worksheet or different worksheet... Attempted to run a macro of these actions but I get a code error. This would be a macro that captures the SAME area of data each time and would allow me to place the -Dynamic Picture- elsewhere.
reply
Alvin
IF you copy and paste as link, you can have a even better experience than using camera, at least you don't have to bother the size of each picture, but still the data is dynamic as it is linked, not a good way of using camera to select data in table.
reply
IF you copy and paste as link, you can have a even better experience than using camera, at least you don't have to bother the size of each picture, but still the data is dynamic as it is linked, not a good way of using camera to select data in table.
reply
Lallie
Camera's new to me: neat! Love the linking. Could you hide columns you don't want before using the camera? How about using Ctrl to select just the data you want to capture? Haven't tried other ways to select data, but will do.
reply
Camera's new to me: neat! Love the linking. Could you hide columns you don't want before using the camera? How about using Ctrl to select just the data you want to capture? Haven't tried other ways to select data, but will do.
reply
Antonis
Very good Guide!!!
If -snapshot- taken from different spreedsheet, that spreedsheet must be open to update the data...
Is there any other way to update the -snapshot- from other spreedsheet?
reply
Very good Guide!!!
If -snapshot- taken from different spreedsheet, that spreedsheet must be open to update the data...
Is there any other way to update the -snapshot- from other spreedsheet?
reply
joe
Hi Sir, good video!
I did notice that this command is almost (if not) the same as -copy and paste as linked image/picture- (option when you paste a copied range of cells).
reply
Hi Sir, good video!
I did notice that this command is almost (if not) the same as -copy and paste as linked image/picture- (option when you paste a copied range of cells).
reply
Jeanine
Who knew? Had NO clue this was even there! You could (and should) do a whole series on all these commands not so common, but so very useful! Thanks so much!
reply
Who knew? Had NO clue this was even there! You could (and should) do a whole series on all these commands not so common, but so very useful! Thanks so much!
reply
Elizabeth
This is great. I also learned about how to move the sheet tabs at the bottom. This will save me much time cutting and pasting!!
reply
This is great. I also learned about how to move the sheet tabs at the bottom. This will save me much time cutting and pasting!!
reply
Vidya
Oh wow this video was a humbling experience. I thought I knew Excel well! I never knew about this feature, thanks for the video :)
reply
Oh wow this video was a humbling experience. I thought I knew Excel well! I never knew about this feature, thanks for the video :)
reply
mxmed
I was confused by the lessons...
you forgot the lessons numbers.. playtist lesson 1 lesson2..where to start the lesson...
reply
I was confused by the lessons...
you forgot the lessons numbers.. playtist lesson 1 lesson2..where to start the lesson...
reply
Add a review, comment
Other channel videos
