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 derickdavidjo...@gmail.comwrote: I want to create a macro to take multiple inputs from

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 have tried to explain it below

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 mlthorn...@gmail.com wrote: I'm trying to figure out how to use a function within the indirect function. for example, I would like to use a sum

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 mlthorn...@gmail.com wrote: cool thanks. can that same syntax be used for vlookup? for example: =VLOOKUP(INDIRECT(A1,B1:C3,2,FALSE

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

2013-04-20 Thread Ms Excel user
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,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like

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

2013-03-05 Thread Ms Excel user
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,DO:IT,N:OW) ! Join official

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

2013-02-15 Thread Ms Excel user
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. -- ** * Best Regards, Ms Excel User

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

2012-12-11 Thread Ms Excel user
. 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. -- ** * Best Regards, Ms Excel User * ** -- Join official Facebook page of this forum @ https://www.facebook.com

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

2012-12-03 Thread Ms Excel user
. -- ** * Best Regards, Ms Excel User * ** -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get

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 netuser...@gmail.com 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 should return jodoju

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 neerajchauhan...@gmail.comwrote: Dear Experts, kindly find the attached sheet. -- Join official facebook page of this forum @ https://www.facebook.com