Fwd: $$Excel-Macros$$ Vlookup in master file through Macro

Dear all, any help possible on mentioned subject? Thanks Regards, Hemant -- Forwarded message -- From: Hems Date: Sun, Mar 13, 2011 at 12:35 AM Subject: $$Excel-Macros$$ Vlookup in master file through Macro To: excel-macros@googlegroups.com Dear All, I want to update the

Re: $$Excel-Macros$$ formula to add date in next column

End If > End If > End If >End If > End Sub > > > > On Sun, Mar 13, 2011 at 1:53 AM, Hems wrote: > >> Dear All, >> >> I want today's date in next column (column B) on the day when first >> column ( column A) was upd

$$Excel-Macros$$ Vlookup in master file through Macro

Dear All, I want to update the status in master file from various users. The user files are located in particular folder but the count and name of these user is not define. Hence all records in master file should search all the user file (in same folder and in same format) and update the status t

$$Excel-Macros$$ formula to add date in next column

Dear All, I want today's date in next column (column B) on the day when first column ( column A) was updated. for Ex. if A3 was updated on 14th Mar'11 then B3 should display that date. If i open this file on 16th Mar'11 then also B3 should display 14th Mar'11 and not 16th Mar'11. Appreciate i ge

Re: $$Excel-Macros$$ Creating directories

Thanks a lot Paul, Harmeet , Ayush and experts for help. I will let you soon if it works. regards Hems On Wed, Feb 23, 2011 at 7:28 PM, Paul Schreiner wrote: > See if you can follow this: > (file attached) > > Module1: > > Option Explicit > Sub Save_File() > Dim

$$Excel-Macros$$ Creating directories

Hello Experts Please find attached excel. I want to create directory, sub directory and file name as per excel columns and save the file as per the file name. Kindly let me if it is possible with the help of excel macros. Thanks in advance. Cheers... -- -

$$Excel-Macros$$ data in horizontal row

efforts and thanks in advance. -- Kind Regards, Hems -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http

Re: $$Excel-Macros$$ Help Required in Excel Roster

Norman, Dude its too gud Keep it up ... i wud lik learn all this ...how did u manage this?? Cheers! Hems On Thu, Dec 17, 2009 at 10:25 PM, Norman May wrote: > Hems, > > Attached is another version of your Roster. > > Norman > > On Tue, Dec 15, 2009 at 12:56 PM, He

Re: $$Excel-Macros$$ Help Required in Excel Roster

Hey Norman, Amazing work... yup this is what i wanted ...appreciate if cud explain the logic ..in short.. Thanks a lot bro Cheers! Hems On Thu, Dec 17, 2009 at 6:26 AM, Norman May wrote: > Hopefully this is what you wanted. > > Norman > On Tue, Dec 15, 2009 at 12:56 PM,

$$Excel-Macros$$ Help Required in Excel Roster

hanks in advance in for quick reply. -- Luv Hems ! ! ! " I don't have the LICENSE to kill ; But then again I can't change my looks." -- -- Some important links for excel users: 1. Excel and VBA

Re: $$Excel-Macros$$ Pls provide me code here.

Hey Ashish, Brilliant work. keep it up ... Thanks a lot Hems On Sat, Nov 28, 2009 at 1:16 AM, ashish koul wrote: > sorry forwarded you the wrong attachment earlier > > On Sat, Nov 28, 2009 at 12:16 AM, ashish koul wrote: > >> hi >> >> check the attachment

Re: $$Excel-Macros$$ Pls provide me code here.

Hi Ashish, thats a gr8 work. Can we retrieve the records from main database in another form by entering the name or staff no.? Thanks & Regards Hems On Fri, Nov 27, 2009 at 12:17 AM, ashish koul wrote: > HI > > check the attached file are u looking for something this >

$$Excel-Macros$$ Re: Help Needed !!!

Hey Harmeet, Thanks a lot bro, but can i have form1 loading after inputing the call id ? and 2nd part of my last mail i.e without any information also the call is getting logged. Kindly look at it. thanks Hems On Wed, Jun 24, 2009 at 1:44 AM, Harmeet Singh wrote: > > > On Tu

$$Excel-Macros$$ Help Needed !!!

. -- Hems ! ! ! --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2

$$Excel-Macros$$ Re: VBA Help (Follow up)

Hey Phillip, Nice to know that you are at least talking about it. I am very much surprised that nobody has ever given any suggestion about my problems. Hope sum one finds solutions soon Thanks Hems On Wed, Apr 15, 2009 at 12:00 AM, Phillip Swanepoel wrote: > Did anybody fix this workb

$$Excel-Macros$$ Re: VBA Help

Dear Ashish, i am very much surprised that nobody has solution for this... I really need this for my day-to-day work.Let me know if you have any input on this file. Thank you, Hems On Sat, Mar 28, 2009 at 11:41 PM, Ashish Jain <26may.1...@gmail.com> wrote: > > > -- Fo

$$Excel-Macros$$ Fwd: Pop-up on saving the shared excel

Hello All, guys pls help on this issue as its necessary for me . Thanks in advance . Hems -- Forwarded message -- From: Hems Date: Dec 8, 10:07 pm Subject: Pop-up on saving the shared excel To: MS EXCEL AND VBA MACROS Hi everyone, I have an excel which is shared

$$Excel-Macros$$ Pop-up on saving the shared excel

Hi everyone, I have an excel which is shared between 5-6 users and everybody updates and saves it. I want know is there any macro by which i'll get a pop-up message stating one of user has updated and saved the excel? Thank you in advance, -- Luv Hems ! ! ! " I don't have the