Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
compile list in 1st empty cell
I need a macro to find the first empty cell in column a of sheet 2 and
transfer the information of a cell in sheet 1. This value will change but I would like to compile a growing list as the cell in sheet 1 changes. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
compile list in 1st empty cell
Steve, see if this will work for you,
Sub test() Sheet2.Range("A65536").End(xlUp).Offset(1, 0) = Sheet1.Range("A1").Value End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Steve" wrote in message ... I need a macro to find the first empty cell in column a of sheet 2 and transfer the information of a cell in sheet 1. This value will change but I would like to compile a growing list as the cell in sheet 1 changes. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert date | Excel Worksheet Functions | |||
why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
How to create a List inside a cell? | Excel Discussion (Misc queries) | |||
Ooh .. Linking a list to a list to an output cell | Excel Discussion (Misc queries) | |||
Function making cell really "empty" | Excel Worksheet Functions |