Microsoft Office Forums copy cell from sheet 2 to sheet 3 macro

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-17-2010, 09:20 PM
slipperyjim slipperyjim is offline copy cell from sheet 2 to sheet 3 macro Windows XP copy cell from sheet 2 to sheet 3 macro Office 2007
Novice
copy cell from sheet 2 to sheet 3 macro
 
Join Date: Feb 2010
Posts: 2
slipperyjim is on a distinguished road
Default copy cell from sheet 2 to sheet 3 macro


hi all, new to macroing for word 07. i am trying to accomplish running a macro from a check box that copies the contents of cell 2 in column one of my table to column 1 cell 11 on page 3. i have found some code on the net, can anyone help me modify it to suit?

p.s. i need the code to step to the next free cell.

Code:
Sub TransferOfData()
'
' TransferOfData Macro
'
Dim NextCol As Integer
  NextCol = Sheets(2).Cells(1, Columns.Count).End(xlToLeft).Column + 1
   Sheets(2).Range("L19:L26").Copy
    With Sheets(3).Cells(11, NextCol)
     .PasteSpecial Paste:=xlPasteValues
    End With
End Sub
this looks suspiciously like excel code, again, totally new to word coding.

thanks for any help.
Reply With Quote
  #2  
Old 02-18-2010, 01:31 AM
slipperyjim slipperyjim is offline copy cell from sheet 2 to sheet 3 macro Windows XP copy cell from sheet 2 to sheet 3 macro Office 2007
Novice
copy cell from sheet 2 to sheet 3 macro
 
Join Date: Feb 2010
Posts: 2
slipperyjim is on a distinguished road
Default

any thoughts
Reply With Quote
Reply

Tags
new to macroing

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Template for Noting Sheet. Goldenbird Word 8 05-25-2009 05:48 AM
copy cell from sheet 2 to sheet 3 macro Compare data in different columns in an Excel sheet kgfendi Excel 5 05-16-2009 05:42 PM
Setting up Analysis Sheet when data does not exist, yet. burnoutdetective Excel 0 10-13-2008 05:57 AM
sheet linking, sorting nickbfe Excel 0 05-19-2006 11:00 AM
copy cell from sheet 2 to sheet 3 macro Enter Number on any sheet one time only. paulrm906 Excel 1 04-28-2006 07:35 AM


All times are GMT -7. The time now is 06:24 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft