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

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

You can use inputbox to copy a range or a header, clear your quesiton by putting data in output sheet2.so that we can understand what need to be copy. On Thursday, April 30, 2015 at 2:09:48 PM UTC+5:30, hilary lomotey wrote: > > Hello Bosses, > > i have this code am using to copy Dates fro

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

Hello Bosses, i have this code am using to copy Dates from column of sheet1 and transpose paste it in sheet2. the issue is to dynamically find the column header to copy the data to eg copy from E1 to J1, assuming i enter data in column K1 i need an assistance with code to dynaically coopy from EI