coping data without coping formulars

hi,

i am copying data from an unknown range as there are Formulas that could give me more or less data to another workbook.

i need the marco to start at the first cell end select only data cells

i need to be able to copy only the cells with data in and not the ones with Formulas as well

thanks steve

Originally Posted by stevekirk

hi,

i am copying data from an unknown range as there are Formulas that could give me more or less data to another workbook.

i need the marco to start at the first cell end select only data cells

i need to be able to copy only the cells with data in and not the ones with Formulas as well

thanks steve

Hi stevekirk,

Try this first, select all the sheet by clicking on the little square adjacent to col A & row 1, then

Copy, move to new sheet select A1

Paste special > values only

oldchippy

hi,


i need to do it through a macro. When you do it through the macro record route the macro does not record all the steps

steve

Originally Posted by stevekirk

hi,


i need to do it through a macro. When you do it through the macro record route the macro does not record all the steps

steve

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 07/09/2006 by oldchippy
'

'
Cells.Select
Selection.Copy
Sheets("Sheet2").Select
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub

This is what I just recorded and it worked, you need to be on sheet1 to run it

oldchippy

hi,

i tried that and it did not work

i need to copy it to another workbook not worksheet.

please see attached file

i only want to copy the data from the last cell in column a across all columns

hope this makes sense

steve

Originally Posted by stevekirk

hi,

i tried that and it did not work

i need to copy it to another workbook not worksheet.

please see attached file

i only want to copy the data from the last cell in column a across all columns

hope this makes sense

steve

Hi steve,

Just to clarify things a bit, are you saying you want to copy the last cell containing data from the columns of sheet1 i.e A8, C12, E13 (or what ever the last cell containing data is) to another workbook

hi,

nearly,

as the last cell in A IS a8 i want to copy from a8 to say t8 to another workbook

remember the data in column A could goto A20 or A3 the next time i run it

HOPE THIS HELPS
steve