Mirror only visible cells

[bpyoung83]

Hey guys,

I have a row in my "Data" sheet that I want to have mirrored on my "Individual" sheet, so that when the numbers change on the "Data" sheet they will update on the "Individual" sheet. The problem is, there are hidden rows that I do not want mirrored. When I use the "=" formula it is pulling all the hidden data from the "Data" sheet onto the "Individual" sheet.

Is there a way that I can only mirror the visible cells?

[Pauleyb]

See if the Camera tool will do what you need. Google 'Excel 2010 Camera' since it is tricky to 'enable' the camera tool.

What it will do is create a window that 'mirrors' your data from the other page, including hidden rows, but the data from the camera window is not selectable (you would need to go to the source page).

[bcas77]

Can you supply a test workbook showing what you want? There is a way to copy/paste only visible cells

[bpyoung83]

Thanks guys, I just broke it down into four different sections and it works.