Hi Ajit,
Thanks Very much.
it was a great help.
U perfectly understood my problem.
it really worked.
hope to see u again.
Thanks
Rgds
Mayank
On Fri, Oct 10, 2008 at 9:49 PM, AJIT NAVRE <[EMAIL PROTECTED]> wrote:
> Looks nice. As I have understood it, you first paste the .CSV on the main
> tab at the bottom. And then you run the macro. The macro, vlooksup() the new
> rows in Main tab with the previous rows in the Main Tab to get the values
> for the 6 rightmost columns. Is it right?
> Further, you want to ensure that the macro runs only when you have actually
> pasted the .CSV at the bottom, else the macro should not proceed. Is it
> right?
>
> It can be accomplished by checking the row number of the last cell in
> column A, with the row number of the last cell in column I To N.(any one,
> prefer J To N).
>
> You can put the entire body of your macro within the following if,
> Assume Main Tab is the active Tab.
>
> If Range("A65536").End(xlup).Row <> Range("J65536").End(xlup).Row then
> ' Place your existing macro here
> EndIf
>
> Hope this was what you were looking for.
>
> Regards,
>
> Ajit
>
> On Fri, Oct 10, 2008 at 4:18 PM, Mayank Patel <[EMAIL PROTECTED]> wrote:
>
>> DEAR FRIEND
>> I AM ATTACHING MY DAILY SALES TRACKERS WHICH I USE TO UPDATE.
>> AND ALSO THE RAW DATEWISE REPORT FROM THE BILLING SOFTWARE FOR YOUR
>> REFERENCE.
>> DAILY SALES TRACKER ALSO CONTAINS THAT MACRO WHICH YOU SEE AND SUGGEST THE
>> SOLUTION.
>> THANKS
>>
>> RGDS
>>
>> MAYANK
>>
>>
>>
>> On Fri, Oct 10, 2008 at 6:39 AM, sarfaraz ahmed <[EMAIL PROTECTED]>wrote:
>>
>>> Hello,
>>>
>>> Does the report and Daily Sales Tracker reside in same excel file or DST
>>> refers the values from different Excel file.
>>>
>>> Regards,
>>> Sarfaraz Ahmed
>>> Excel Help <http://findsarfaraz.blogspot.com/>
>>>
>>>
>>>
>>> On Thu, Oct 9, 2008 at 10:49 AM, AJIT NAVRE <[EMAIL PROTECTED]>wrote:
>>>
>>>> Need to take a look at the macro. Also need to understand what you mean
>>>> by "if report is available", and see how well that can be checked thru the
>>>> macro. If possible, paste the macro here or attach the file.
>>>> Regards,
>>>>
>>>> Ajit.
>>>>
>>>> On Wed, Oct 8, 2008 at 7:30 PM, Mayank Patel <[EMAIL PROTECTED]>wrote:
>>>>
>>>>> Dear friends,
>>>>> I need ur help in macro
>>>>> I have created one macro in my Daily sales tracker file to update my
>>>>> report.
>>>>> I use to paste one report at the bottom of the file which has 6 columns
>>>>> and there are 6 more columns which require to be updated manually by using
>>>>> vlookups (column head are like Category, Sub Category, Category Groups,
>>>>> etc.)
>>>>> I have created the macro which only runs in cell next to the pasted
>>>>> report by using "selection"
>>>>> I have created a macro which i run after pasting that report and macro
>>>>> does the rest of thing like aplying vlookups and paste special values text
>>>>> to cloumn etc.
>>>>> if i run the macro without pasting the report it select all cell from
>>>>> the last empty cell to the bottom of the sheet and applys vlookups to all.
>>>>> I want that even if i try to run macro it should run only if report is
>>>>> available to update otherwise it should stop.
>>>>>
>>>>> Please revert if any more information required.
>>>>> Please Help as soon as possible.
>>>>>
>>>>>
>>>>> Rgds
>>>>> Mayank
>>>>> On Wed, Oct 8, 2008 at 1:19 PM, AJIT NAVRE <[EMAIL PROTECTED]>wrote:
>>>>>
>>>>>> Oh! I forgot the Workday() function. THanks for reminding....
>>>>>> Ajit
>>>>>>
>>>>>> On Tue, Oct 7, 2008 at 8:03 PM, Ajay Varshney <
>>>>>> [EMAIL PROTECTED]> wrote:
>>>>>>
>>>>>>> Check the formula from attached file.
>>>>>>>
>>>>>>> You should use Workday formula
>>>>>>>
>>>>>>> Regards,
>>>>>>> Ajay Varshney
>>>>>>>
>>>>>>> On Tue, Oct 7, 2008 at 12:45 AM, sanj <[EMAIL PROTECTED]> wrote:
>>>>>>>
>>>>>>>>
>>>>>>>> I have a date in a1; in a2 I want to add 2 working days.
>>>>>>>> As per example: 3rd Oct, 2008 + 2 working days = 7th October, 2008
>>>>>>>>
>>>>>>>> It will be a great help from u.....!!!
>>>>>>>>
>>>>>>>> Thanks
>>>>>>>>
>>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Thank You,
>>>>>>
>>>>>> Ajit Navre
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Regards
>>>>> Mayank Patel
>>>>> 9822978041
>>>>> 9422749110
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Thank You,
>>>>
>>>> Ajit Navre
>>>>
>>>>
>>>
>>>
>>> --
>>> Thanks with regards,
>>> Sarfaraz Ahmed
>>>
>>>
>>
>>
>> --
>> Regards
>> Mayank Patel
>> 9822978041
>> 9422749110
>>
>>
>>
>
>
> --
> Thank You,
>
> Ajit Navre
>
> >
>
--
Regards
Mayank Patel
9822978041
9422749110
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
