• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help required : Copy and Paste - from sheet to sheet

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
 

Attachments

  • ANDHRA AMC OS final TO MR senthil- Resulted.xlsx
    74.2 KB · Views: 2
Dear RM Senthilkumar,

You have not mentioned on what basis the pasting has to be done.
Whether based on contract number or any other criteria.

If the same is known, we can use MATCH and INDEX functions to pickup those
details from Sheet DATA 2 and enter the same in Sheet DATA 1.

with best regards

Arun N
 
Dear Arun,

Need to paste the data - final remarks column from data 2 to the sheet 1 data

Since in sheet 1 data - some rows are hided as it is filtered -
Data 2 sheet not filtered and the corresponding line item is same

if we use Visible cells option from 1 to 19 row it is pasting whereas it Not picking the remarks of row 18 from data 2 sheet and pasting it in the respective row which is visible now - row # (since some are hiding )

Please help
 
Dear RM Senthilkumar,

If Line items are same, In DATA sheet Simply type ='DATA 2'!D2 in A2 cell.

Copy that cell.
Select the cells from A3 to A88.
Press Ctrl+G and Alt+S for Goto Special.
Select Visible cells option and enter.
Paste the result by pressing Ctrl+V.

I hope this solves the problem

with best regards

Arun N
 
Back
Top