Re: [TenTec] 3D spreadsheet

[aluscre <aluscre@neo.rr.com>]

Ken

First, I have a newer version that I  uploaded just an hour ago with 
better instructions and one fix, so you may want to download it.

Pasting problem-

Excel will not let you paste data into a group of cells if you have 
copied the data by highlighting the entire columns or rows. I suspect 
that might be your problem.
There are a few ways to correct this:

1. A. First, in your exported data spreadsheet, make sure that you 
delete all data and columns other than: call, qso_date, mode, band, 
state, dxcc and userfields and have the             columns in that 
exact order. So you should only have data in columns A, B, C, D, E, F & G
   B. Delete the entire top row (the one with the column labels. )
   C. Then instead of highlighting by column or row, click you mouse 
anywhere in the middle of data, then press Ctrl-* to select all the 
cells and no extra rows or columns.
   D. You should then be able to click in cell J2 of my spreadsheet and 
paste should work.

or

2. A. First make sure that you delete all data and columns other than: 
call, qso_date, mode, band, state, dxcc and userfields and have the 
columns in that exact order.
       You should only have data in columns A, B, C, D, E, F & G
   B. Leave the column labels in first row of the of data (call, 
qso_date, mode, band, state, dxcc and userfields)
   C. Highlight the entire columns by highlighting the A, B, C, D, E, F 
& G at top of column
   D. Copy data and then go to my spreadsheet and highlight columns J 
through N.
   E. Excel should now allow you to paste in data

****** In either case it is very important that you do not have any 
extra columns that would paste over the mode conversion lookup table in 
columns Q & R *****

Let me know if this works or if you need additional assistance.

Anthony






Goetz wrote:
> I am attempting to use your spreadsheet with my Logic8 data and am 
> running into a problem. When I try to paste my copied data into the 
> spreadsheet (cell J2, step 19 on your instructions) I get an error 
> message stating “copy and paste areas not same size and shape….). I’m 
> sure this is something I’m messing up, but I’m stuck on this one.
>
>  
>
> Thanks,
>
> 73 and Happy New Year,
>
> Ken
>
>
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.516 / Virus Database: 269.17.13/1206 - Release Date: 
> 1/1/2008 12:09 PM


--
|--------------------------|
    Anthony A. Luscre    
           K8ZT      
       Stow, Ohio	  
|--------------------------|


_______________________________________________
TenTec mailing list
TenTec@contesting.com
http://lists.contesting.com/mailman/listinfo/tentec