date:20160209

$$Excel-Macros$$ Re: Day, Date, Months

2016-02-09 Thread Mandeep Baluja

We can't entertain manual changes request, As your data is not correct Lots 
of typo errors in this Ex: "Wednesdsy",Extra Spaces in no particular trend



Regards, 
Mandeep baluja 

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from 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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Interview Questions with Answers (Excel+VBA+Access+SQL Server)

2016-02-09 Thread sanglesneha17



On Thursday, 10 May 2012 16:49:25 UTC+5:30, NOORAIN ANSARI wrote:
>
> Dear Group,
>
> Please find attached Interview questions and answers for MS Excel+VBA+MS 
> Access+SQL Server.
>
> If any one have this type of question and answers, Kindly share with group.
>
>
>
>
> -- 
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>  
> thanks a lot noorain,it was very helpfull
>
>
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from 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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Interest calculation as per we put years in -- D3 -- Can anybody help me out

2016-02-09 Thread big smile

Respected All ,

Can anybody Help me out for this query.

On 9 February 2016 at 12:36, big smile  wrote:

> Respected All,
>
> Can i have solution for this my query ..
>
>
>
> On 8 February 2016 at 17:57, big smile  wrote:
>
>> Respected  All Excel Guru's
>> In my attached file I want that in D3 column if I change years
>> i.e. -- if I write 10 Years then automatically
>> 10 Years calculation done
>> that is it calculate from raw 11 to 20 & show final in total
>> The same way it automatically caluclate what ever we put value
>> If we put 20 years . It shows for 21 Years
>> Thanks a lot & have a nice day to all
>>
>
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from 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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Need macro for Vlookup

2016-02-09 Thread Prabhu Pinky

Hi Pankaj,

I just noticed, that in output "Start" and "End" time seems same.

Regards,
Prabhu.R


Thanks & Regards,
Prabhu R

On 10 February 2016 at 01:26, Prabhu Pinky  wrote:

> Hi pankaj,
>
> Thanks a ton for the coding...
>
> It's working very fine as I expected.. Thanks again.
>
> Regards,
> Prabhu.R
> On Feb 10, 2016 12:03 AM, "Secret Shot"  wrote:
>
>> Hay Prabhu,
>>
>> You can use this code to do your required task. . follow the steps
>>
>> Go to visual basic editor under Developer tab
>> Insert a module
>> and paste below code in that module
>>
>> Sub VLup_Macro()
>> 'To selecct perticuler sheet
>> Sheets("Schedule Check").Select
>> 'To delete any previous data
>> Range("P6:AC65000").Select
>> Selection.ClearContents
>> 'to put formula
>> Range("P6").Select
>> ActiveCell.FormulaR1C1 = "=VLOOKUP(RC14&R4C,'Text
>> Roster'!C27:C28,2,0)"
>> Range("P6").Select
>> Selection.Copy
>> Range("P6:AC6").Select
>> ActiveSheet.Paste
>> Application.CutCopyMode = False
>> Selection.Copy
>> Range("O65000").Select
>> Selection.End(xlUp).Select
>> ActiveCell.Offset(0, 1).Select
>> Range(Selection, Selection.End(xlUp)).Select
>> ActiveSheet.Paste
>> Application.CutCopyMode = False
>> 'for paste special (If you dont want to paste special then delete the
>> code below)
>> Selection.Copy
>> Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
>> SkipBlanks _
>> :=False, Transpose:=False
>> Application.CutCopyMode = False
>> Selection.End(xlUp).Select
>> Range("O4").Select
>> End Sub
>>
>> Also attaching Excel for your reference.
>>
>> Regards
>> Pankaj k Pandey
>>
>>
>> On Tue, Feb 9, 2016 at 11:28 PM, Prabhu Pinky 
>> wrote:
>>
>>> Hi Experts,
>>>
>>> I have attached one file, kindly help me with macro code for vlookup.
>>>
>>> > There is two tabs in the file.
>>> > In second tab (sheet name : Schedule Check) i did put the vlookup
>>> formula manually for your reference.
>>> > I have shaded the range where the formula needs to be applied.
>>> > That row range is Dynamic, will be increase or decrease according to
>>> the data updated in Column N & Column O
>>> > But Column range will not increase, only till Column AC the formula
>>> needs to be applied.
>>>
>>>
>>> Thanks & Regards,
>>> Prabhu R
>>>
>>> --
>>> 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 Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from 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 https://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>>
>> --
>> Pankaj Pandey
>> Bhopal
>>
>> --
>> 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 Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from 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 https://groups.google.com/group/excel-macros.
>> For more options, visit ht

$$Excel-Macros$$ To insert new row below when the data is unmatched

2016-02-09 Thread Kat

Hi all, 

I'm trying to insert a new row below the matched data in trial.xlsm and 
copy the unmatched data and write 'New' in column B when the data is found 
unmatched. However, I can't achieve this. I've attached the pp.xlsx file in 
which the Sheet2 in pp.xlsx is the result that I want to achieve. The file 
trial.xlsm is the code that I've written.

Can anyone please help? Thanks in advanced.



-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from 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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


pp.xlsx
Description: MS-Excel 2007 spreadsheet


trial.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ copy new column from sheet 1 and paste to sheet 2

2016-02-09 Thread Kat

Thank you very much for your help. It's much appreciated.

On Friday, 5 February 2016 23:16:28 UTC+8, era_kar wrote:
>
> Hi,
> I give u the following code you can run and get what u expect. For the 
> next time u have to change the j value(i.e.,column
> value,A=1 B=2 etc) to 6 to 7, and next time this should be 8 to 9.Or if u 
> don't mind in over printing the data,u can put 
> j value = 4 to 33.It is upto u.Here the row is fixed to 15 i.e., i value
>
> Sub FillSheet1To2()
> Dim i, j As Integer
>  For i = 1 To 15
> For j = 4 To 5
>
>  Sheets("sheet2").Cells(i, j).Value = Sheets("sheet1").Cells(i, 
> j).Value
>  
>  Next j
>   Next i
>
> End Sub
>
> -r.Karunanithi.
>
>
> --
> *From:* Kat >
> *To:* MS EXCEL AND VBA MACROS > 
> *Sent:* Thursday, February 4, 2016 1:07 PM
> *Subject:* $$Excel-Macros$$ copy new column from sheet 1 and paste to 
> sheet 2
>
> Hi all,
>
> I have a workbook in which the row is fixed (eg. from column A to C) and 
> the user will keep adding new column (eg. from adding data in Column D to E 
> first time, second time adding data in column F to H) in Sheet 1. Everytime 
> when new column is added in Sheet1, I want it to be automatically being 
> copied and pasted into Sheet2 as well starting from Column F. For instance, 
> When user add data in Column D to E first time, then the data being added 
> in Column D to E in Sheet1 will be automatically being copied and pasted in 
> Column F to G in Sheet2. Can anyone help?
>
> Thanks in advanced.
> -- 
> 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 Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>  
> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
> members are not responsible for any loss.
> --- 
> You received this message because you are subscribed to the Google Groups 
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to excel-macros...@googlegroups.com .
> To post to this group, send email to excel-...@googlegroups.com 
> .
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from 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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Having difficulty sorting based on a column of values

2016-02-09 Thread robflott2

I am working with Excel 2013 and am experiencing difficulty trying to sort 
a block of data based on a '% share' calculation.

Each cell in the '% share' column is a formula; for example B9/$B$29

Where cells B9 through B28 are themselves a formula: (for example cell B9 
is "=COUNTIFS(Year,Sel_Year,Mgr,Mgr!A9)"
The similar formula appears in each cell B9 through B28

I don't recall ever having problems ranking (or sorting) on resulting 
values of formula before.

Is there something obvious that I am missing?

I don't want to take the resulting values out of formula.

Appreciate any help with this.

Thank you 

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from 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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Need macro for Vlookup

2016-02-09 Thread Prabhu Pinky

Hi pankaj,

Thanks a ton for the coding...

It's working very fine as I expected.. Thanks again.

Regards,
Prabhu.R
On Feb 10, 2016 12:03 AM, "Secret Shot"  wrote:

> Hay Prabhu,
>
> You can use this code to do your required task. . follow the steps
>
> Go to visual basic editor under Developer tab
> Insert a module
> and paste below code in that module
>
> Sub VLup_Macro()
> 'To selecct perticuler sheet
> Sheets("Schedule Check").Select
> 'To delete any previous data
> Range("P6:AC65000").Select
> Selection.ClearContents
> 'to put formula
> Range("P6").Select
> ActiveCell.FormulaR1C1 = "=VLOOKUP(RC14&R4C,'Text Roster'!C27:C28,2,0)"
> Range("P6").Select
> Selection.Copy
> Range("P6:AC6").Select
> ActiveSheet.Paste
> Application.CutCopyMode = False
> Selection.Copy
> Range("O65000").Select
> Selection.End(xlUp).Select
> ActiveCell.Offset(0, 1).Select
> Range(Selection, Selection.End(xlUp)).Select
> ActiveSheet.Paste
> Application.CutCopyMode = False
> 'for paste special (If you dont want to paste special then delete the
> code below)
> Selection.Copy
> Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
> SkipBlanks _
> :=False, Transpose:=False
> Application.CutCopyMode = False
> Selection.End(xlUp).Select
> Range("O4").Select
> End Sub
>
> Also attaching Excel for your reference.
>
> Regards
> Pankaj k Pandey
>
>
> On Tue, Feb 9, 2016 at 11:28 PM, Prabhu Pinky 
> wrote:
>
>> Hi Experts,
>>
>> I have attached one file, kindly help me with macro code for vlookup.
>>
>> > There is two tabs in the file.
>> > In second tab (sheet name : Schedule Check) i did put the vlookup
>> formula manually for your reference.
>> > I have shaded the range where the formula needs to be applied.
>> > That row range is Dynamic, will be increase or decrease according to
>> the data updated in Column N & Column O
>> > But Column range will not increase, only till Column AC the formula
>> needs to be applied.
>>
>>
>> Thanks & Regards,
>> Prabhu R
>>
>> --
>> 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 Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from 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 https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
> Pankaj Pandey
> Bhopal
>
> --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from 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 https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 Please Help, 
Urgent, Need

$$Excel-Macros$$ URGENT NEED Data Analyst/UAT Tester---Charlotte, NC.

2016-02-09 Thread MADHU-GenuineItLlc

Hi Partner,

Hope you are doing great …

Please send resume to ma...@genuineitllc.com



*Title:** Data Analyst/UAT Tester*

*Duration: **10+ months*

*Location: **Charlotte, NC*



*Responsibilities*

   - Partner closely with the implementation and business teams to support
   Line of Business releases by thoroughly understanding their Business
   Requirements and ensuring each release fulfills business expectations.
   - Review/Create Business Requirements and Use Cases
   - Review Functional Specification Designs, Data Models, Data Mappings,
   Architectural Documentation
   - Create UAT Test Plans, Test Cases, and Test Scripts
   - Perform UAT Execution, Defect Management
   - Financial Reconciliation and Data Validation using SQL
   - Participate in the testing and business checkout of each major release
   and dot-release
   - Provide Level 2 end user support as needed

*Basic Qualifications:*

   - Strong business/finance skills along with a solid understanding of
   databases and systems and the ability to communicate effectively across
   groups.
   - Excellent written and oral communication skills
   - Solid understanding of relational database concepts
   - Hands-on experience with SQL (Oracle preferred) and querying
   multi-dimensional databases
   - Strong understanding of customer profitability and cross-sell
   - Strong banking and financial domain knowledge
   - Experience working with system development life cycle processes
   - Hands on experience in ALM (Application lifecycle management)/HP
   Quality Center

*Required Skills:-*

Test Management - Test Plan Creation -Minimum 5 Years Required

Test Management - Test Strategy CreationMinimum 5 Years Required

Test Management - Testing Life Cycle Minimum 5 Years Required

Manual Testing - Test Management Tool - Quality Center--Minimum 3 Years
Required

Business Analysis - Data Analysis --Minimum 3 Years Required

Business Analysis - Domain Knowledge - Financial Services--Minimum
3 Years Required

SQL Scripting--  Minimum 3 Years Required

Backend Testing - Minimum 3Years Required



---

*With Warm Regards *

*Madhu Roy*

GenuineIT LLC *Certified Women Owned Business*

Making IT Happen…

Ph: 832 539 3475

Fax: 281-605-5969

*E-Mail* :ma...@genuineitllc.com

*Gmail *: *nandimadhu74 , madhu.genuineitllc*

*YM  *: madhu_recruiter



Looking ahead to work with you for better Business prospects



According to Bill S.1618 Title III passed by the 105th US Congress, this
message is not considered as "Spam" as we have included the contact
information. If you wish to be removed from our mailing list, please
respond with "remove" in the subject field. We apologize for any
inconvenience caused.

Please consider the environment before printing this e-mail

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from 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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Export to XML with multiple Child elements

2016-02-09 Thread Jonathan Vaz



Hi,

I am trying to export data from my excel file to an XML file. I have 
attached the excel file being used to convert data to XML.
Can someone suggest me how to achieve the below.



Thanks in Advance.

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from 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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


xls2xml.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Need Excel Macro Training

2016-02-09 Thread Prabhakar Thakur

Hi,

Please share details in Delhi

Thanks,
Prabhakar Thakur
New Delhi
+919953736776

On Mon, Feb 8, 2016 at 12:33 PM, Prabhakar Thakur <
prabhakarthak...@gmail.com> wrote:

> Hi Group Member
>
> I need excel macro training please share best training institute details
> or share link
>
>
> Thanks,
> Prabhakar Thakur
> New Delhi
> +919953736776
>
> --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from 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 https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from 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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Day, Date, Months

$$Excel-Macros$$ Re: Interview Questions with Answers (Excel+VBA+Access+SQL Server)

$$Excel-Macros$$ Re: Interest calculation as per we put years in -- D3 -- Can anybody help me out

Re: $$Excel-Macros$$ Need macro for Vlookup

$$Excel-Macros$$ To insert new row below when the data is unmatched

Re: $$Excel-Macros$$ copy new column from sheet 1 and paste to sheet 2

$$Excel-Macros$$ Having difficulty sorting based on a column of values

Re: $$Excel-Macros$$ Need macro for Vlookup

$$Excel-Macros$$ URGENT NEED Data Analyst/UAT Tester---Charlotte, NC.

$$Excel-Macros$$ Export to XML with multiple Child elements

Re: $$Excel-Macros$$ Need Excel Macro Training

11 matches

Site Navigation

Mail list logo

Footer information