Macro to find a header based on a value in another cell

p45cal · #1 07-01-2019, 03:31 AM

Code:

Sub blah()
Columns(Application.Match(Range("V1").Value2, Rows(2), 0)).Copy Columns("AG")
End Sub

Tphil413 · #2 07-23-2019, 09:59 AM

Worked perfectly, thanks!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to select cell based on formula	mreynolds1775	Excel Programming	4	09-22-2017 12:13 PM
Macro- find and replace from preselected options based on frequency (like an Ad libs)	blondie	Word VBA	0	02-27-2017 01:41 PM
Can anyone here tweek this macro for renaming Excel files based on a cell's contents?	chrisd2000	Excel Programming	6	07-01-2014 01:53 PM
Word VBA Macro to Find and Replace based on the Alt Text of an Image	bennymc	Word VBA	1	01-27-2014 04:23 PM
Macro based on cell value	ubns	Excel Programming	1	05-07-2012 04:03 AM