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
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
