I have some simple code that copies data from sheet 'Auto', pastes in cell C2 and then auto-fills to C20000:
The issue with this is that the columns with data in sheet 'Auto' are not always in the same place. Am I able to use your code to first find a specific column heading in sheet 'Auto' (headings are always in row 2), which in this case is "Amount" and then use my code below to copy, paste and auto-fill the data below that specified heading?
There are only around 100 headings in sheet 'Auto' and I will need to do this process for around 15 different columns.
Thank you.
Code:
Range("C2").Select
ActiveCell.FormulaR1C1 = "=Auto!R[1]C[32]"
Range("C2").Select
Selection.AutoFill Destination:=Range("C2:C20000")
The issue with this is that the columns with data in sheet 'Auto' are not always in the same place. Am I able to use your code to first find a specific column heading in sheet 'Auto' (headings are always in row 2), which in this case is "Amount" and then use my code below to copy, paste and auto-fill the data below that specified heading?
There are only around 100 headings in sheet 'Auto' and I will need to do this process for around 15 different columns.
Thank you.
Last edited by a moderator: