I am using the following to copy colums of data from one sheet to another. Can I change the language so that it copies based on the headings in each row? So copy column with heading "Product" instead of "A4". This way if there is another spreadsheet that is sorted slightly different, the same data will get pulled, because it is looking for the heading and not just copying the column. Thanks.
Sheets("Raw Data").Select
Range(Range("A4"), Range("A4").End(xlDown)).Select
Selection.Copy
Sheets("Filtered").Select
Range("A8").Select
ActiveSheet.Paste
Sheets("Raw Data").Select
Range(Range("A4"), Range("A4").End(xlDown)).Select
Selection.Copy
Sheets("Filtered").Select
Range("A8").Select
ActiveSheet.Paste