$$Excel-Macros$$ Re: How to Get Data of 527 employees from One Excel Sheet to another Sheet on given proforma

2014-11-05 Thread MRafique Ujjan
Dear Anil Kumar you have attached another workbook in my post. Please go through my excel book and your help will be highly appreciated. Thanks On Tuesday, November 4, 2014 4:20:20 PM UTC+5, MRafique Ujjan wrote: > > Dear Excel Experts! > > Hi, > > Once again I need your help

$$Excel-Macros$$ Re: How to Get Data of 527 employees from One Excel Sheet to another Sheet on given proforma

2014-11-07 Thread MRafique Ujjan
Hi Dear Excel Experts! I am still looking for solution, plz help me to get me out of problem. Thanks in advance On Tuesday, November 4, 2014 4:20:20 PM UTC+5, MRafique Ujjan wrote: > > Dear Excel Experts! > > Hi, > > Once again I need your help regarding subject matter,

$$Excel-Macros$$ Re: Need to generate a query form to retrieve the required data by entering only personal ID out of many records stored in a sheet as raw data

2014-11-07 Thread MRafique Ujjan
Dear Experts! I am still waiting for solution, Plz help me to solve my problem. Thanks M. Rafique -- 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

$$Excel-Macros$$ Re: How to Get Data of 527 employees from One Excel Sheet to another Sheet on given proforma

2014-11-14 Thread MRafique Ujjan
Hi Dear Excel Experts! I am still looking for solution, plz help me to get me out of problem. Thanks in advance ___ M. Rafique -- 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://ww

$$Excel-Macros$$ Re: Need help to print only certain no of records from a payroll of employees

2014-12-28 Thread MRafique Ujjan
Dear Vabz! I can't find your last email. Plz send me your suggestion in this post. I'll be thankful to your Thanks On Friday, December 26, 2014 11:19:38 PM UTC+5, MRafique Ujjan wrote: > > Dear Experts! > > I am facing problem during printing of payroll because it cons

$$Excel-Macros$$ Need to print text properly alligned in excel

2015-07-03 Thread MRafique Ujjan
Dear Excel Experts! I am facing a problem while print 100s of payslips, problem is that its data is written in one cell which contains text and numerical data. they are not aligned and when i try to set its aligment through space it still not aligned when i take its print. I have attached a sam

$$Excel-Macros$$ how can I get data customer wise and Salesman wise automatically when I update master sheet1 in their respective sheet.

2010-01-17 Thread MRafique Ujjan
Dear Excel Experts I have a workbook named Sales. In which I have 6 to 7 worksheets regarding sales. I am giving its detail below Sheet1: This is master sheet where I enter all the data or daily data entry is made here. S# Name of Customer Name of CityQuantity Name of Sa

$$Excel-Macros$$ How can I repeat top most data of a column on each page

2011-11-18 Thread MRafique Ujjan
Dear Group Members, I am attaching a sample data sheet here. In which following are the columns 1. Union Council 2. Name of Deh 3. Name of Village 4. S. No 5. Full Name 6. N.I. C No 7. Nature of House Now I have entered data in this sheet in thousands of names and hundreds of villages. 1) Now I

Re: $$Excel-Macros$$ How can I repeat top most data of a column on each page

2011-11-18 Thread MRafique Ujjan
Dear Sorry! I have now attached the file please help me in this regard. Thanks for your quick response. M. Rafique Ujjan On Nov 18, 4:46 pm, NOORAIN ANSARI wrote: > Dear Rafique, > > Attachement is missing. > > On Fri, Nov 18, 2011 at 4:53 PM, MRafique Ujjan wrote: > > &

Re: $$Excel-Macros$$ Fwd: How can I repeat top most data of a column on each page

2011-11-19 Thread MRafique Ujjan
orry I forgot to attach sheet. > Now I have attached the sheet > > > > > > > > -- Forwarded message -- > From: MRafique Ujjan > Date: Fri, Nov 18, 2011 at 4:23 PM > Subject: How can I repeat top most data of a column on each page > To: MS EXCEL AND VBA MACROS >

Fwd: $$Excel-Macros$$ Fwd: How can I repeat top most data of a column on each page

2011-11-20 Thread MRafique Ujjan
rgot to attach sheet. > Now I have attached the sheet > ------ Forwarded message -- > From: MRafique Ujjan > Date: Fri, Nov 18, 2011 at 4:23 PM > Subject: How can I repeat top most data of a column on each page > To: MS EXCEL AND VBA MACROS > Dear Group Members, > I am attachi

$$Excel-Macros$$ How to calculate Joining Date from a given job period!!!

2012-11-26 Thread MRafique Ujjan
Dear All Excel Experts: I am having a following problem. I am given only total working days of an employee like 2 years 5 months & 13 days Now i am asked to calculate joining date of each employee. Therefore, i need your help in this regard I hope u will help me as this group helped me earlier

$$Excel-Macros$$ Re: How to calculate Joining Date from a given job period!!!

2012-12-02 Thread MRafique Ujjan
Dear R.Karunanithi Thank you very much for providing very descriptive information. Now I have solved my issue. On Monday, November 26, 2012 4:18:51 PM UTC+5, MRafique Ujjan wrote: > > Dear All Excel Experts: > > I am having a following problem. > > I am given only total

$$Excel-Macros$$ Re: Look up Names from Contacts Sheet & Display Name in an other sheet named call history.

2013-10-28 Thread MRafique Ujjan
Dear Experts I am very thankful to all of you by taking time & solved my problem very quickly. This Forum is so much responsive. Thanks to this forum too. On Sunday, October 27, 2013 9:27:29 PM UTC+5, MRafique Ujjan wrote: > > Dear Friends, > > > I have attached Workbook he

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-06 Thread MRafique Ujjan
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

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-06 Thread MRafique Ujjan
Thanks a lot dear Ravinder Negi for solving my problem. 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:

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
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:* exce

$$Excel-Macros$$ Re: I appreciate your help :-)

2013-11-08 Thread MRafique Ujjan
Dear Ayush Jain I have posted my problem with the subject named " How to retrieve multiple or single data from a single column like (A1) to different required columns like (D1, D2, D3...) I got quick response from Mr. Ravinder Negi & he almost solved my problem, but there was still a problem

Re: $$Excel-Macros$$ Re: I appreciate your help :-)

2013-11-08 Thread MRafique Ujjan
our query as a new post so that other > members can look into it. > > > > > On Fri, Nov 8, 2013 at 2:46 PM, MRafique Ujjan > > > wrote: > >> Dear Ayush Jain >> I have posted my problem with the subject named " How to retrieve >> mult

$$Excel-Macros$$ Re: I appreciate your help :-)

2013-11-09 Thread MRafique Ujjan
Dear Ravinder Negi Thanks a lot for solving my problem. Now each & every allowance is correctly done Thanks again _ Muhammad Rafique Ujjan On Thursday, March 7, 2013 9:06:29 PM UTC+5, Ayush Jain wrote: > > Dear members, > > Let's keep this post to recognize the forum