98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - Copying data - please help asap
microsoft excel training - Copying data - please help asap
Resolved · Low Priority · Version Standard
Natascha has attended:
Excel Intermediate course
PowerPoint Intermediate Advanced course
Copying data - please help asap
I am trying to copy data from one spreadsheet to another however the area it needs to be posted to has filters on it and therefore I cannot paste into the fields
RE: Copying data - please help asap
Can you remove the filters? (DATA> FILTER > AUTOFILTER)
Then paste the data, and reset the filter
Regards
Richard
RE: Copying data - please help asap
NOt really I am copying into a spreadsheet that has over 1600 entires and I am getting the data back by company with about 20 lines of data - however thinking now I may be able to sort by company rather than filter?
RE: Copying data - please help asap
Sorting may be the way.
If you do remove the filter, as suggested, simply paste the data at the end of the list, and then refilter
Let me know how you do.
Regards
Richard
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Moving or Copying Sheets Between Workbooks in Excel 2010Here's how to move or copy sheets between workbooks in Excel 2010: |