$$Excel-Macros$$ Re: Unable to Manipulate tab delimited data

[Mandeep Baluja]

dont type -- manually just copy it and replace otherwise replace will not 
work.

On Tuesday, March 31, 2015 at 12:22:54 AM UTC+5:30, Bill Q wrote:
>
> Thanks, but I must be doing something wrong - becuase it isn;t working for 
> me. 
>
> On Sunday, 29 March 2015 17:37:58 UTC-4, Bill Q wrote:
>>
>> Attached is a very small sample of a much larger data set. I need to 
>> separate the data - in this case in 3 different and separate columns. For 
>> whatever reason there is what looks like a tilde between the numbers. I 
>> cannot seem to put in the right delimiter in order to have it separated 
>> properly.
>>
>> Need help to what appears to be a simple problem. 
>>
>> Thanks.  
>>
>

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Unable to Manipulate tab delimited data

[Mandeep Baluja]

Copy your double code in replace box don't type it it will get easily 
replaced.

On Tuesday, March 31, 2015 at 12:22:54 AM UTC+5:30, Bill Q wrote:
>
> Thanks, but I must be doing something wrong - becuase it isn;t working for 
> me. 
>
> On Sunday, 29 March 2015 17:37:58 UTC-4, Bill Q wrote:
>>
>> Attached is a very small sample of a much larger data set. I need to 
>> separate the data - in this case in 3 different and separate columns. For 
>> whatever reason there is what looks like a tilde between the numbers. I 
>> cannot seem to put in the right delimiter in order to have it separated 
>> properly.
>>
>> Need help to what appears to be a simple problem. 
>>
>> Thanks.  
>>
>

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ How to show VBA code in *.xlsm format file

[Pramod Singh]

Hi

There is not vba code. This is just made by custom UI editor. ..there is
control by made in Custom UI editor.

Pramod
On 31 Mar 2015 11:02, "Ashish Bhalara"  wrote:

> Dear experts,
>
> I have downloaded some files with macro to editing in ribbon for learning
> purpose, but I can't see coding in file. Could you guide me how to show VBA
> code in attached file.
>
> Kindly also know me some books of VBA coding about editing in Excel Ribbon.
>
> Thanks in advance
>
> Regards.
> Ashish Bhalara
> 9624111822
> P*Please do not print this email unless it is absolutely necessary.
> Spread environmental üawareness.♣♣♣*
>
>  --
> 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 http://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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ How to show VBA code in *.xlsm format file

[Ashish Bhalara]

Dear experts,

I have downloaded some files with macro to editing in ribbon for learning
purpose, but I can't see coding in file. Could you guide me how to show VBA
code in attached file.

Kindly also know me some books of VBA coding about editing in Excel Ribbon.

Thanks in advance

Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


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


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

$$Excel-Macros$$ How to check a field and change highlight color if the cell value changes

[Bob Engler]

  

  
  
   field 1field 2field 3field 41
x1235421x24367822x325997886b82938826212b77374q11
ccb273bs62g79fffppaa6w5qp99pl9fffddlsa52d87s7rk27hwlr7le3
88w77wr15jjjfawf2f34ks4ks33m77k442uuaw87efield 1field 2field 3field 
41x1235421x24367822x325997886b82938826212b77374q11
ccb273bs62g79fffppaa6w5qp99pl9fffddlsa52d87s7rk27hwlr7le3
88w77wr15jjjfawf2f34ks4ks33m77k442uuaw87e

The top is the sheet before doing what I need. the bottom is what I need to 
do. What I want is if field 2 (row 1 is header row) is the same, the row is 
highlighted the same. If field 2 is different from the one above it, the 
row is highlighted with a different color (alternating colors are fine on 
the changing row). The sheet is sorted on field 2. I normally do this 
manually but the Excel they just sent me has over 1,000 rows and most of 
the field 2s are non repeating.

Thank you,

Bob Engler

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

[bobengler]

I could use your expertise again if you are available. I have an excel sheet 
like below


| field 1 | field 2 | field 3 | field 4 |
| 1 | x | 123 | 542 |
| 1 | x | 243 | 6782 |
| 2 | x | 325 | 99788 |
| 6 | b | 8293 | 88262 |
| 12 | b | 77374 | q |
| 11 | cc | b273b | s62g7 |
| 9 | fff | ppaa6w5 | qp99pl |
| 9 | fff | ddlsa52d | 87s7rk2 |
| 7 | h | wlr7le3 | 88w77wr |
| 15 | jjj | fawf2f34 | ks4ks3 |
| 3 | m | 77k442 | uuaw87e |
|  |  |  |  |
|  |  |  |  |
| field 1 | field 2 | field 3 | field 4 |
| 1 | x | 123 | 542 |
| 1 | x | 243 | 6782 |
| 2 | x | 325 | 99788 |
| 6 | b | 8293 | 88262 |
| 12 | b | 77374 | q |
| 11 | cc | b273b | s62g7 |
| 9 | fff | ppaa6w5 | qp99pl |
| 9 | fff | ddlsa52d | 87s7rk2 |
| 7 | h | wlr7le3 | 88w77wr |
| 15 | jjj | fawf2f34 | ks4ks3 |
| 3 | m | 77k442 | uuaw87e |


The top is the sheet before doing what I need. the bottom is what I need to do. 
What I want is if field 2 (row 1 is header row) is the same, the row is 
highlighted the same. If field 2 is different from the one above it, the row is 
highlighted with a different color (alternating colors are fine on the changing 
row). The sheet is sorted on field 2. I normally do this manually but the Excel 
they just sent me has over 1,000 rows and most of the field 2s are non 
repeating.
Thank you,
Bob Engler

   From: Vaibhav Joshi 
 To: excel-macros@googlegroups.com 
 Sent: Tuesday, December 23, 2014 10:44 AM
 Subject: Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row 
of second sheet based on cell value
   
Glad this helped you.Cheers!!On Dec 23, 2014 9:10 PM, "bobengler" 
 wrote:



Thank you for your time and expertise. It's good to know there is good support 
out there.
Bob Engler

  From: Ashish Kumar 
 To: Vaibhav Joshi  
Cc: "excel-macros@googlegroups.com"  
 Sent: Friday, December 19, 2014 10:35 PM
 Subject: Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row 
of second sheet based on cell value
   
Vaibhav Bhai,
Superb..!!

RegardsAshish

-- 
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 a topic in the Google 
Groups "MS EXCEL AND VBA MACROS" group.
To unsubscribe from this topic, visit 
https://groups.google.com/d/topic/excel-macros/IHBU7WGs4LA/unsubscribe.
To unsubscribe from this group and all its topics, 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.
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 http://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 @ 
ht

Re: $$Excel-Macros$$ Re: How can I match two different data, where only a reference number and amount are common.

[Faisal Pk]

Hi,

It can be achieved through pivot table by changing one source amount to
negative and another to positive.

Attached is a sample which may help you to understand.

Regards,
Faisal PK

On Mon, Mar 30, 2015 at 3:58 PM, Sandeep Chhajer 
wrote:

> Hi,
>
> You can use VLOOKUP. For more how to use VLOOKUP check..Microsoft office
> help.
>
> Sandeep.
>
> Sent from my BlackBerry 10 smartphone.
>   *From: *Saddam Ali
> *Sent: *Monday 30 March 2015 18:19
> *To: *excel-macros@googlegroups.com
> *Reply To: *excel-macros@googlegroups.com
> *Subject: *$$Excel-Macros$$ Re: How can I match two different data, where
> only a reference number and amount are common.
> ‎
>
> Kindly find the attached excel work book and possibly assist. i need to
> match all the data of the first sheet to the outstanding in the second sheet
> ‎
> On Monday, March 30, 2015 at 12:37:28 PM UTC+3, Saddam Ali wrote:
>>
>> My name is Baricha, from Kenya. I work in a bank and so i cannot upload
>> the data because Its sensitive and also a  breach of contract.
>>
>>  I normally receive data from two different sources, and i am required to
>> match the two data, the only common features between the 2 data, are the
>> amount and a reference number. this is what i normally use to match up the
>> two data. i cannot do VLOOKUP because the reference numbers which are
>> client specific re-occur and so instead of matching a reference number with
>> the same matching amount, it picks the reference number yes, but with the
>> amount of the very first similar reference number. My question is, is it
>> possible for me to match the two datas with both the EXACT reference number
>> and amount even if the reference number re-occurs. I match manually and its
>> very tiresome.
>>
>> Please assist.
>>
>  --
> 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 http://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 http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Best Regards
Faisal PK

-- 
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 copyr

$$Excel-Macros$$ Re: Unable to Manipulate tab delimited data

[Bill Q]

Thanks, but I must be doing something wrong - becuase it isn;t working for 
me. 

On Sunday, 29 March 2015 17:37:58 UTC-4, Bill Q wrote:
>
> Attached is a very small sample of a much larger data set. I need to 
> separate the data - in this case in 3 different and separate columns. For 
> whatever reason there is what looks like a tilde between the numbers. I 
> cannot seem to put in the right delimiter in order to have it separated 
> properly.
>
> Need help to what appears to be a simple problem. 
>
> Thanks.  
>

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Hiring-Facets Developer (Application Support) @Denver,CO [Please send resumes to r...@technotalent.com]

[Rene Mickey]

Hi,

Hope you are doing great...



I come across your profile on Dice Please let me know your interest for
below position along with your updated resume


(If you are not available please refer this Position)


 [Please send resumes to r...@technotalent.com]

*Position*

*Technology:* *Facets Developer (Application Support)*

*Location  : Denver,CO*

*Duration  : 1+ Year *

*Type Of position:C2C *



*Responsibilities:*

Troubleshooting Urgent (oncall) issues for both application & batches of
Facets application. Provide support to Facets application and batches
through incidents, tasks and change controls. Perform root cause analysis,
document action plans, and provide feedback. Perform 24*7 On-Call
Responsibility on weekly rotation basis. Creating Change Controls &
Coordination for deployments of various components. Support Maintenance
weekend activity every month - Environment validation. Work directly with
different teams like SAs, Networking, DBAS, for timely resolution of
incidents. Escalating production issues in timely manner to incident
management team for co-ordination

Customer facing communication via voice, email, and related ticketing/work
request systems.



*Professional Experience:*

Bachelor's degree in or Information Systems or equivalent.2 – 5+ years
related work experience. Need to have good understanding of Healthcare
Payor Domain and able to relate with Facets functionalities. Should have
strong understanding on Facets data model and how the data flow between end
user to backend tables. Highly capable and well versed in standard
troubleshooting skills. Demonstrated ability to work independently and
troubleshoot problems with application Support newly joined resources when
necessary. Proficient verbal and written communication skills in English.VB
scripting, XML & SQL Query, Workload AE,.Net and ASP technical support, IIS
and Web Application experience, CAE front-end experience.



*Please reply me with below details along with your resume..*

Name



Current Location



Home Phone & Cell Phone



E-mail address

Work Authorization



Current Employer



Total yrs of IT exp



Skills



Current Salary



Expected Salary



Relocation



Availability/Notice period



Preferable time for discussion



Any bond/commitments with current employer



Reason of looking out for change



Any vacation plans in first year









Regards,
*Rene*
TechnoTalent Software Solutions,707 Alexander Rd.208.
Princeton, New Jersey 08540.
*Email: **r...@technotalent.com* 

*D: 732-444-3663*
URL: www.technotalent.com

Note: This email is not intended to be a solicitation. It is targeted to
recruiting and consulting professionals. If you have received this in
error, please accept our apologies and to be removed from our mailing list
reply with "UNSUBSCRIBE" in the subject heading and your email address in
the body.

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: How can I match two different data, where only a reference number and amount are common.

[Sandeep Chhajer]

  Hi,You can use VLOOKUP. For more how to use VLOOKUP check..Microsoft office help.Sandeep.Sent from my BlackBerry 10 smartphone.From: Saddam AliSent: Monday 30 March 2015 18:19To: excel-macros@googlegroups.comReply To: excel-macros@googlegroups.comSubject: $$Excel-Macros$$ Re: How can I match two different data, where only a reference number and amount are common.‎Kindly find the attached excel work book and possibly assist. i need to match all the data of the first sheet to the outstanding in the second sheet‎On Monday, March 30, 2015 at 12:37:28 PM UTC+3, Saddam Ali wrote:My name is Baricha, from Kenya. I work in a bank and so i cannot upload the data because Its sensitive and also a  breach of contract. I normally receive data from two different sources, and i am required to match the two data, the only common features between the 2 data, are the amount and a reference number. this is what i normally use to match up the two data. i cannot do VLOOKUP because the reference numbers which are client specific re-occur and so instead of matching a reference number with the same matching amount, it picks the reference number yes, but with the amount of the very first similar reference number. My question is, is it possible for me to match the two datas with both the EXACT reference number and amount even if the reference number re-occurs. I match manually and its very tiresome.Please assist.



-- 
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 http://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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: How can I match two different data, where only a reference number and amount are common.

[Saddam Ali]

sorry i forgot to attach, this is the attachement

On Monday, March 30, 2015 at 3:49:00 PM UTC+3, Saddam Ali wrote:
>
> Kindly find the attached excel work book and possibly assist. i need to 
> match all the data of the first sheet to the outstanding in the second sheet
>
> On Monday, March 30, 2015 at 12:37:28 PM UTC+3, Saddam Ali wrote:
>>
>> My name is Baricha, from Kenya. I work in a bank and so i cannot upload 
>> the data because Its sensitive and also a  breach of contract.
>>
>>  I normally receive data from two different sources, and i am required to 
>> match the two data, the only common features between the 2 data, are the 
>> amount and a reference number. this is what i normally use to match up the 
>> two data. i cannot do VLOOKUP because the reference numbers which are 
>> client specific re-occur and so instead of matching a reference number with 
>> the same matching amount, it picks the reference number yes, but with the 
>> amount of the very first similar reference number. My question is, is it 
>> possible for me to match the two datas with both the EXACT reference number 
>> and amount even if the reference number re-occurs. I match manually and its 
>> very tiresome.
>>
>> Please assist.
>>
>

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


sample work sheet.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Re: How can I match two different data, where only a reference number and amount are common.

[Saddam Ali]

Kindly find the attached excel work book and possibly assist. i need to 
match all the data of the first sheet to the outstanding in the second sheet

On Monday, March 30, 2015 at 12:37:28 PM UTC+3, Saddam Ali wrote:
>
> My name is Baricha, from Kenya. I work in a bank and so i cannot upload 
> the data because Its sensitive and also a  breach of contract.
>
>  I normally receive data from two different sources, and i am required to 
> match the two data, the only common features between the 2 data, are the 
> amount and a reference number. this is what i normally use to match up the 
> two data. i cannot do VLOOKUP because the reference numbers which are 
> client specific re-occur and so instead of matching a reference number with 
> the same matching amount, it picks the reference number yes, but with the 
> amount of the very first similar reference number. My question is, is it 
> possible for me to match the two datas with both the EXACT reference number 
> and amount even if the reference number re-occurs. I match manually and its 
> very tiresome.
>
> Please assist.
>

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: How can I match two different data, where only a reference number and amount are common.

[Maciej Piotrowicz]

Hello

In both sources add column where you join ref nb and amount like=A1&b1 
(where for example in A is ref nb and B ammount) . Then you can use vlookup 
cos the possibility, I suppose, to non unique values are very small. Do not 
matter what is the result of given formula, the only witch matters is 
uniqueness.

Regards

W dniu poniedziałek, 30 marca 2015 11:37:28 UTC+2 użytkownik Saddam Ali 
napisał:
>
> My name is Baricha, from Kenya. I work in a bank and so i cannot upload 
> the data because Its sensitive and also a  breach of contract.
>
>  I normally receive data from two different sources, and i am required to 
> match the two data, the only common features between the 2 data, are the 
> amount and a reference number. this is what i normally use to match up the 
> two data. i cannot do VLOOKUP because the reference numbers which are 
> client specific re-occur and so instead of matching a reference number with 
> the same matching amount, it picks the reference number yes, but with the 
> amount of the very first similar reference number. My question is, is it 
> possible for me to match the two datas with both the EXACT reference number 
> and amount even if the reference number re-occurs. I match manually and its 
> very tiresome.
>
> Please assist.
>

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

RE: $$Excel-Macros$$ Begin a Group in vba custom toolbar

[dwbowyer15]

Many thanks for the input

 

  _  

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Vaibhav Joshi
Sent: 30 March 2015 09:21
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Begin a Group in vba custom toolbar

 

Check this for help..

 

http://www.vbaexpress.com/kb/getarticle.php?kb_id=427

 

 

 

 
 

 

On Sun, Mar 22, 2015 at 4:33 PM, Don Bowyer  wrote:

In Excel 2003 on Windows 7 I have created a custom toolbar using VBA.

The toolbar has about 7 buttons each of which activates a separate macro.

This is the code I use:-

Sub CreateMenubar()

Dim iCtr As Long

Dim MacNames As Variant
Dim CapNamess As Variant
Dim TipText As Variant

Call RemoveMenubar

MacNames = Array("MyShutdown", "MyScroll", "Run", "Move1", "CopyEntry",
"PasteEntry", "DeleteRow", "Mark", "DeleteSheet")

CapNamess = Array("Close", "Scroll", "Run", "Move", "Copy", "Paste",
"Delete Row", "Mark", "Delete Sheet")

'TipText = Array("AAA tip", "BBB tip")

Dim MyMenuBar As CommandBar
Dim LastMenu As CommandBarButton

Set MyMenuBar = CommandBars.ActiveMenuBar
Set LastMenu = MyMenuBar.Controls(MyMenuBar.Controls.Count)
LastMenu.BeginGroup = True


With Application.CommandBars.Add
.Name = ToolBarName
.Protection = msoBarNoProtection
.Visible = True
.Position = msoBarTop
.RowIndex = 3
.Left = 800
 
For iCtr = LBound(MacNames) To UBound(MacNames)
With .Controls.Add(Type:=msoControlButton)
.OnAction = "'" & ThisWorkbook.Name & "'!" & MacNames(iCtr)
.Caption = CapNamess(iCtr)
.Style = msoButtonCaption
.FaceId = 71 + iCtr
'.TooltipText = TipText(iCtr)
End With
Next iCtr
End With

The toolbar generates OK when I load the programme but I need to add "begin
a Group" breaks between buttons.

I have tried using the example given in VBA help (as shown in bold italics
within the code above), but although it runs, no "Groups" or spacing breaks
are created.

What am I doing wrong? any help appreciated.

-- 
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 http://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 a topic in the
Google Groups "MS EXCEL AND VBA MACROS" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/excel-macros/lf3-bx7oYSg/unsubscribe.
To unsubscribe from this group and all its topics, 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.
For more options, visit https://groups.google.com/d/optout.



---
This email has been checked for viruses by Avast antivirus software.
http://www.avast.com

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:O

$$Excel-Macros$$ How can I match two different data, where only a reference number and amount are common.

[Saddam Ali]

My name is Baricha, from Kenya. I work in a bank and so i cannot upload the 
data because Its sensitive and also a  breach of contract.

 I normally receive data from two different sources, and i am required to 
match the two data, the only common features between the 2 data, are the 
amount and a reference number. this is what i normally use to match up the 
two data. i cannot do VLOOKUP because the reference numbers which are 
client specific re-occur and so instead of matching a reference number with 
the same matching amount, it picks the reference number yes, but with the 
amount of the very first similar reference number. My question is, is it 
possible for me to match the two datas with both the EXACT reference number 
and amount even if the reference number re-occurs. I match manually and its 
very tiresome.

Please assist.

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Begin a Group in vba custom toolbar

[Vaibhav Joshi]

Check this for help..

http://www.vbaexpress.com/kb/getarticle.php?kb_id=427




On Sun, Mar 22, 2015 at 4:33 PM, Don Bowyer  wrote:

> In Excel 2003 on Windows 7 I have created a custom toolbar using VBA.
>
> The toolbar has about 7 buttons each of which activates a separate macro.
>
> This is the code I use:-
>
> Sub CreateMenubar()
>
> Dim iCtr As Long
>
> Dim MacNames As Variant
> Dim CapNamess As Variant
> Dim TipText As Variant
>
> Call RemoveMenubar
>
> MacNames = Array("MyShutdown", "MyScroll", "Run", "Move1",
> "CopyEntry", "PasteEntry", "DeleteRow", "Mark", "DeleteSheet")
>
> CapNamess = Array("Close", "Scroll", "Run", "Move", "Copy", "Paste",
> "Delete Row", "Mark", "Delete Sheet")
>
> 'TipText = Array("AAA tip", "BBB tip")
>
>
> *Dim MyMenuBar As CommandBarDim LastMenu As CommandBarButton*
>
>
>
> *Set MyMenuBar = CommandBars.ActiveMenuBarSet LastMenu =
> MyMenuBar.Controls(MyMenuBar.Controls.Count)LastMenu.BeginGroup = True*
>
>
> With Application.CommandBars.Add
> .Name = ToolBarName
> .Protection = msoBarNoProtection
> .Visible = True
> .Position = msoBarTop
> .RowIndex = 3
> .Left = 800
>
> For iCtr = LBound(MacNames) To UBound(MacNames)
> With .Controls.Add(Type:=msoControlButton)
> .OnAction = "'" & ThisWorkbook.Name & "'!" & MacNames(iCtr)
> .Caption = CapNamess(iCtr)
> .Style = msoButtonCaption
> .FaceId = 71 + iCtr
> '.TooltipText = TipText(iCtr)
> End With
> Next iCtr
> End With
>
> The toolbar generates OK when I load the programme but I need to add
> "begin a Group" breaks between buttons.
>
> I have tried using the example given in VBA help (as shown in bold italics
> within the code above), but although it runs, no "Groups" or spacing breaks
> are created.
>
> What am I doing wrong? any help appreciated.
>
> --
> 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 http://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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Retrieve data thru VBA Macro..

[Vaibhav Joshi]

Hi

There are many ways to do it, few are:

http://excel.tips.net/T003005_Condensing_Multiple_Worksheets_Into_One.html

http://support.microsoft.com/en-us/kb/214270

http://www.bighungrygeek.com/merge-worksheets-in-excel/


http://www.rondebruin.nl/win/addins/rdbmerge.htm

Cheers!!


On Mon, Mar 30, 2015 at 11:16 AM, மதுர மதுர  wrote:

> Good Day Friends..
>
> I need to retrieve certain set of data from multiple worksheets and
> workbooks in a single worksheet. I appreciate if anyone help to set VBA
> macros..
>
>
> Thanks & Regards,
> Jabar
>
>
>
>
>  --
> 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 http://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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Copy Data from another application to excel.

[Vaibhav Joshi]

hi

without any application in front coding can not be set for 3rd party app..


On Fri, Mar 27, 2015 at 2:17 AM, Avinash  wrote:

> Hi Experts,
>
> i want a macro which can copy data from another application to excel.
>
> below is the code which i am trying to use. i dont have any workbook to
> explain this example. just a simple logic copy data from other application
> and paste in to excel then again switch to that application then paste data
> in to the excel after the first row. (row by row copy paste macro)
>
> Option Explicit
> Declare Function GetAsyncKeyState Lib "user32" (ByVal vKey As Long) As
> Integer()
>
>
> Const VK_F6 = &H75
> Const VK_ESC = &H1B
>  Const VK_CONTROL = &H11 ' COntrol
>  Const VK_C = &H43 ' c
>
>  Const VK_TAB = &H9 ' Tab
> Const VK_MENU = &H12 'menu
> Const VK_V = &H56 ' v key
>
>
>
>
> Sub Scannings()
> Dim lngRow As Long, str As String
>
> lngRow = Selection.Row
> str = Cells(lngRow, 1) & vbTab & Cells(lngRow, 2) & vbTab & _
> Format(Cells(lngRow, 3), "dd - mmm - ")
>
> MsgBox "Click OK, then click the First Name box on the external
> application, then press F6 on the keyboard"
> WaitAndSend str, VK_F6, VK_ESC
> WaitAndSend VK_MENU, VK_TAB
> WaitAndSend VK_CONTROL, VK_C
> WaitAndSend VK_MENU, VK_TAB
> WaitAndSend str, VK_CONTROL, VK_V
> End Sub
>
> Sub WaitAndSend(SendString As String, ExecuteKey As Long, CancelKey As
> Long)
> Do
> DoEvents
> If GetAsyncKeyState(CancelKey) <> 0 Then Exit Do
> If GetAsyncKeyState(ExecuteKey) <> 0 Then
> SendKeys SendString, True
> Exit Do
> End If
> Loop
> End Sub
>
> Please help me everyday i am spending 5-6 hrs to do this job (alt + tab,
> copy one row, paste in to excel, again alt tab, copy second row, alt tab,
> paste in to excel row by row)
>
>
> Thanks in Advanced.
>
> Regards,
> Avinash
>
>
>  --
> 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 http://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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Do you want to marry? View Similar Profiles.

[Vaibhav Joshi]

Hi

This is pertaining to Group "Important Jobs & Walkin Updates", i haven't
recd any such emails from Excel VBA Group..



On Mon, Mar 30, 2015 at 1:09 PM, Prabhu Pinky 
wrote:

> Why this kind of mails in this group???
> On 30-Mar-2015 1:00 PM, "Sajini"  wrote:
>
>> * Do you want to marry? View Similar Profiles.
>> *
>>
>>  
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Important Jobs & Walkin Updates" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to aamanimarorigins+unsubscr...@googlegroups.com.
>> 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 http://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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Do you want to marry? View Similar Profiles.

[Prabhu Pinky]

Why this kind of mails in this group???
On 30-Mar-2015 1:00 PM, "Sajini"  wrote:

> * Do you want to marry? View Similar Profiles.
> *
>
>  
>
> --
> You received this message because you are subscribed to the Google Groups
> "Important Jobs & Walkin Updates" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to aamanimarorigins+unsubscr...@googlegroups.com.
> 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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.