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