Forum Discussion
Something very easy
Hello, I am good with Excel, I create and manage large spreadsheets with algorimths. This question is not for me, this is for my friend. He has almost no skill or experience with Excel. He can barel...
If it will be e-mailed why not copy and paste directly into the e-mail?
they could also use Win-Shift-S (to screen capture an area) and then paste that image into the email.
Since you are talking about putting it in a new workbook and sending that workbook I assume you don't want them to have/see the rest of the data. A trick I have done using google sheets is to have a master workbook and a tab in that master workbook that I use to pull out the appropriate data. Then I have another google sheets workbook that uses the function importrange and pull in everything from that tab. To set it up you have to give the 'outside sheet' permission to access that main sheet, but only 1 time. The function call uses a range parameter so security wise, if the end person can guess the names of your tabs they could see the other data from other tabs. I usually just e-mail a pdf of that separate file so they can't even try that. But you can make those tab names obscur enough to be as good as a password and once set up the 'end user' would automatically get the updated data. I thnk a similar set-up can be done using oneDrive but I have had issues with data updating and getting the security setting right when I originally set it up years ago.
they could also use Win-Shift-S (to screen capture an area) and then paste that image into the email.
Since you are talking about putting it in a new workbook and sending that workbook I assume you don't want them to have/see the rest of the data. A trick I have done using google sheets is to have a master workbook and a tab in that master workbook that I use to pull out the appropriate data. Then I have another google sheets workbook that uses the function importrange and pull in everything from that tab. To set it up you have to give the 'outside sheet' permission to access that main sheet, but only 1 time. The function call uses a range parameter so security wise, if the end person can guess the names of your tabs they could see the other data from other tabs. I usually just e-mail a pdf of that separate file so they can't even try that. But you can make those tab names obscur enough to be as good as a password and once set up the 'end user' would automatically get the updated data. I thnk a similar set-up can be done using oneDrive but I have had issues with data updating and getting the security setting right when I originally set it up years ago.