Transfer cell data from sheet to sheet?
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? |
Transfer cell data from sheet to sheet?
"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 --- |
Transfer cell data from sheet to sheet?
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? |
Transfer cell data from sheet to sheet?
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? |
All times are GMT +1. The time now is 04:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com