Hi,
I have a report that I run each week and send to employees who then have to copy the rows and paste them onto their ongoing Excel sheet. The problem I am having is if I send the report by email as is, the hidden columns are still hidden, but when they copy and paste it into their excel, they get all the hidden columns and would have to go in and delete each one.
I have been copying and pasting just the columns they need into an excel sheet and sending it to them, but this is very time consuming.
I'd like to be able to just send the jet report version and have them be able to just copy it. I have tried to use the scheduler and use the values only workbook, but for some reason, when it gets sent, anything that is using a formula in one of the hidden columns doesn't come out right.
Thank you for any help you can give on this.
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi Keswick,
As I have no idea what your reports are, I have 2 suggestions:
- restructure your report so that the hidden column are not within the range of columns that your colleagues need to copy and paste;
- if you want to use the 'values only' option… make these specific columns visible, and then resize them so that they are very very small and use a white font.
Not technically sophisticated but if it works it works :) -
Jet Reports Historic Posts hi,
"Prevent hidden columns from being copied" could be done with Excel-function "Find&Select/ go to special/visible cells only" after marking all cells, then copy and paste….
Does this work for you?
regards
jetsetter -
Jet Reports Historic Posts And there is the possibility to remove hidden columns/rows/sheets when creating a schedule with the Plan button on the Jet ribbon.
That might be worth looking at too.
HTH
rmw
Please sign in to leave a comment.