Very Frusterated with Auto-Filter Problem

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?
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

MMIIKKEE

New Member
Joined
Sep 16, 2006
Messages
13
Hi....

If your co-workers are just adding to the 200 rows how about using the vlookup function....

In your original worksheet add a new column and use this as an index 1,2,3... etc then when you get the data back from your co-workers you can use vlookup to add the new data to your worksheet... after you've used vlookup then you just "copy" and "paste values"...

If you want me to do it/help more email me your excel files / skype number.... mikefardell@hotmail.com

Hope it helps!
 

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,453
Hello zip,
What comes to mind off hand is to paste the 200 rows you receive back into a different sheet of the original workbook and then loop through the original (8000 row) sheet looking for specified columns that match the 200 row sheet and then copy/paste each matching row back into the original sheet.

After you've filtered the data (before sending it out to be filled in by the other user/s) what columns have data and are any of those rows exact duplicates?
If so, how would you (manually) determine which of the newly filled in rows should go where in the original sheet?
 

Watch MrExcel Video

Forum statistics

Threads
1,113,811
Messages
5,544,448
Members
410,611
Latest member
JB_101920
Top