Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtered Data
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtered Data
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. "Hardeep_kanwar" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtered Data
Thanks Sean
It works Perfectly my many friends facing this type of problem. Hardeep kanwar "Sean Timmons" wrote: 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. "Hardeep_kanwar" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS2007 - deleting filtered data, deletes non-visible data too | Excel Discussion (Misc queries) | |||
Sum of filtered data | Excel Worksheet Functions | |||
Filter data and fill only filtered data | Excel Discussion (Misc queries) | |||
Sum of filtered data | Excel Worksheet Functions | |||
Help to sort out filtered data from the data contained in another sheet of the same workbook | Excel Worksheet Functions |