Re: $$Excel-Macros$$ Re: Outlook Problem

i have been in huge trouble using delay delivery in MS outlook 2003. it did not work when i set it beyond 1 week by a specific date and time. it worked if i set it on the same day. dont know what went wrong with longer time frame. On Thu, Jul 15, 2010 at 9:38 AM, Rajender Soni wrote: > Hi > > The

Re: $$Excel-Macros$$ Google Translator Using VBA - HELP !!!

Hi is that any formula when we do sum formula but some time in our data #N/A in list that's WY we not able to see sum total. pls find the below mention example.if anybody know pls tell me formula. *Total* 20 25 #N/A 20 51 10 *#N/A=sum() * On Tue, Jul 13, 2010 at 11:48 PM, Harmeet Singh wrote:

$$Excel-Macros$$ How to create a similar resume in MS Excel ???

Hello All, I came across this interesting resume which has been prepared as a graph and charts sheet / dashboard. Although some may question its relevance / consistency in color usage / display of information , it is doing what it means to do... It captures attention and would surely give the cand

Re: $$Excel-Macros$$ Interview questions

Hi Harmeet Aapke attached links padh kar maza aa gaya, its a great value add. Regards Rajender Soni On Jul 10, 11:07 pm, Vinod N wrote: > I agree with Saggi... The questions will be around Data Analysis, > manipulation, dashboards/scorecard etc. > > > > > > On Sat, Jul 10, 2010 at 11:03 AM, sag

$$Excel-Macros$$ Re: Dynamic Ranges with Vlookup

Hi Alvin You can't close a link like that of below, please send the solution to group, so that all members can have a look, this is only for knowledge sharing. Regards Rajender Soni On Jul 10, 7:25 am, fongie wrote: > Hi Ramesh, > > I have just sent an email with an example of how this can be d

RE: $$Excel-Macros$$ Outlook Problem

Yes. You can schedule the time of Message. First go to message option and then select the delivery option. Enter the date and time after which you want the message to be sent and save. The message will be sent after that time and provided your outlook is connected. Regards, C.G.Kumar

Re: $$Excel-Macros$$ Finding a cell based on multiple criteria typed into cells

Hi Please find attached the sheet, let us know if something else is required. Regards, Rajender Soni | +91 750 322 55 50 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

RE: $$Excel-Macros$$ Finding a cell based on multiple criteria typed into cells

Could you please attach sample sheet. Regards, C.G.Kumar AMW-2 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Sach1810 Sent: Wednesday, July 14, 2010 3:12 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Finding a cell

$$Excel-Macros$$ Re: Index match with 3 criteria

Hi You can use the below formulae: =IF(AND(A1=Sheet1!A1,B1=Sheet1!B1,C1=Sheet1!C1),Sheet1!D1,"not") Regards Rajender Soni On Jul 15, 1:39 am, Nadine S wrote: > I need to lookup a value based on matching 3 other columns.  I do not want to > use a concatenation and then look up that. > > I have

Re: $$Excel-Macros$$ Re: how to copy 1 file column to another file column automatically

Thanks you sir, i will try to do it On Mon, Jul 12, 2010 at 12:45 PM, George wrote: > Hi Ankit, > > You can run this code and enjoy. > > Sub Macro1() >Columns("A:A").Select >Selection.Copy >Windows("as.xls").Activate >Columns("B:B").Select >ActiveSheet.Paste >Windows("a

Re: $$Excel-Macros$$ Index match with 3 criteria

Hi, Yes I can, but need a sample file for proper result you want. Regards Sandeep On Thu, Jul 15, 2010 at 2:09 AM, Nadine S wrote: > I need to lookup a value based on matching 3 other columns.  I do not want > to use a concatenation and then look up that. > > I have Sheet1 that has 4 columns in

$$Excel-Macros$$ Data Logic

Dear All: This is the sample spread sheet i have. pat meds stdt spdt 111 ABC 1 . 111 CDE 130 150 111 NNN 132 140 111 GHI 160 170 111 LMN 165 . 111 OPQ 168 . 222 ABC 1 . 222 CBM 130 140 222 AAA 135 140 222 KHA 1 . ; run; I am trying to count the number of meds at diffe

$$Excel-Macros$$ Index match with 3 criteria

I need to lookup a value based on matching 3 other columns.  I do not want to use a concatenation and then look up that. I have Sheet1 that has 4 columns in it and Sheet2 that has 3.  In Sheet 2, Column D, I need a formula that will return the text in Col D on Sheet1 if the values in the first t

$$Excel-Macros$$ Excel macro undefined variable

I am looking at a macro in a fairly large multi-tab Excel file. (This is not my file, I am validating some economic assumptions that this file uses, and I want to see where they end up.) Anyway, I ran across this line of code in the macro: "BranchLine = BranchLine + 1". Looking back through the ma

$$Excel-Macros$$ What does $ at the end of a function mean?

Hello all: I know that $ is a type declaration character for variables. Does it do something similar if used at the end of a function? How is Chr(13) different from Chr$(13)? Thanks. -- -- Some important links for e

$$Excel-Macros$$ Re: Outlook Problem

Open a new message, in the tool bar (same row as the send button) is the options tab, click. A new screen will open and you can check under delivery options do not deliver before a set time. >From what I know, Outlook must be left open for it to send. Someone else may know differently though. I'v

$$Excel-Macros$$ Finding a cell based on multiple criteria typed into cells

Hi, I have a table of data giving different prices of different items. Below is a sample of that data. I want to be able to type in teh criteria (Shape Weight Colour condition) and then the document to show me the price for that criteria. Say A1 = SHAPE B1=Weight c1 = colour d1 = condition And

Re: $$Excel-Macros$$ Google Translator Using VBA - HELP !!!

Hi Harmeet, Thanks a lot mate for this but I have been through this file and it converts the values one by one and takes hell lot of time. What I wanted was to upload the files to google translator... I m still breaking my head with google to find it smhow.. but coudnt find it. Thnks ANISh On

$$Excel-Macros$$ Outlook Problem

Hi guys Sorry for outlook but i just wnat to know that is it possible to send any saved mail in outlook at any specified time automatically. Suppose i want to send any mail automatically at 10 PM, is it possible. Regards, Deepak -- --

Re: $$Excel-Macros$$ Re: Urgent - MS Excel charts

Hi Gaurav, I have explained the funda / logic in my previous emails in this chain email itself. Anyways, same is reproduced below for your convenience. Those groups have been created by using "Group and Show Detail" feature of Pivot Table. Just right click on the pivot table and you'll see t

Re: $$Excel-Macros$$ Re: Urgent - MS Excel charts

Hey Mathan...!! Thanks for the honour :) -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Wed, Jul 14, 2010 at 11:00 AM, Mathan wrote: > Hi Dilip, > > I have created a folder named as "

Re: $$Excel-Macros$$ Re: Urgent - MS Excel charts

Hi Dilip, Can u explain how u did 25-30,30-35 in pivot table & chart? Thanks & Regards, Gaurav Jain On Tue, Jul 13, 2010 at 8:30 PM, Dilip Pandey wrote: > Hey Ahmed.. the "Honest" man.!! :) > > You are most welcome to share the knowledge and experience(s) and offcourse > for a friendship fill