Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - Copying data - please help asap
|
|
|
The UK's most regular 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. |
microsoft excel training - Copying data - please help asap
Resolved · Low Priority · Version Standard
Reply Fri 21 Sep 2007, 12:12Delegate Natascha said...
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
For upcoming training course dates see: Pricing & availability
RE: Copying data - please help asap
Can you remove the filters? (DATA> FILTER > AUTOFILTER)
Then paste the data, and reset the filter
Regards
Richard
Reply Fri 21 Sep 2007, 15:37Delegate Natascha said...
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
|