how to paste cells correctly even in the filtered data

[catchnanan]

hai friends

i have data like the below in columns A B C

NAME AGE COUNTRY
A 45 US
B 78 INDIA
C 45 US
D 12 LONDON
E 45 INDIA
F 75 US
G 12 INDIA
H 56 US

i am filtering the above to country US like

NAME AGE COUNTRY
A 45 US
C 45 US
F 75 US
H 56 US

Now i have Qlfctn details for A C F H (all from US) like

MBA
BSC Chemical
MSC
BCOM

when i copy and paste the above in the column D ,it does not fit proprly because of filtered data

please kindly help

[catchnanan]

Hai really appreciating your help

[catchnanan]

can anybody help me with this simple problem.........
though it is simple i need it very badly for my project

Or any thing wrong with the way i explained please kindly tell me if so..

[catchnanan]

Can any body give suitable solution to this

[protonLeah]

To attach a Workbook
(please do not post pictures of worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"