How do I transfer cell data from one sheet to the next. The cell data
contains a SUM expression if that will make it more challenging?

"Jeremy" wrote:
How do I transfer cell data from one sheet to the next. The cell data
contains a SUM expression if that will make it more challenging?

On the face of it ..
Think you could use a simple link formula,
something like this in say, Sheet2's A1:
=IF(Sheet1!A1="","",Sheet1!A1)
Copy A1 across/fill down as desired to cover the link area
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Sub tester()
Range("B1:B4").Cut Destination:=Sheets("Sheet2").Range("A1")
End Sub

is one way

"Jeremy" wrote:

How do I transfer cell data from one sheet to the next. The cell data
contains a SUM expression if that will make it more challenging?

Hi Jeremy,

Try this, say for eg. in sheet 2 you some data in Column. A and it is added
in row no A4. Now if you want the data in cell A4 to be transfered to Sheet
3! A1 the simplest thing is =Sheet2!A4. This can take any expression.
Excel 2003.

--
Thanks
Suleman Peerzade


"Jim May" wrote:

Sub tester()
Range("B1:B4").Cut Destination:=Sheets("Sheet2").Range("A1")
End Sub

is one way

"Jeremy" wrote:

How do I transfer cell data from one sheet to the next. The cell data
contains a SUM expression if that will make it more challenging?