Hello,

I'm building a budget sheet that has the months across the top of the sheet. In each column managers will input their projected budget. In each column beside the projected month's column I've input a formula that will be calculate out the prior year's actual values. These columns will be hidden throughout the budget process.

The problem I'm having is when a manager inputs a number in the first column, ie January and copies that number all the way through December, this figure is pasted into the hidden columns as well.

Is there a way to paste in only visible columns and not hidden columns?

Thanks.