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$$ Advanced Filter Not Working Properly

2013-11-06 Thread Ravinder
Pfa, try this one.. if help you From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Hilary Lomotey Sent: Tuesday, November 05, 2013 10:48 PM To: excel-macros Subject: $$Excel-Macros$$ Advanced Filter Not Working Properly Hello Experts, i need your

RE: $$Excel-Macros$$ Calculate cogs avg basis in Excell

2013-11-06 Thread Kashan Abbas
Dear at least reply to my query.Pleas help i have hopes with u all guyss. From: kashanabbas...@hotmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Calculate cogs avg basis in Excell Date: Tue, 5 Nov 2013 22:39:18 +0500 Dear expert , plz help From:

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 javascript: [mailto: excel-...@googlegroups.com javascript:] *On Behalf Of *MRafique Ujjan *Sent:*

Re: $$Excel-Macros$$ Advanced Filter Not Working Properly

2013-11-06 Thread Hilary Lomotey
thanks for the assistance. On Wed, Nov 6, 2013 at 10:14 AM, Ravinder ravinderexcelgr...@gmail.comwrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (ravinderexcelgr...@gmail.com) Add cleanup

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

2013-11-06 Thread Hilary Lomotey
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

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

2013-11-06 Thread Hilary Lomotey
i have been able to do it thanks On Wed, Nov 6, 2013 at 7:08 PM, Hilary Lomotey resp...@gmail.com wrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (resp...@gmail.com) Add cleanup

$$Excel-Macros$$ '1004' Run Time Error when VBA Cell comment list is over 266 lines

2013-11-06 Thread Denisetoo
I get a run time 1004 when the comment lines are at 266 lines. WIth less than 200 comment lines the code runs fine. The DropDownTmp variable list includes all 266 lines. The comment field cuts off around 253 lines of code. The program stops with the run time error. Any ideas on how to fix

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

2013-11-06 Thread Basole
Thank you. when you need to let me know. Take a look at this link, and has several good choices of courses and tutorials VBA: http://www.mrexcel.com/forum/general-excel-discussion-other-questions/698256-online-visual-basic-applications-course.html another option this great book:

RE: $$Excel-Macros$$ Calculate cogs avg basis in Excell

2013-11-06 Thread Ravinder
Could you pls give small data and your query and desired output with calculation.so we can try From: Kashan Abbas [mailto:kashanabbas...@hotmail.com] Sent: Thursday, November 07, 2013 10:36 AM To: excel-macros@googlegroups.com; xlst...@gmail.com; ravinderexcelgr...@gmail.com Subject: FW:

$$Excel-Macros$$ use of find method in VBA

2013-11-06 Thread rutuja patekar
I am taking data from one workbook and finding the same data in different workbook. I am using find method, below is my code; Dim rowcrnt As Range Dim rng As Object Workbooks(Input1_FileName).Sheets(Input1_SheetName).Activate Workbooks(Input2_FileName).Sheets(Input2_SheetName).Activate

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

2013-11-06 Thread Sandeep Kumar Baranwal
Hi Basole Please accept my thanks for the links. I will go through them and would let you know if I have any issue and see their applicability in my risk domain. For the time being, the VBA code is running well so far. I want to work on a variant of it. Could it be possible for you to work on

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

2013-11-06 Thread Ravinder
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

RE: $$Excel-Macros$$ use of find method in VBA

2013-11-06 Thread Ravinder
I think problem with yello highlighted color code. Pls try this if help (PFA) Sub RoundedRectangle1_Click() Dim rng As Range Sheet2.Range(a1:a9).Select Set rng = Selection.Find(What:=b, After:=Range(a1), LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows,