Hide rows on part of sheet

[El_engineer]

Hi, I have a table on a sheet and you can select/filter some rows. The problem is that on the right i want to have some results with macros etc.
So I have to place everything well above the table because when you filter, rows are hidden and everything is messed up. Is there a way to
"separate" the right part? So that when I hide/show rows on the table, it is not affected?

[adyteo]

when you hide a row, you hide the complete row, not only parts of it (a few cells)

[TMS]

Short answer: no.

Long answer: you could put those calculations on a separate sheet and then use the Camera Tool to make an interactive copy of the contents on the first sheet.

http://blogs.mccombs.utexas.edu/the-...tool-in-excel/


Regards, TMS

[El_engineer]

I also thought it's impossible but I have never heard of the camera tool before! Thanks.

One more thing. What is the best way to copy the filtered data from a table? Let's say
there is table named "Table1", you filter 50 out of 500 rows and you want to copy them
on a sheet1. What's the best way because I have seen many possible solutions.

I would say:

Please Login or Register  to view this content.