http://blogs.technet.com/b/heyscriptingguy/archive/2005/09/20/how-can-i-copy-column-c-of-one-worksheet-to-column-a-of-a-second-worksheet.aspxHey, Scripting Guy! How can I copy column C of one worksheet to column A of a second worksheet? -- JP Hey, JP. Well, that’s easy: you just open Excel, highlight column C, press Ctrl+C, put the cursor in column A1 of the second worksheet, and then pressen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.technet.com/b/heyscriptingguy/archive/2005/09/20/how-can-i-copy-column-c-of-one-worksheet-to-column-a-of-a-second-worksheet.aspx#3499230Tue, 22 May 2012 08:40:47 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3499230izzy-f<p>Hi i need to copy say columns A,B,C to spreadsheet x,y,z ,using sql.</p> <p>if i had a query that exucuted table1,column a of table one must be saved in sheet1 and column b on sheet t etc.but doing it manually is very depresing and time consuming.i need to do this in sql-query.thnx 4 your hlp in advance :)</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3499230" width="1" height="1">http://blogs.technet.com/b/heyscriptingguy/archive/2005/09/20/how-can-i-copy-column-c-of-one-worksheet-to-column-a-of-a-second-worksheet.aspx#3334940Tue, 01 Jun 2010 07:46:54 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3334940Vishal<p>Worked for me </p> <p>thanks</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3334940" width="1" height="1">