Re: Excel Question?

  • From: Ann Byrne <annakb@xxxxxxxxxxxxx>
  • To: jfw@xxxxxxxxxxxxx
  • Date: Wed, 03 Mar 2010 21:42:14 -0600

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

Other related posts: