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 <javascript:> [mailto:excel-...@googlegroups.com <javascript:> ] On Behalf Of MRafique Ujjan Sent: Wednesday, November 06, 2013 3:45 PM To: excel-...@googlegroups.com <javascript:> 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 Permanent TT6048 - PAYS AND ALLOWANCES: 0001-Basic Pay 9,490.00 1000-House Rent Allowance 910.00 1210-Convey Allowance 2005 1,700.00 1300-Medical Allowance 1,000.00 1567-Washing Allowance 30.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" 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 <javascript:> . To post to this group, send email to excel-...@googlegroups.com <javascript:> . 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/groups/opt_out.
