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