$$Excel-Macros$$ To seek help on displaying the first column and a given active column

2018-03-08 Thread Sandeep Kumar Baranwal
heet, the given excel sheet displays all the hidden & unhidden columns Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valuation, Deloitte US India Gurgaon India Mob:-+91-8588802543 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

$$Excel-Macros$$ Need VBA Macro that would align all the paragraphs of word document in one go

2018-02-01 Thread Sandeep Kumar Baranwal
peat steps 2) and 3) Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valuation, Deloitte US India Gurgaon India Mob:-+91-8588802543 -- 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 Faceb

$$Excel-Macros$$ Excel query using Excel Function

2017-10-06 Thread Sandeep Kumar Baranwal
performed this using a formula. But it is of nature of circular reference. Can I have improvised version of the excel formula to take care of this ? Let me know if my query is clear for understanding. Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valua

$$Excel-Macros$$ Creating Repetitive Dynamic Graph in multiple worksheet using VBA

2017-06-29 Thread Sandeep Kumar Baranwal
Hi Please note that I have 3 worksheets in a workbook with the same number of columns and would like to create dynamic graph in each worksheet at the same time. Column X along X-axis and Column Y and MeanY along Y-axis The Data excel is enclosed. Thanks & regards, *Sandeep Kumar Baranwal*

Re: $$Excel-Macros$$ Required break chart in excel

2017-06-10 Thread Sandeep Kumar Baranwal
under Axis option category. You will get a break chart in excel. Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valuation, Deloitte US India Gurgaon India Mob:-+91-8588802543 On Sat, Jun 10, 2017 at 9:46 AM, amar takale <amartak...@gmail.com> wrote:

Re: $$Excel-Macros$$ GOAL SEEK

2017-06-08 Thread Sandeep Kumar Baranwal
: Simplex LP Click : Solve Hope you get the answer. Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valuation, Deloitte US India Gurgaon India Mob:-+91-8588802543 On Wed, Jun 7, 2017 at 7:44 AM, GENIUS <izharra...@gmail.com> wrote: > OH

Re: $$Excel-Macros$$ GOAL SEEK

2017-06-05 Thread Sandeep Kumar Baranwal
Variable Non-Negative Select a Solving Method : Simplex LP Click : Solve Hope you get the answer. Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valuation, Deloitte US India Gurgaon India Mob:-+91-8588802543 On Tue, Jun 6, 2017 at 11:15 AM, Sandeep K

Re: $$Excel-Macros$$ GOAL SEEK

2017-06-05 Thread Sandeep Kumar Baranwal
. . . . $I$13=$A$13 $I$14=$A$14 $I$15=$A$15 Check (Tick Mark) - Make Unconstrained Variable Non-Negative Select a Solving Method : Simplex LP Click : Solve Hope you get the answer. Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valuation, Deloitt

Re: $$Excel-Macros$$ GOAL SEEK

2017-06-05 Thread Sandeep Kumar Baranwal
, as required. Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valuation, Deloitte US India Gurgaon India Mob:-+91-8588802543 On Sat, May 13, 2017 at 11:34 AM, Izhar <izharra...@gmail.com> wrote: > look at the attachment when we click on GOAL SE

Re: $$Excel-Macros$$ why excel is slow when we run macro

2017-06-05 Thread Sandeep Kumar Baranwal
take time. The excel seems to be working slow. Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valuation, Deloitte US India Gurgaon India Mob:-+91-8588802543 On Sun, Jun 4, 2017 at 3:59 PM, <paramdeepwa...@gmail.com> wrote: > why excel is

Fwd: $$Excel-Macros$$ To seek help on writing Excel formula

2016-09-12 Thread Sandeep Kumar Baranwal
Hi Thanks for the concern. Please find the details in spreadsheet attached. Please note that the match operation need to be performed basis the variable "dataset" in "Sheet1" and Variable_sheet2 in "Sheet1" should be populated using "Sheet2". Thanks

Re: $$Excel-Macros$$ To seek help on writing Excel formula

2016-09-11 Thread Sandeep Kumar Baranwal
Hi Kindly note that the match operation is to be performed basis the variable "dataset" in "Sheet1" and Variable_sheet2 in "Sheet1" should be populated using "Sheet2". Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation an

$$Excel-Macros$$ To seek help on writing Excel formula

2016-09-09 Thread Sandeep Kumar Baranwal
FirstNameLastName Variable_sheet2 abc_xyz abc xyz rpm_xyz rpm_xyz rpm xyz abc_xyz Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valuation, Deloitte US India Gurgaon India Mob:-+91-858880

$$Excel-Macros$$ Defining Name Ranges in Excel for different selection region using VBA/Macro

2016-02-02 Thread Sandeep Kumar Baranwal
is to be defined for selection $D$1:$E$10 Another name range is to be defined for selection $G$1:$H$10 And so on Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valuation, Deloitte US India Gurgaon India Mob:-+91-8588802543 -- Are you =EXP(

$$Excel-Macros$$ Need VBA code to convert multi-pages PDF file into multiple sheets Excel Spreadsheet

2014-08-04 Thread Sandeep Kumar Baranwal
Hi Could anyone help me with the VBA code to convert multi-pages PDF file to multiple sheets Excel spreadsheet ? Thanks regards, *Sandeep Kumar Baranwal* Assistant Manager Credit Risk Methodology Wholesale Basel,Genpact Gurgaon India Mob:-+91-8588802543 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT

$$Excel-Macros$$ Need VBA code that will compute number of Yes against each question in the given Questionaire

2014-08-01 Thread Sandeep Kumar Baranwal
Kumar Baranwal* Assistant Manager Credit Risk Methodology Wholesale Basel,Genpact Gurgaon India Mob:-+91-8588802543 -- 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

Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-11-12 Thread Sandeep Kumar Baranwal
Hi Basole I am glad you understood my requirement. Kindly share the models that use excel to ms access with tables and indexes at your convenience. Looking forward to your generous help once again. Thanks regards, *Sandeep Kumar Baranwal* Assistant Manager Credit Risk Methodology Wholesale

Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-11-07 Thread Sandeep Kumar Baranwal
? Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar Baranwal escreveu: Hi Kindly note that sql.request is functional in MS Excel 2007 but not in MS Excel 2010. Could you please let me know any VBA code that would be a substitute for sql.request. If yes, Please let me know

Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-11-06 Thread Sandeep Kumar Baranwal
on the same requirement for importing data from MS Access to MS Excel using querytables ? The version that you helped me with, uses recordset. I want to use querytables instead. Thanks regards, *Sandeep Kumar Baranwal* Assistant Manager Credit Risk Methodology Wholesale Basel,Genpact Gurgaon India

Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-11-05 Thread Sandeep Kumar Baranwal
that would enhance my ability to optimize my skills at VBA excel ? It would be really great of you if you allow me to grow with VBA excel under your guidance. Thanks regards, *Sandeep Kumar Baranwal* Business Analyst Credit Risk Methodology Wholesale Basel,Genpact Gurgaon India Mob:-+91-8588802543

Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-11-03 Thread Sandeep Kumar Baranwal
Access. The problem now faced , is related to cx.connectar. Could you resolve this ? Thanks regards, *Sandeep Kumar Baranwal* Assistant Manager Credit Risk Methodology Wholesale Basel,Genpact Gurgaon India Mob:-+91-8588802543 On Fri, Jul 19, 2013 at 8:17 PM, Basole ricardo...@gmail.com wrote

Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-07-18 Thread Sandeep Kumar Baranwal
sheet. Thanks regards, *Sandeep Kumar Baranwal* Business Analyst Credit Risk Methodology Wholesale Basel,Genpact Gurgaon India Mob:-+91-8588802543 On Thu, Jul 18, 2013 at 9:08 AM, Sandeep Kumar Baranwal sandeepkumarbaran...@gmail.com wrote: Hi I am not able to access the ImportAccess.zip

Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-07-18 Thread Sandeep Kumar Baranwal
the dropdown box in MS Excel, I have data (23,34,45) imported from MS access to MS Excel. Similarly if I choose 2 from dropdown box , I have (67,34) imported from MS Access to MS Excel. Thanks regards, *Sandeep Kumar Baranwal* Business Analyst Credit Risk Methodology Wholesale Basel,Genpact

$$Excel-Macros$$ To know about the substitute of SQL.REQUEST

2013-07-17 Thread Sandeep Kumar Baranwal
in version 2007 Thanks regards, *Sandeep Kumar Baranwal* Business Analyst Credit Risk Methodology Wholesale Basel,Genpact Gurgaon India Mob:-+91-8588802543 -- 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

Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-07-17 Thread Sandeep Kumar Baranwal
Hi I am not able to access the ImportAccess.zip folder that you have send across. Please look into the issue. Thanks regards, *Sandeep Kumar Baranwal* Business Analyst Credit Risk Methodology Wholesale Basel,Genpact Gurgaon India Mob:-+91-8588802543 On Wed, Jul 17, 2013 at 8:59 PM, Basole

Re: $$Excel-Macros$$ drawing chart based on the given data

2012-07-07 Thread Sandeep Kumar Baranwal
) year (along x-axis) versus salary (along y-axis (secondary axis)) and the chart must incorporate every new set of values that are appended below the given list in sheet 1 of the attached excel sheet. *Sandeep Kumar Baranwal* Credit Risk Methodology Wholesale Basel Gurgaon Mob:-08588802543 On Sat

Re: $$Excel-Macros$$ drawing chart based on the given data

2012-07-06 Thread Sandeep Kumar Baranwal
every new set of values that are appended below the given list in sheet 1 of the attached excel sheet. *Sandeep Kumar Baranwal* Credit Risk Methodology Wholesale Basel Gurgaon Mob:-08588802543 On Fri, Jul 6, 2012 at 6:23 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Use

Re: $$Excel-Macros$$ drawing chart based on the given data

2012-07-06 Thread Sandeep Kumar Baranwal
Respected Rajan Sir I am not able to locate the related VBA code in the attached excel sheet. Will you please provide the VBA code. *Sandeep Kumar Baranwal* Credit Risk Methodology Wholesale Basel Gurgaon Mob:-08588802543 On Fri, Jul 6, 2012 at 9:02 PM, Rajan_Verma rajanverma1

Re: $$Excel-Macros$$ drawing chart based on the given data

2012-07-06 Thread Sandeep Kumar Baranwal
Hi Sir Thanks for introducing me the use of dynamic range assignment. thanks a lot for you help. can there be VBA code as an alternative to using dynamic range for drawing the chart? If yes, will you please introduce me to that as well? *Sandeep Kumar Baranwal* Credit Risk Methodology

Re: $$Excel-Macros$$ Excel VBA Book?

2012-06-05 Thread Sandeep Kumar Baranwal
. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Sandeep Kumar Baranwal* Credit Risk Methodology Wholesale Basel Gurgaon Mob:-08588802543 -- FORUM RULES (986