Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default copy and paste special question


I have copied some data over using copy and paste special and trying to
find a easy way to continue on sheet i.e I have on sheet 1 cell a2
copied from sheet 2 cell a2 and sheet 1 cell b2 copied from sheet 2
cell e2. what im trying to do is to be able to copy the copy and paste
special formula on. Therefore sheet 1 a3 is from sheet 2 a3 and sheet 1
b3 is from sheet 2 cell e3. I want to be able to copy the columns down
so I dont have to copy and paste special every cell. Can anyone help?




--
tweacle
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,345
Default copy and paste special question

tweacle,

Assuming that there is no other data below the data that you want to copy
then try the Macro:

Sub CopyIt()

Dim LasteRow As Long
Dim LastaRow As Long

LastaRow = Sheets("Sheet2").Cells(Rows.Count, 1).End(xlUp).Row
LasteRow = Sheets("Sheet2").Cells(Rows.Count, 5).End(xlUp).Row

Application.ScreenUpdating = False
Sheets("Sheet2").Activate

Sheets("Sheet2").Range(Cells(2, 1), Cells(LastaRow, 1)).Copy
Sheets("Sheet1").Range("A2").PasteSpecial Paste:=xlValues,
Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False

Sheets("Sheet2").Range(Cells(2, 5), Cells(LasteRow, 5)).Copy
Sheets("Sheet1").Range("B2").PasteSpecial Paste:=xlValues,
Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False

Application.CutCopyMode = False

Sheets("Sheet1").Activate

Application.ScreenUpdating = True
End Sub

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"tweacle" wrote in message
...

I have copied some data over using copy and paste special and trying to
find a easy way to continue on sheet i.e I have on sheet 1 cell a2
copied from sheet 2 cell a2 and sheet 1 cell b2 copied from sheet 2
cell e2. what im trying to do is to be able to copy the copy and paste
special formula on. Therefore sheet 1 a3 is from sheet 2 a3 and sheet 1
b3 is from sheet 2 cell e3. I want to be able to copy the columns down
so I dont have to copy and paste special every cell. Can anyone help?




--
tweacle



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default copy and paste special question


Sandy Mann Wrote:
tweacle,

Assuming that there is no other data below the data that you want to
copy
then try the Macro:

Sub CopyIt()

Dim LasteRow As Long
Dim LastaRow As Long

LastaRow = Sheets("Sheet2").Cells(Rows.Count, 1).End(xlUp).Row
LasteRow = Sheets("Sheet2").Cells(Rows.Count, 5).End(xlUp).Row

Application.ScreenUpdating = False
Sheets("Sheet2").Activate

Sheets("Sheet2").Range(Cells(2, 1), Cells(LastaRow, 1)).Copy
Sheets("Sheet1").Range("A2").PasteSpecial Paste:=xlValues,
Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False

Sheets("Sheet2").Range(Cells(2, 5), Cells(LasteRow, 5)).Copy
Sheets("Sheet1").Range("B2").PasteSpecial Paste:=xlValues,
Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False

Application.CutCopyMode = False

Sheets("Sheet1").Activate

Application.ScreenUpdating = True
End Sub

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"tweacle"
wrote in message
...-

I have copied some data over using copy and paste special and trying
to
find a easy way to continue on sheet i.e I have on sheet 1 cell a2
copied from sheet 2 cell a2 and sheet 1 cell b2 copied from sheet 2
cell e2. what im trying to do is to be able to copy the copy and
paste
special formula on. Therefore sheet 1 a3 is from sheet 2 a3 and sheet
1
b3 is from sheet 2 cell e3. I want to be able to copy the columns
down
so I dont have to copy and paste special every cell. Can anyone help?




--
tweacle -








Brilliant Many Thanks




--
tweacle
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,345
Default copy and paste special question

You're Very welcome, I'm glad that you got it to work

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"tweacle" wrote in message
...

Sandy Mann Wrote:
tweacle,

Assuming that there is no other data below the data that you want to
copy
then try the Macro:

Sub CopyIt()

Dim LasteRow As Long
Dim LastaRow As Long

LastaRow = Sheets("Sheet2").Cells(Rows.Count, 1).End(xlUp).Row
LasteRow = Sheets("Sheet2").Cells(Rows.Count, 5).End(xlUp).Row

Application.ScreenUpdating = False
Sheets("Sheet2").Activate

Sheets("Sheet2").Range(Cells(2, 1), Cells(LastaRow, 1)).Copy
Sheets("Sheet1").Range("A2").PasteSpecial Paste:=xlValues,
Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False

Sheets("Sheet2").Range(Cells(2, 5), Cells(LasteRow, 5)).Copy
Sheets("Sheet1").Range("B2").PasteSpecial Paste:=xlValues,
Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False

Application.CutCopyMode = False

Sheets("Sheet1").Activate

Application.ScreenUpdating = True
End Sub

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"tweacle"
wrote in message
...-

I have copied some data over using copy and paste special and trying
to
find a easy way to continue on sheet i.e I have on sheet 1 cell a2
copied from sheet 2 cell a2 and sheet 1 cell b2 copied from sheet 2
cell e2. what im trying to do is to be able to copy the copy and
paste
special formula on. Therefore sheet 1 a3 is from sheet 2 a3 and sheet
1
b3 is from sheet 2 cell e3. I want to be able to copy the columns
down
so I dont have to copy and paste special every cell. Can anyone help?




--
tweacle -








Brilliant Many Thanks




--
tweacle



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't Copy and Paste or Paste Special between Excel Workbooks wllee Excel Discussion (Misc queries) 5 April 29th 23 03:43 AM
Copy - Paste Special problem Bob Smith Excel Worksheet Functions 2 December 9th 06 12:53 AM
Paste Special Question Dan Excel Discussion (Misc queries) 2 April 24th 06 08:54 PM
Copy and paste special - values into new excel file [email protected] Excel Discussion (Misc queries) 1 October 12th 05 11:02 PM
Copy Paste Special Macro Bud Hughes Excel Discussion (Misc queries) 2 August 31st 05 02:00 AM


All times are GMT +1. The time now is 08:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"