VBA find function to copy data under a heading

**bkav1991** · 10-17-2020, 12:23 PM

Hey All!

I am trying to figure out a way to copy the data under a heading and to paste it to another tab. Maybe the VBA find function?

In this case the heading is "origin". The column this information is in will change every time but the heading will stay the same.

Hoping someone can help with this!

Thanks!

**nankw83** · 10-17-2020, 12:31 PM

Hi bkav1991,

Try below code ...

Sub test()

Dim Rg As Range

With Sheets("Information")
   Set Rg = .Rows(1).Find("Origin")
   If Not Rg Is Nothing Then Range(.Cells(2, Rg.Column), .Cells(Rows.Count, Rg.Column).End(3)).Copy Sheets("Paste").Cells(1)
End With

End Sub

VBA find function to copy data under a heading

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

VBA find function to copy data under a heading

Re: VBA find function to copy data under a heading

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] copy table from website -heading ok but data misses col A

[SOLVED] Search Heading and copy first cell under heading

Data Validation List that matches Field Heading of Target Cell with Source Heading

[SOLVED] As Per Heading copy data from Input to Output Workbook

Custom function to find Heading & Subheading

[SOLVED] Macro to copy data under appropriate heading

macro to find text heading then select underlying data?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions