i want a procedure which performs the following tasks in VBA: (im using Excel 2003 and the Excel is not using R1C1 cell referencing)
- insert a new column into a worksheet
- gives the column header a title
- populates this new column with data from another worksheet stored witin the same workbook
(I can do this using a vlookup function within the worksheet but I want a VBA code way of doing this) - i would ideally like a method which does this which runs as quick as possible as i have been told that using a vlookup within code might not be as efficient as other methods.