Filtered Data


H

Hardeep_kanwar

Hi! Everybody

I have data which is Filtered and i want to Paste some data in the Blanks
Rows.

I Select Blanks in the Filtered Column then i Copy my data then Paste in the
Blanks rows But it will not work perfectly. some of the data is missing and
not in there Sequence

Where was i Wrong

Thanks in Advance
 
Ad

Advertisements

S

Sean Timmons

If you paste into a filtered table, it pastes to all adjacent rows, not
adjacent visible rows.

Much easier to just sort the table and paste into the blanks, since they'll
be in order that way.
 
Ad

Advertisements

H

Hardeep_kanwar

Thanks Sean

It works Perfectly my many friends facing this type of problem.

Hardeep kanwar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top