Hi team,
We got a big trouble while working on data in excel.
We tried to copy a list of values that are straight not hide or unhide.
And then paste to other sheet in same file in visible cells only by using command “=Sheet1!Cell
reference” and then Ctrl+enter.
It do copy only upto straight sequence like 1-8 and then 9th & 10th cell hide then 11th cell require value due to visible cells but it unable to do so.
So the basic problem occur due to copy from a file which is straight and paste to other only in visible cells only in other sheet.
But pasting wouldn’t consider the visible cells and paste the number in hide cells also.
Hope you understand my problem.
Kindly provide the solution asap
Just click Alt+F11 then click insert and then click module
Copy below code :
Then press F5 to run then it ask to copy range and then paste range.
Just click on copy what you would like to copy and then click paste range where would like to paste either visible or not
Thanks team for further clarify the problem which helped me to find the above codes.