Hi Refresh...

Actually I need to put the data from the 14 into the sheet with the 50. I
did a VLOOKUP on the 50 to find all the same order numbers that are on the 14
and filtered so that now only the 14 show. I want to copy the data from the
sheet with 14 into the sheet with 50 that now only shows the same 14 orders.

When I filtered the sheet with 50 down to showing just the same 14 orders I
see rows 3, 4, 8, 14, 22, 23, 25, etc... So when I copy the data from the
sheet with just the 14 I want to paste it into these rows, but Excel 2003
will only paste into rows 3, 4, 8, and 14....and its not the correct data. I
think Excel is pasting into 1-14 but I cannot see 1, 2, 5, 6, 7, 9, (you get
the jist) So how can I get Excel to paste into just the rows I filtered.

Thanks for helping :)


"refresh" wrote:

Hiya, not sure I've got my head right round this so apologies if I'm not
making sense. From what I can gather you want the 14 rather than the 50. So
maybe if there is a correlated field it would be easier to use your lookup in
the sheet with the 14 and pull through the data you need from the 50. That
should avoid any filter problems.

Hope this helps but if not let me know.

Refresh.

"krakatoakt" wrote:

After reading some post I think I can sum up that Im trying to paste arows
from a non-filtered set of data into a filtered sheet showing the same rows.
I see that up to row 14 on the filtered sheet takes the data, but those are
not the rows I want the data to fall into. How can I get it to go into the
highlighted rows I have filtered?



"krakatoakt" wrote:

I have 2 sheets. Sheet 1 has 50 rows of data and Sheet 2 has 14 rows of data.
I did a VLOOKUP on sheet 1 to find the matching rows on sheet 2. I filtered
the VLOOKUP with Customer does not equal#NA. Now Sheet 1 shows the same 14
rows.

On Sheet 2 I copied all 14 rows of data from Column B
I went to sheet 1 and tried to paste the data into Column B (the 14 rows
showing) but it only pasted into a few rows. I'm guessing the hidden rows
received the other data. I tried to use the paste special and the F5 special
paste visable cells only without good results. Im using Excel 2003.

** Also Excel keeps telling me that the copy area and the paste area are not
the same size even though I'm copying 14 cells and highlighting 14 cells I
need to paste into. **

I really do not want to copy each cell and paste it to the other sheets cell
as I actually have hundreds of these to do. Also I'm not that savy on code so
if you have any suggestions I would need to know exact steps needed to fix
it. Any thoughts?

I really appreciate your time in helping me as this is something I use ALL
the time and until now I have been using the "old fashion" method.