date:20131107

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

2013-11-07 Thread Sandeep Kumar Baranwal

Hi Basole

Though not observing the literal difference between recordset and
querytables, I wanted to see if the same requirement be worked out using
querytables in VBA code.
In Plan1 (Sheet1) you made use of ADODB.Recordset. I would like to make use
of querytables(index)

Kindly refer to a piece of vba code (as an hypothetical example) and the
link below:

Dim qt As QueryTable
sqlstring = "select 96Sales.totals from 96Sales where profit < 5"
connstring = _
"ODBC;DSN=96SalesData;UID=Rep21;PWD=NUyHwYQI;Database=96Sales"
With ActiveSheet.QueryTables.Add(Connection:=connstring, _
Destination:=Range("B1"), Sql:=sqlstring)
.Refresh
End With



http://msdn.microsoft.com/en-us/library/office/aa174289(v=office.11).aspx

For further details on query tables , please refer :

http://msdn.microsoft.com/en-us/library/office/aa174288(v=office.11).aspx



Thanks & regards,
*Sandeep Kumar Baranwal*
Assistant Manager
Credit Risk Methodology & Wholesale Basel,Genpact
Gurgaon
India
Mob:-+91-8588802543



On Fri, Nov 8, 2013 at 8:10 AM, Basole  wrote:

> Dear Sanddep, thank you for your kindness!
> Sorry, but what is the difference between recordset and querry tables?
>
>
>
>
>
>
> Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar
> Baranwal escreveu:
>>
>> Hi
>>
>> Kindly note that sql.request is functional in MS Excel 2007 but not in MS
>> Excel 2010. Could you please let me know any VBA code that would be a
>> substitute for sql.request.
>> If yes, Please let me know with the help of an example.
>> We use sql.request to transfer data from MS Access to MS Excel in version
>> 2007
>>
>>
>> Thanks & regards,
>> *Sandeep Kumar Baranwal*
>> Business Analyst
>> Credit Risk Methodology & Wholesale Basel,Genpact
>> Gurgaon
>> India
>> Mob:-+91-8588802543
>>
>>   --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> 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/groups/opt_out.
>

-- 
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/groups/opt_out.

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

2013-11-07 Thread Rupesh Patil

Hi Expert.

How generate PDF file using VBA.

Thanks


On Fri, Nov 8, 2013 at 8:10 AM, Basole  wrote:

> Dear Sanddep, thank you for your kindness!
> Sorry, but what is the difference between recordset and querry tables?
>
>
>
>
>
>
> Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar
> Baranwal escreveu:
>>
>> Hi
>>
>> Kindly note that sql.request is functional in MS Excel 2007 but not in MS
>> Excel 2010. Could you please let me know any VBA code that would be a
>> substitute for sql.request.
>> If yes, Please let me know with the help of an example.
>> We use sql.request to transfer data from MS Access to MS Excel in version
>> 2007
>>
>>
>> Thanks & regards,
>> *Sandeep Kumar Baranwal*
>> Business Analyst
>> Credit Risk Methodology & Wholesale Basel,Genpact
>> Gurgaon
>> India
>> Mob:-+91-8588802543
>>
>>   --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> 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/groups/opt_out.
>



-- 
Thanks and Regards, Rp.

-- 
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/groups/opt_out.

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

2013-11-07 Thread Basole

Dear Sanddep, thank you for your kindness!
Sorry, but what is the difference between recordset and querry tables? 






Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar 
Baranwal escreveu:
>
> Hi
>
> Kindly note that sql.request is functional in MS Excel 2007 but not in MS 
> Excel 2010. Could you please let me know any VBA code that would be a 
> substitute for sql.request. 
> If yes, Please let me know with the help of an example.
> We use sql.request to transfer data from MS Access to MS Excel in version 
> 2007
>
>
> Thanks & regards,
> *Sandeep Kumar Baranwal*
> Business Analyst
> Credit Risk Methodology & Wholesale Basel,Genpact
> Gurgaon
> India
> Mob:-+91-8588802543
>
>  

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
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/groups/opt_out.

Re: $$Excel-Macros$$ Need PDF to Excel Converter.....

2013-11-07 Thread Indrajit $nai

Ravinder, you are the best, you always help me out from the critical
situations. Hats off to you!!! and it's really amazing.

If I need any further clarification / modification, definitely I'll get
back to you, hope you wouldn't mind. :)


Thanks & Regards,
Indrajit


On Thu, Nov 7, 2013 at 4:00 AM, Ravinder wrote:

> PFA.. I have copied PDF data in second sheet and then click on button.
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* Thursday, November 07, 2013 1:01 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Need PDF to Excel Converter.
>
>
>
> Hi Experts,
>
>
>
> Need help to convert PDF to Excel, like the attached file.
>
>
>
> Thanks in advance.
>
>
>
> --
> Indrajit
>
> Disclaimer:
> This electronic message and any files transmitted with it are confidential
> and intended solely for the use of the individual or entity to whom they
> are addressed. If you are not the intended recipient you are hereby
> notified that any disclosure, copying, distribution or taking any action in
> reliance on the contents of this information is strictly prohibited and may
> be unlawful.
>
> --
> 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/groups/opt_out.
>
> --
> 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/groups/opt_out.
>

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

Re: $$Excel-Macros$$ Re: Complicated Formula (automatic add back)

2013-11-07 Thread itware2008

Hello Amar,

Perhaps this is what you want. Otherwise, please explain your goal with 
more detail.

Best regards,


Terça-feira, 8 de Outubro de 2013 13:18:32 UTC+1, amar takale escreveu:
>
> Dear Ravinderji,
>
> Thanks very much for great guidance for UDF VBA coding,I change little bit 
> in excel,pls see it & i think it is useful for me further work.
> After your guidance I am start work in excel but there are very hard task 
> in future work bcos after currently solution I want specific recipient data 
> as date wise when I Select recipient name click specific date  then all 
> transaction that  recipient (Received &  distributed & balance qty) will 
> show.I will work hardly on that task but if not solution then i will get 
> back to you sir.
>
> Regards
> Amar
>
>
> On Tue, Oct 8, 2013 at 4:29 PM, Ravinder 
> > wrote:
>
>> I sent solution is it not working?
>>
>> ** **
>>
>> *From:* excel-...@googlegroups.com  [mailto:
>> excel-...@googlegroups.com ] *On Behalf Of *amar takale
>> *Sent:* Tuesday, October 08, 2013 4:26 PM
>> *To:* excel-...@googlegroups.com 
>> *Subject:* Re: $$Excel-Macros$$ Re: Complicated Formula (automatic add 
>> back)
>>
>> ** **
>>
>> Dear any solution pls
>>
>> ** **
>>
>> On Mon, Oct 7, 2013 at 6:13 PM, amar takale 
>> > 
>> wrote:
>>
>> Dear sir
>>
>> Thanks for reply first.I attached example file with detailed.pls see it.*
>> ***
>>
>> Regards
>>
>> Amar 
>>
>> ** **
>>
>> On Mon, Oct 7, 2013 at 5:05 PM, Rs. > 
>> wrote:
>>
>> Amar,
>>
>> ** **
>>
>> You want to add the Balance Qty with your Received Qty (ie in Cell F7) 
>> But where you key-in (on which cell) your second receipt for "A"??
>>
>> ** **
>>
>> Regards
>>
>> ** **
>>
>> Rs.
>>
>> -- 
>> 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 http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>> ** **
>>
>> ** **
>>
>> -- 
>> 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 http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>  
>> -- 
>> 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 
>> measu

$$Excel-Macros$$ Re: total Fridays in a range

2013-11-07 Thread itware2008

Please take a look at the enclosed file.

You are able to select from the drop-down box the weekday you are looking 
for, below you find the number of occurrences for the weekday you had 
chosen.

Cheers.


Terça-feira, 1 de Outubro de 2013 15:18:15 UTC+1, asd...@gmail.com escreveu:
>
> vba returns total Fridays in A2:A6. If A2:A6 all are Fridays. The value 
> should be 5.
>

-- 
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/groups/opt_out.


weekdays.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ loop to copy items one by one

2013-11-07 Thread Hilary Lomotey

thanks for looking into this for me very grateful


On Thu, Nov 7, 2013 at 6:15 AM, Ravinder wrote:

>  [image: Boxbe]  This message is eligible
> for Automatic Cleanup! (ravinderexcelgr...@gmail.com) Add cleanup 
> rule|
>  More
> info
>
> Pfa, I think you r looking for this….
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Hilary Lomotey
> *Sent:* Thursday, November 07, 2013 12:39 AM
> *To:* excel-macros
> *Subject:* $$Excel-Macros$$ loop to copy items one by one
>
>
>
> Hello Experts,
>
>
>
> i need assistance with a loop or any macro to help run a report. ie
>
>
>
> in the sheet attached i have a list of names, if i choose a name from the
> list and run the adv filter it gives me the result i want and then i will
> run the report and get it exported to the database. i want this process
> automated, ie a macro to change the name one after the other, then i will
> call the advanced filter and call again the macro to copy to database. i
> need assistance with the macro to change the name one after the other. pls
> assist. 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/groups/opt_out.
>
> --
> 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/groups/opt_out.
>
>

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

Re: $$Excel-Macros$$ How to retrieve multiple or single data from a single column like (A1) to different required columns like (D1, D2, D3 .....)

2013-11-07 Thread MRafique Ujjan

Dear Sir, now I have attached a worksheet which shows all the allowances 
with their special code too. Please fix my problem & sorry for 
inconvenience.

On Thursday, November 7, 2013 3:13:35 PM UTC+5, ravinder negi wrote:
>
> Actually there are lots of allowance and every employ getting different 
> allowances, pls provide the maximum heading of allowances then I can fix 
> it…..
>
>  
>
> *From:* excel-...@googlegroups.com  [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *MRafique Ujjan
> *Sent:* Thursday, November 07, 2013 3:29 PM
> *To:* excel-...@googlegroups.com 
> *Cc:* 'Soum'; Soum
> *Subject:* Re: $$Excel-Macros$$ How to retrieve multiple or single data 
> from a single column like (A1) to different required columns like (D1, D2, 
> D3 .)
>
>  
>
> Dear Ravinder Sory there is only one problem in my worksheet which i have 
> mentioned please help me & fix that problem for me as you have done before. 
>
> Thanks in advance
>
> On Wednesday, November 6, 2013 5:13:27 PM UTC+5, ravinder negi wrote:
>
> Pls try this one…
>
>  
>
> *From:* excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] *On 
> Behalf Of *MRafique Ujjan
> *Sent:* Wednesday, November 06, 2013 3:45 PM
> *To:* excel-...@googlegroups.com
> *Cc:* Soum
> *Subject:* Re: $$Excel-Macros$$ How to retrieve multiple or single data 
> from a single column like (A1) to different required columns like (D1, D2, 
> D3 .)
>
>  
>
> Dear Ravinder negi, you are right, in certain pay slips there is some 
> difference like S#:87 is payslip of a Naib Qasid where on allowance named 
> "Washing Allowance" is extra then usual Allowances. So i am sorry that I 
> could not mention it in my query, so it is also a problem sir, please do 
> some trick & help me to get rid from this problem & I hope you people can 
> do this. 
>
> Thanks for taking time & asked me about this problem, Please do ask me if 
> there is any other confusion.
>  
>
> On Wednesday, November 6, 2013 11:58:39 AM UTC+5, ravinder negi wrote:
>
> PFA, If its ok.. there is only one problem with below data, its having 
> extra row(yellow color)
>
>  
>
> S#:87 P Sec:001  Month:September 
> 2013
>
>   TT6048 -A.D.O.E(M) SUJAWAL
>
> Pers #: 10342551  Buckle: Min:  Edu/Liter & N-For Edu 
> Dep
>
> Name:   ABDUL RAUF MEMON  NTN:
>
> Dsg.:  NAIB QASID GPF #:
>
> CNIC No.4140822125719 Old #:
>
> GPF Interest Applied
>
>02  Active PermanentTT6048-
>
>PAYS AND ALLOWANCES:
>
> 0001-Basic Pay 9,490.00
>
> 1000-House Rent Allowance910.00
>
> 1210-Convey Allowance  20051,700.00
>
> 1300-Medical Allowance 1,000.00
>
> 1567-Washing Allowance30.00
>
> 1948-Adhoc Allowance 2010@ 50% 2,767.00
>
> 1970-Adhoc Relief Allow 2011 830.00
>
> 2118-Adhoc Relief Allow (2012) 1,898.00
>
> 2149-Adhoc Allowance 2013 @15% 
> 1,423.00
>
>   Gross Pay and Allowances 
> 20,048.00
>
>  
>
> *From:* excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] *On 
> Behalf Of *M.Rafique MRU
> *Sent:* Wednesday, November 06, 2013 10:11 AM
> *To:* excel-macros
> *Subject:* $$Excel-Macros$$ How to retrieve multiple or single data from 
> a single column like (A1) to different required columns like (D1, D2, D3 
> .)
>
>  
>
> Hi Dear Excel Gurus,
>
> Once again I am having a huge problem regarding data entry of of employees 
> pay roll, i have attached a workbook in which sheet PayRoll contains all 
> the data but in merged column or single column & in vertical column like A1 
> ( in which Personal No. & Name of employee are written in same column) now 
> i want Personal No. in one column & Name of Employee in another column, I 
> have labelled my sheet to clear my requirement and I have also created 
> another worksheet named "Data" where is a required format for retrieval of 
> data from PayRoll.
>
> Hope, I will receive same response from you experts as before, thanks you 
> in advance. 
>
> 
>
> Muhammad Rafique Ujjan
>
> -- 
> 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

RE: $$Excel-Macros$$ How to retrieve multiple or single data from a single column like (A1) to different required columns like (D1, D2, D3 .....)

2013-11-07 Thread Ravinder

Actually there are lots of allowance and every employ getting different
allowances, pls provide the maximum heading of allowances then I can fix
it...

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of MRafique Ujjan
Sent: Thursday, November 07, 2013 3:29 PM
To: excel-macros@googlegroups.com
Cc: 'Soum'; Soum
Subject: Re: $$Excel-Macros$$ How to retrieve multiple or single data from a
single column like (A1) to different required columns like (D1, D2, D3
.)

Dear Ravinder Sory there is only one problem in my worksheet which i have
mentioned please help me & fix that problem for me as you have done before. 

Thanks in advance

On Wednesday, November 6, 2013 5:13:27 PM UTC+5, ravinder negi wrote:

Pls try this one.

From: excel-...@googlegroups.com 
[mailto:excel-...@googlegroups.com  ] On Behalf Of MRafique
Ujjan
Sent: Wednesday, November 06, 2013 3:45 PM
To: excel-...@googlegroups.com  
Cc: Soum
Subject: Re: $$Excel-Macros$$ How to retrieve multiple or single data from a
single column like (A1) to different required columns like (D1, D2, D3
.)

Dear Ravinder negi, you are right, in certain pay slips there is some
difference like S#:87 is payslip of a Naib Qasid where on allowance named
"Washing Allowance" is extra then usual Allowances. So i am sorry that I
could not mention it in my query, so it is also a problem sir, please do
some trick & help me to get rid from this problem & I hope you people can do
this. 

Thanks for taking time & asked me about this problem, Please do ask me if
there is any other confusion.

On Wednesday, November 6, 2013 11:58:39 AM UTC+5, ravinder negi wrote:

PFA, If its ok.. there is only one problem with below data, its having extra
row(yellow color)

S#:87 P Sec:001  Month:September
2013

  TT6048 -A.D.O.E(M) SUJAWAL

Pers #: 10342551  Buckle: Min:  Edu/Liter & N-For Edu
Dep

Name:   ABDUL RAUF MEMON  NTN:

Dsg.:  NAIB QASID GPF #:

CNIC No.4140822125719 Old #:

GPF Interest Applied

   02  Active PermanentTT6048-

   PAYS AND ALLOWANCES:

0001-Basic Pay 9,490.00

1000-House Rent Allowance910.00

1210-Convey Allowance  20051,700.00

1300-Medical Allowance 1,000.00

1567-Washing Allowance30.00

1948-Adhoc Allowance 2010@ 50% 2,767.00

1970-Adhoc Relief Allow 2011 830.00

2118-Adhoc Relief Allow (2012) 1,898.00

2149-Adhoc Allowance 2013 @15% 1,423.00

  Gross Pay and Allowances 20,048.00

From: excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] On
Behalf Of M.Rafique MRU
Sent: Wednesday, November 06, 2013 10:11 AM
To: excel-macros
Subject: $$Excel-Macros$$ How to retrieve multiple or single data from a
single column like (A1) to different required columns like (D1, D2, D3
.)

Hi Dear Excel Gurus,

Once again I am having a huge problem regarding data entry of of employees
pay roll, i have attached a workbook in which sheet PayRoll contains all the
data but in merged column or single column & in vertical column like A1 ( in
which Personal No. & Name of employee are written in same column) now i want
Personal No. in one column & Name of Employee in another column, I have
labelled my sheet to clear my requirement and I have also created another
worksheet named "Data" where is a required format for retrieval of data from
PayRoll.

Hope, I will receive same response from you experts as before, thanks you in
advance. 

Muhammad Rafique Ujjan

-- 
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" g

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

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

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

Re: $$Excel-Macros$$ Need PDF to Excel Converter.....

Re: $$Excel-Macros$$ Re: Complicated Formula (automatic add back)

$$Excel-Macros$$ Re: total Fridays in a range

Re: $$Excel-Macros$$ loop to copy items one by one

Re: $$Excel-Macros$$ How to retrieve multiple or single data from a single column like (A1) to different required columns like (D1, D2, D3 .....)

RE: $$Excel-Macros$$ How to retrieve multiple or single data from a single column like (A1) to different required columns like (D1, D2, D3 .....)

9 matches

Site Navigation

Mail list logo

Footer information