| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
GETTING DATA ON TO SHEET2
I am trying to get data in sheet1 a1 (10) into sheet 2 d1 and it wont run -
can you tell me where I am going wrong please? Sub ad() If Range("sheet1!a1") < 0 Then Range("sheet2!d1").Select Range("sheet2!d1") = Range("sheet1!a1") End If End Sub -- TIM LEE tax agent 55 807 001 4a 123 Colin St West Perth 6005 Tel 08/9481 0337 Fax 9321 0036 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
| macro to print sheet2 without open sheet2 | Excel Discussion (Misc queries) | |||
| auto transfer data in sheet2 (selected data) | Excel Worksheet Functions | |||
| copying data from sheet1 to sheet2 | Excel Worksheet Functions | |||
| enter data in cell which will start macro to move data to sheet2 | Excel Discussion (Misc queries) | |||
Threaded Mode
