PDA

View Full Version : copy cells from one sheet to another



Ed126
07-17-2012, 12:45 PM
I have two spreadsheets, one has name, company address, address2, city state zip the other has name, company address, address2, city state zip company address, address2, city state zip company address, address2, city state zip . I have added two rows in the first spread sheet, then I am copying and pasting the the two additional address lines into those two rows. I have tried recording the macro but it stops at my last action and does not finish. I need for to run until it encounters a blank cell.




ActiveWindow.SmallScroll Down:=6
Windows("Book2").Activate
ActiveWindow.SmallScroll Down:=24
Windows("Centene%20Requested%20Provider%20List%20w-Allied_7 12 12(1) (2).xlsx") _
.Activate
Selection.Copy
Windows("Book2").Activate
ActiveSheet.Paste
Windows("Centene%20Requested%20Provider%20List%20w-Allied_7 12 12(1) (2).xlsx") _
.Activate
Range("S88").Select
Application.CutCopyMode = False
Selection.Copy
Windows("Book2").Activate
Range("AP32").Select
ActiveSheet.Paste
Windows("Centene%20Requested%20Provider%20List%20w-Allied_7 12 12(1) (2).xlsx") _
.Activate
Range("T88").Select
Application.CutCopyMode = False
Selection.Copy
Windows("Book2").Activate
Range("AQ32").Select
ActiveSheet.Paste
Windows("Centene%20Requested%20Provider%20List%20w-Allied_7 12 12(1) (2).xlsx") _
.Activate
Range("U88").Select
Application.CutCopyMode = False
Selection.Copy
Windows("Book2").Activate
Range("AR32").Select
ActiveSheet.Paste
Windows("Centene%20Requested%20Provider%20List%20w-Allied_7 12 12(1) (2).xlsx") _
.Activate
Range("V88").Select
Application.CutCopyMode = False
Selection.Copy
Windows("Book2").Activate
Range("AS32").Select
ActiveSheet.Paste
Windows("Centene%20Requested%20Prov

fredlo2010
07-17-2012, 09:19 PM
Can you attache a sample of the workbook?

Ed126
07-18-2012, 10:28 PM
Here is a sample file. I cannot give out live data. I would like to be able to tweak it, because the fields can change

Ed126
07-18-2012, 10:45 PM
the other

desneyjof
07-18-2012, 11:41 PM
Can you attache a sample of the workbook?

Yeah! Feedback is the best way to learn and improve our skills but feedback always come from valid person.