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 <javascript:> [mailto: > excel-...@googlegroups.com <javascript:>] *On Behalf Of *MRafique Ujjan > *Sent:* Thursday, November 07, 2013 3:29 PM > *To:* excel-...@googlegroups.com <javascript:> > *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 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. > 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.
