If in Office before 2007, this should work:1. Using goto, select the column you want to copy. If it's column d, rows 2 through 50, the command would be
goto (control-g or f5) d2:d50. 2. copy with control-c.3. Use goto to select where to place the data. If in column g, rows 10 through 60, the command would be
goto (control-g or f5) g10:g60. 4. Control-v to paste.If you need the data in the new fields to reflect changes in the original, though, you will want links to it instead of copies. that's a horse of a different color.
Good luck! -- JFW related links: JFW homepage: http://www.freedomscientific.com/ Scripting mailing list: http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com JFW List instructions: To post a message to the list, send it to jfw@xxxxxxxxxxxxx To unsubscribe from this mailing list, send a message to jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line. Archives located at: //www.freelists.org/archives/jfw Alternative archives located at: http://n2.nabble.com/JAWS-for-Windows-f2145279.html If you have any concerns about the list, post received from the list, or the way the list is being run, do not post them to the list. Rather contact the list owner at jfw-admins@xxxxxxxxxxxxxx