Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 8 updates in 5 topics

2017-06-09 Thread Rashid Khan
e4a84c8e?utm_source=digest_medium=email> > Back to top <#m_-7746555178834149049_digest_top> > When Excel Save then below message show > <http://groups.google.com/group/excel-macros/t/c22a0fcb48c38c5a?utm_source=digest_medium=email> > amar takale <amartak...@gmail.com>:

Re: $$Excel-Macros$$ Macro to Insert Pictures according to the Cell Value in Column A

2015-08-03 Thread Rashid Khan
https://groups.google.com/d/optout. -- *Rashid Khan* *Senior Trainer* *ExecuTrain* *AmanatSoft* *Corporate Training* *Software Development* PO Box: 26977, Dubai, UAE Tel: +97143374888, Fax: +97143374889, *Mob: +971(55)7490756 – +971(50)2323657* www.executrain.ae

Re: $$Excel-Macros$$ Macro to Insert Pictures according to the Cell Value in Column A

2015-08-03 Thread Rashid Khan
https://groups.google.com/d/optout. -- *Rashid Khan* *Senior Trainer* *ExecuTrain* *AmanatSoft* *Corporate Training* *Software Development* PO Box: 26977, Dubai, UAE Tel: +97143374888, Fax: +97143374889, *Mob: +971(55)7490756 – +971(50)2323657* www.executrain.ae | www.executrain.com

Re: $$Excel-Macros$$ Macro to Insert Pictures according to the Cell Value in Column A

2015-08-02 Thread Rashid Khan
in the referenced folder on the code 2. Make sure it image with JPG format, not PNG, GIF, BMP or other image format, just JPG (the extention is .jpg) Thanks, waiting for your respond. On 01/08/2015 23:40, Rashid Khan wrote: Thanks for your explanation. But unfortunately it is not working. I am just

Re: $$Excel-Macros$$ Macro to Insert Pictures according to the Cell Value in Column A

2015-07-31 Thread Rashid Khan
. -- *Rashid Khan* *Senior Trainer* *ExecuTrain* *AmanatSoft* *Corporate Training* *Software Development* PO Box: 26977, Dubai, UAE Tel: +97143374888, Fax: +97143374889, *Mob: +971(55)7490756 – +971(50)2323657* www.executrain.ae | www.executrain.com/dubai | *www.amanatsoft.com* -- Are you

$$Excel-Macros$$ Macro to look for x in Columns and paste data in worksheet in various folders

2014-04-30 Thread Rashid Khan
Hello All, I am using Excel 2010 and have the following problem. I need a macro to look for x in Columns J to AX (Sample File Attached). If it finds x then it should go to the Folder “C:\Test\Macro” which contains the Folder names shown in J3 to AX3. It should open the file inside the

$$Excel-Macros$$ Copy Identical Headings from various sheet to a Result sheet

2014-04-14 Thread Rashid Khan
to copy the data starting from the Heading in Row 5 till the last active cell on all 10 Sheets. Thanks in advance Rashid Khan -- 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

$$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values

2014-04-02 Thread Rashid Khan
Dear All, I am using Excel 2010. I have attached a sample file with my problem. Please see before and after Any macro help would be appreciate. Regards Rashid -- 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

$$Excel-Macros$$ Macro to calculate Attendance from a Monthly Schedule

2013-09-02 Thread Rashid Khan
Hello All, I have duty schedule for various Staffs on various Stores. All Sheets are of same pattern. I am enclosing a Sheet with my Problem only for one Store as a Sample. I have many sheets in the workbook (50+). Each Staff name appears in a Row. Sometimes two Staff Names are in a Row

$$Excel-Macros$$ Formula or UDF to do Vlookup for values delimited with ]

2013-08-18 Thread Rashid Khan
result. Is there a formula or a UDF which can give me the desired result. Please note that there are several Columns with the Codes combined. I have just used a sample column to demonstrate my problem. TIA Rashid Khan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

$$Excel-Macros$$ Count No of Days between Start and End Date over a period of different years

2013-02-18 Thread Rashid Khan
Hello All, I am attaching a sample file for my problem. I wish to have a formula entered in Cell D2 (highlighted in yellow - *to be dragged across and down*) to calculate the number of days in Col D, E and F over different years from the Start and End Date. Thanks in advance Rashid Khan

$$Excel-Macros$$ Excel Graph Problem

2012-10-16 Thread Rashid Khan
Hello All, Is it possible to create the graph shown on the attached file as per the data shown? Regards Rashid Khan -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread

$$Excel-Macros$$ Macro to create Pivot Table for each sheet in the workbook

2012-10-01 Thread Rashid Khan
created for Name2 should be PivotName2 and so on. 2) The macro should exclude Data and List sheets. Any help would be appreciated. Thanks Rashid Khan -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1

$$Excel-Macros$$ Macro to create Pivot Table for each Name Sheet

2012-10-01 Thread Rashid Khan
created for Name2 should be PivotName2 and so on. 2) The macro should exclude Data and List sheets. Any help would be appreciated. Thanks Rashid Khan -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 32 Messages in 8 Topics

2012-09-30 Thread Rashid Khan
exclude Data and List sheets. Any help would be appreciated. Thanks Rashid Khan -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please

$$Excel-Macros$$ Highlight Worked Cells only if the Employee has worked in both areas

2012-09-15 Thread Rashid Khan
shown in the attached file is part of a big work area, I would like to RUN the macro only on the Selected Range after I have selected that Range. Thanks in advance Rashid Khan -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already

$$Excel-Macros$$ Formula to Calculate Slab Wise Commission as per Targets Achieved

2012-09-09 Thread Rashid Khan
% and so on so forth. I require the formula in F5:K5 (red color cells) to drag it down and across to get the desired figures. Thanks Rashid Khan -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use

$$Excel-Macros$$ Macro to convert date at the time of entry

2012-08-25 Thread Rashid Khan
is entered* in Col A. Any help would be appreciated. Rashid Khan -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need