Re: $$Excel-Macros$$ Copy Dynamically From Column and Pate

Great Paul, this helped a lot. Ashish, your solution in VBA lab also helped. thanks Guys am very grateful On Thu, Apr 30, 2015 at 11:26 AM, Ganesh N wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (ganeshg...@gmail.com) Add cleanup rul

Re: $$Excel-Macros$$ Copy Dynamically From Column and Pate

Hi Hilary, Please find the attachment. Macro1: will copy the data from E1 to the end date which you have. Macro2: will ask you the start column name. just enter "e" or which column you want. Thanks & Regards, Ganesh N On Thu, Apr 30, 2015 at 4:44 PM, Paul Schreiner wrote: > Hilary, > > You'v

Re: $$Excel-Macros$$ Copy Dynamically From Column and Pate

Hilary, You've captured the last column in the header in variable "x". So, your question is how to modify:  Sheet1.Range("e1:h1").Copy to make use of this variable column. One option (of MANY) would be to make use of a variation of the Range() object. Technically, the elements of the Range() obj