K
krakatoakt
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.
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.