Difference between revisions of "Excel Copy/Paste Special to Software"
From The RadioReference Wiki
(Added conventional operations) |
m (corrected spelling) |
||
Line 14: | Line 14: | ||
* 9. Select All (highlight all), right click and select copy. | * 9. Select All (highlight all), right click and select copy. | ||
* 10. In open Trunk ID list, right click in the scan list location you wish to store this group and select paste. | * 10. In open Trunk ID list, right click in the scan list location you wish to store this group and select paste. | ||
− | ** This completes this bank for trunking. The bank tags | + | ** This completes this bank for trunking. The bank tags and scanlist tags will need to be set within the software sections for that purpose. |
* Collecting data from database pages for conventional freqs and tags. | * Collecting data from database pages for conventional freqs and tags. | ||
* 1. Highlight and copy group of listings. | * 1. Highlight and copy group of listings. |
Revision as of 21:20, 10 October 2007
- Using Microsoft Excel Paste Special feature for building data to paste into Windows based Scanner Software
- Note: Open Office and other spread sheets may also have this type of operation.
- This first section is for setting up ARC250D software - other ARC programs may work similar.
- 1. Highlight and copy freqs from database page, then click ARC Auto Data Import (ADI)Icon.
- 2. Click Import from Clipboard which will populate left window.
- 3. Click All which sends freqs to right window.
- Note: One can edit out all but Controls for Motorola 800/900 systems at this point.
- 4. Click Export to Table to send frequency list to open software bank frequency list.
- 5. Type in the data on line 1 of selected bank then click in Tag and drag across and down through last freq line then right click and select Fill Down.
- Bank trunking frequency settings are complete and the following steps are for talkgroup ID's and tags.
- 6. Select and highlight a section of Talkgroups from same data page, right click and select Copy.
- 7. Right click in cell A1 and select Paste Special. In new popup dialog, select Text.
- 8. Delete unneeded columns in the spreadsheet
- 9. Select All (highlight all), right click and select copy.
- 10. In open Trunk ID list, right click in the scan list location you wish to store this group and select paste.
- This completes this bank for trunking. The bank tags and scanlist tags will need to be set within the software sections for that purpose.
- Collecting data from database pages for conventional freqs and tags.
- 1. Highlight and copy group of listings.
- 2. Right click in cell of Excel then select Paste Special then Text in popup dialog.
- 3. Delete unneeded columns, format numbered columns and restructure Alpha tag column.
- 4. Copy columns A and B and paste into software. Copy Column C and paste into PL columns in software.