Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy/paste with filters from one sheet to another?
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Paste to another sheet | Excel Worksheet Functions | |||
How to copy with filters but not copy the filters in the middle? | Excel Discussion (Misc queries) | |||
Copy and paste in a sheet with groupings | Excel Discussion (Misc queries) | |||
Active Cell Copy And Paste Sheet to Sheet | New Users to Excel | |||
Copy paste to another sheet | Excel Discussion (Misc queries) |