Hi all,
I am new to macros and would hope that somebody could assist.
I have an exported csv file from a database that i need to reformat and would like to create a macro to aid this.
The part of the task that i am struggling with is the following:
(This example has only 20 rows of data)
I insert a new column between A and B
I insert a formula into B1 (="Item No: "&a1)
I copy this down to B20
I then copy B1:B20 and use paste special>values into A1:A20
I then delete Column B
If i record a macro, it obviously only works up to row 20, but the spreadsheet "grows" each time i need to do this and i would like the macro to automatically perform the action for all the populated rows present in column A.
I have had a look at the VBA code and can see each time it refers to the cell range(s). I just don't know what i need to insert in place of these absolute references.
Ta in advance.
Social Networking Bookmarks