VBA to copy based on heading not column

[helpexcel]

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

 

[kevatarvind]

yes its possible but where is your raw data store which has header contents ?

or can post some sample of your data ?

 

[nuked]

Range("4:4").Find(What:="Product").End(xlDown).Copy Sheets("Filtered").Range("A8")

...assuming your headers are in Row 4. If not, change 4:4 to 3:3 or something.

 

[helpexcel]

That worked, but it only copied 1 cell. How do i copy everything in the row?

 

[kevatarvind]

ADVERTISEMENT

thats why i asked you but you did not reply my questions ?

 

[helpexcel]

Sorry. The raw data is compiled on the "raw data" spreadsheet. Headings start A3 and continue to BK3. The data could be 10 rows or 1000 rows.
Does that answer it? Thanks!

 

[nuked]

That worked, but it only copied 1 cell. How do i copy everything in the row?

Do you mean everything in the column? Your question asked about copying specific columns based on their header. If you copy the entire row, then what is the point of isolating a particular column?

 

[helpexcel]

Sorry, meant everything in the column.