senthilkumar_rm
Member
Dear Excel experts ,
I have a excel file with 2 sheets -
From Sheet 2 need to paste data to sheet 1 which is filtered ; whereas sheet 2 is not filtered
See uploaded file for same -
Need to fill the column A " Final remarks " from DATA 2 sheet
DATA - sheet 1 - Filtered
DATA 2 - Sheet 2 - Not filtered
Unable to use " Visible cells options" as when used - it is taking copying the hided cells also
Excel 2007 used
I have a excel file with 2 sheets -
From Sheet 2 need to paste data to sheet 1 which is filtered ; whereas sheet 2 is not filtered
See uploaded file for same -
Need to fill the column A " Final remarks " from DATA 2 sheet
DATA - sheet 1 - Filtered
DATA 2 - Sheet 2 - Not filtered
Unable to use " Visible cells options" as when used - it is taking copying the hided cells also
Excel 2007 used