No Problem Karthik!!
On Fri, Dec 25, 2009 at 3:35 PM, grlinks-karthik <grli...@gmail.com> wrote:
> Thank you praveen
>
> its working fine, you done greate help for me , thanks once again
>
> On Fri, Dec 25, 2009 at 11:02 AM, kvc praveen kumar <pkkara...@gmail.com
> > wrote:
>
>> I made a small change to the code to get the last row. You can check this
>> now:
>>
>> *Sub Macro3()
>> '
>> ' Macro3 Macro
>> '*
>> *'
>> *
>> *Windows("report(2).xls").Activate
>> *
>> *Last_row = Range("A" & Rows.Count).End(xlUp).Row*
>> * Rows("4:" & last_row).Select
>>
>> 'Range("B4").Activate
>> Selection.Copy
>> Windows("paybill.xls").Activate
>> Range("A2:A3").Select
>> ActiveSheet.Paste
>> Range("A2:A3").Select
>> End Sub
>> *
>>
>> Can you debug once and let me know at which line you are getting the
>> error.
>> It is working fine for me.
>> Make sure you open both the workbooks before running the macro.
>>
>> Regards,
>> Praveen
>>
>>
>> On Fri, Dec 25, 2009 at 10:34 AM, grlinks-karthik <grli...@gmail.com>wrote:
>>
>>> Dear Praveen
>>>
>>>
>>> I am getting runtime error "1004", (applicatinon difined or object
>>> defined error), and also you specified row no in the macro, but i donot know
>>> how many rows will be in report(2) sheet, sample purpose i have mention
>>> 15rows, actuallay it will be 50 or 100 rows
>>>
>>> kindly help me
>>> 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
>>
>
> --
>
> ----------------------------------------------------------------------------------
> 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
