You are welcome Karthik!!
On Fri, Dec 25, 2009 at 10:24 AM, grlinks-karthik <grli...@gmail.com> wrote:
> Thank you praveen,
>
>
>
>
> On Thu, Dec 24, 2009 at 11:19 PM, kvc praveen kumar
> <pkkara...@gmail.com>wrote:
>
>> Hi Grlinks,
>>
>> Attach this macro for Report(2) sheet and run the macro3. You should be
>> able to see the desired result.
>> Make sure you open both the files before running the macro3.
>> Let me know in case you have any difficulties.
>>
>>
>> *Sub Macro3()
>> '
>> ' Macro3 Macro
>> '*
>> *'
>> Windows("report(2).xls").Activate
>> Rows("4:17").Select
>> 'Range("B4").Activate
>> Selection.Copy
>> Windows("paybill.xls").Activate
>> Range("A2:A3").Select
>> ActiveSheet.Paste
>> Range("A2:A3").Select
>> End Sub*
>>
>> Regards,
>> Praveen
>> On Thu, Dec 24, 2009 at 1:30 PM, grlinks-karthik <grli...@gmail.com>wrote:
>>
>>> Hi
>>>
>>> I have Two sheets Name called Report2, and paybill, Paybill sheet contain
>>> the format and data to be copied from Report2,
>>>
>>> when i click the button or macro Report2 sheet data to be copied and
>>> paste in the Paybill sheet as required format
>>>
>>> problem both the sheet not in same workbook , both are in diffirent
>>> sheets,
>>>
>>> I need code for that, these are sample sheets, based on your code i need
>>> to my modification , Please do the needful ASAP
>>>
>>> Regards
>>> grlinks
>>>
>>> On Wed, Dec 23, 2009 at 11:30 PM, kvc praveen kumar <
>>> pkkara...@gmail.com> wrote:
>>>
>>>> Hi Karthik,
>>>>
>>>> What is the data that you want to copy and into which shet you want to
>>>> copy.
>>>>
>>>> On Wed, Dec 23, 2009 at 12:07 PM, grlinks-karthik
>>>> <grli...@gmail.com>wrote:
>>>>
>>>>> Hi
>>>>> any can help me , I need to copy the data from report2.xls to
>>>>> paybill.xls sheet , How to do with VBA, Could any help , ITs very urgent
>>>>>
>>>>> --
>>>>>
>>>>> ----------------------------------------------------------------------------------
>>>>> Some important links for excel users:
>>>>> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>>>>> http://www.excelitems.com
>>>>> 2. Excel tutorials at http://www.excel-macros.blogspot.com
>>>>> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
>>>>> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>>
>>>>>
>>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>> If you find any spam message in the group, please send an email to:
>>>>> Ayush Jain @ jainayus...@gmail.com or
>>>>> Ashish Jain @ 26may.1...@gmail.com
>>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>>> HELP US GROW !!
>>>>>
>>>>> We reach over 6,500 subscribers worldwide and receive many nice notes
>>>>> about the learning and support from the group. Our goal is to have 10,000
>>>>> subscribers by the end of 2009. Let friends and co-workers know they can
>>>>> subscribe to group at
>>>>> http://groups.google.com/group/excel-macros/subscribe
>>>>
>>>>
>>>> --
>>>>
>>>> ----------------------------------------------------------------------------------
>>>> Some important links for excel users:
>>>> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>>>> http://www.excelitems.com
>>>> 2. Excel tutorials at http://www.excel-macros.blogspot.com
>>>> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
>>>> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>
>>>>
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>> If you find any spam message in the group, please send an email to:
>>>> Ayush Jain @ jainayus...@gmail.com or
>>>> Ashish Jain @ 26may.1...@gmail.com
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> HELP US GROW !!
>>>>
>>>> We reach over 6,500 subscribers worldwide and receive many nice notes
>>>> about the learning and support from the group. Our goal is to have 10,000
>>>> subscribers by the end of 2009. Let friends and co-workers know they can
>>>> subscribe to group at
>>>> http://groups.google.com/group/excel-macros/subscribe
>>>>
>>>
>>> --
>>>
>>> ----------------------------------------------------------------------------------
>>> Some important links for excel users:
>>> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>>> http://www.excelitems.com
>>> 2. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
>>> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>> If you find any spam message in the group, please send an email to:
>>> Ayush Jain @ jainayus...@gmail.com or
>>> Ashish Jain @ 26may.1...@gmail.com
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 6,500 subscribers worldwide and receive many nice notes
>>> about the learning and support from the group. Our goal is to have 10,000
>>> subscribers by the end of 2009. Let friends and co-workers know they can
>>> subscribe to group at
>>> http://groups.google.com/group/excel-macros/subscribe
>>>
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 2. Excel tutorials at http://www.excel-macros.blogspot.com
>> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
>> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain @ jainayus...@gmail.com or
>> Ashish Jain @ 26may.1...@gmail.com
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,500 subscribers worldwide and receive many nice notes
>> about the learning and support from the group. Our goal is to have 10,000
>> subscribers by the end of 2009. Let friends and co-workers know they can
>> subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. Let friends and co-workers know they can
> subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
