zip.survey
Board Regular
- Joined
- Sep 8, 2006
- Messages
- 55
I have about 8000 individual rows, which I have autofiltered down to about 200 rows, using a variety of filters.
I then copied these 200 rows to a new work book as a flat file, and sent it off to someone to add data to.
I then received the 200 rows of data filled in back, and tried to paste it back into my original 8000 row document, of which I had it autofiltered down to the 200 rows.
But when I paste the rows, it does not paste it in the 200 rows I want, because the auto-filter automatically hides rows, so its not pasting the data in the 200 rows that I want.
How do I do this?
I then copied these 200 rows to a new work book as a flat file, and sent it off to someone to add data to.
I then received the 200 rows of data filled in back, and tried to paste it back into my original 8000 row document, of which I had it autofiltered down to the 200 rows.
But when I paste the rows, it does not paste it in the 200 rows I want, because the auto-filter automatically hides rows, so its not pasting the data in the 200 rows that I want.
How do I do this?