| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I transfer a required data from sheet 1 to sheet 2 automat | Excel Discussion (Misc queries) | |||
| how to transfer data from sheet to sheet with new range? | Excel Discussion (Misc queries) | |||
| How to Automatically transfer specific Data from Sheet 1 to Sheet | Excel Worksheet Functions | |||
| How do i transfer cell data from one sheet to the other in Excel | New Users to Excel | |||
| Transfer data from sheet to sheet | Excel Discussion (Misc queries) | |||
![Suleman Peerzade[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
