Need some help please!!!
I am writing a macro whereby I need a cell to be copied down a column. However I can not specify the amount of rows it needs to be copied to as this will change everytime the macro is run.
In the next column is the start of a database, where records are constantly added or deleted from and I need the "problem" cell to be copied to all records, this will be the first column of the database.
Code Company
12345 AAA
bbb
ccc
ddd
eee
Example: Need 12345 to be copied to all cells in Code column. The amound of cells copied depends on the amount of cells in Company column.
Hope this makes sense. ANy help would be really appreciated.
Thanks
PS I am presently recording the macro as am not brilliant at code but any help would be appreciated
I am writing a macro whereby I need a cell to be copied down a column. However I can not specify the amount of rows it needs to be copied to as this will change everytime the macro is run.
In the next column is the start of a database, where records are constantly added or deleted from and I need the "problem" cell to be copied to all records, this will be the first column of the database.
Code Company
12345 AAA
bbb
ccc
ddd
eee
Example: Need 12345 to be copied to all cells in Code column. The amound of cells copied depends on the amount of cells in Company column.
Hope this makes sense. ANy help would be really appreciated.
Thanks
PS I am presently recording the macro as am not brilliant at code but any help would be appreciated