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