Re: $$Excel-Macros$$ VBA Macro to take list of multiple inputs, apply to another spreadsheet, and return value

2013-09-21 Thread Ms Excel user
For Z = 1 To 20 Sheet2.Cells(Z + 1, 4) = Cells(Z + 1, 1) * Cells(Z + 1, 2) * Cells(Z + 1, 3) Next Z End Sub ** * Best Regards, Ms Excel User * ** On Sat, Sep 21, 2013 at 10:07 PM, Derick Jones wrote: > I want to create a macro to take multiple inputs from sheet 2, apply t

Re: $$Excel-Macros$$ Urgent- Query on lookup

2013-09-06 Thread Ms Excel user
Hi, Provide the example output. ** * Best Regards, Ms Excel User * ** On Fri, Sep 6, 2013 at 9:07 PM, ashwani agnihotri < ashwani.agniho...@gmail.com> wrote: > Hi Kartik, > > > > Thanks for looking into this. The result is still not what I want. I ha

Re: $$Excel-Macros$$ Indirect Function syntax

2013-07-20 Thread Ms Excel user
Hi, Use this =VLOOKUP(INDIRECT("A1"),B1:C3,2,FALSE) ** * Best Regards, Ms Excel User * ** On Sun, Jul 21, 2013 at 1:08 AM, MLT wrote: > cool thanks. can that same syntax be used for vlookup? > > > for example: > > =VLOOKUP(INDIRECT("A1,B1:C3

Re: $$Excel-Macros$$ Indirect Function syntax

2013-07-20 Thread Ms Excel user
Hi MLT, Use this =SUM(INDIRECT("A1:A3")) ** * Best Regards, Ms Excel User * ** On Sun, Jul 21, 2013 at 12:37 AM, MLT wrote: > I'm trying to figure out how to use a function within the indirect > function. for example, I would like to use a s

Re: $$Excel-Macros$$ Hyperlink by Sheets Name.........

2013-04-20 Thread Ms Excel user
group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- ** * Best Regards, Ms Excel User * ** -- Are you =EXP(E:RT)

Re: $$Excel-Macros$$ Disable saveas option

2013-03-05 Thread Ms Excel user
rom it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > >

Re: $$Excel-Macros$$ Query collation of data ignoring #n/a

2013-02-15 Thread Ms Excel user
glegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- ** * Best Regards, Ms Excel User * ** -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,

Re: $$Excel-Macros$$ Request for formula:Unique value from same month

2012-12-11 Thread Ms Excel user
oogle Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=

Re: $$Excel-Macros$$ lookup based on multiple dates.

2012-12-03 Thread Ms Excel user
; "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > >

Re: $$Excel-Macros$$ Excel formula to retrieve the two first characters from a name

2012-11-03 Thread Ms Excel user
Hi, please find attachment. *Best Regards,* *Ms Excel User* On Sat, Nov 3, 2012 at 11:43 PM, cyberuser wrote: > Hi, > > The text is located in a single cell and it can be of variable words... > > example: > > Cells A1: "John Doe Junior" > Cell B1 shou

Re: $$Excel-Macros$$ Help Required

2012-11-02 Thread Ms Excel user
Hi neeraj, see the attachment. -- ***Best Regards, Ms Excel User * On Fri, Nov 2, 2012 at 5:39 PM, neeraj chauhan wrote: > Dear Experts, > > kindly find the attached sheet. > > -- > Join official facebook page of this forum @ > https://www.facebook.com/d