Re: $$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values

2014-04-05 Thread prkhan56
Thanks Vicky. Works like a charm On Saturday, April 5, 2014 3:45:49 AM UTC+4, Vicky wrote: Rashid Sir, I have made some changes. Now you can change your input column to any column in the sheet and output will be 3 column forward and 1 row down from the input data.. If you require data in

Re: $$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values

2014-04-04 Thread Bipin Singh
Rashid Sir, I have made some changes. Now you can change your input column to any column in the sheet and output will be 3 column forward and 1 row down from the input data.. If you require data in different column other then this then change offset value as per your requirement inside the loop.

Re: $$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values

2014-04-03 Thread prkhan56
Hello Vicky, Your solution works as per the current set of Data. (Col G H for input) (Col L M for output) I was looking for a solution which should work for any two adjacent columns. Is that possible? I will run the macro from say Values in Col A then it should work for Cols A and B...if Col

Re: $$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values

2014-04-03 Thread prkhan56
Thanks Ravinder. But your solution does not meet my requirements. On Thursday, April 3, 2014 9:32:22 AM UTC+4, ravinder negi wrote: pfa *From:* excel-...@googlegroups.com javascript: [mailto: excel-...@googlegroups.com javascript:] *On Behalf Of *Bipin Singh *Sent:* Thursday, April 03,

Re: $$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values

2014-04-02 Thread Bipin Singh
Rashid Sir, Hope attached will help? On Wed, Apr 2, 2014 at 4:39 PM, Rashid Khan prkha...@gmail.com wrote: Dear All, I am using Excel 2010. I have attached a sample file with my problem. Please see before and after Any macro help would be appreciate. Regards Rashid -- Are you

RE: $$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values

2014-04-02 Thread Ravinder
pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Bipin Singh Sent: Thursday, April 03, 2014 1:33 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values Rashid Sir, Hope