$$Excel-Macros$$ Extarct Image Details using Macro

Hi Excelites, I am need of Macro, I already have an Macro for Extracting Dimensions of teh Image. but not able to get the Resolution Details. Please advice me is there any Property to extract the Image Resoultion(dpi) from the Folder (Horizontal Resolution & Vertical Resolution) using VBA code. t

Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet

Hi Thanks for the reply.I know this method but when data is more and fields not in same order it will not be practical is it possible to use any array formula for this. With Regards & Thanks Rajesh kainikkara On 1/24/13, Bé Trần Văn wrote: > You can use the Link worksheets together by: > Type t

Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet

Hi Paul It can be identified by sheet name.I am trying to solve it by formula only. Regards Rajesh On 1/22/13, Paul Schreiner wrote: > how do you identify "date criteria"? > is it by sheet name? > > I don't see the dates on any of the individual sheets. > > I'm pretty sure we can't include a da

$$Excel-Macros$$ Formula Require to calculate Medical Reimbursement on Date of Joining.

Hi Team, Pls help me to get Formula based on attached file. yearly we have to pay rs. 3500/- if some one joined mid of the year then on pro-rata basis we have to pay Medical OTC. Pls help. Rgds, Prabhakar -- Join official Facebook page of this forum @ https://www.facebook.com/discusse

$$Excel-Macros$$ Retrieve data

hi champs, i have one main sheet & some data sheet, i need two dates with time between the the formula retrive the main sheet based on Name colum in yellow color hilighted pl z fin example sheet. -- Regards, Shiva. -- Join official Facebook page of this forum @ https://www.facebook.com

$$Excel-Macros$$ Re: Filling Data based on cells above

Thanks all, the issue has been resolved! You are all great! Natron -- 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 Proble

$$Excel-Macros$$ Calculating TAT with 6 working day

Dear Friends, I need your help Refer attached file, 1) "Detail" sheet contains handover details of cabs in Nov/Dec. Column AI shows working for Gross TAT & AJ shows working for Net working hours. 2) "Holiday list", needs to be updated as applicable for NAL. This need not cover Sunda

Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet

You can use the Link worksheets together by: Type the equal sign (=) in the C7 of Consolidate sheet, click the sheet 01 and Click on C2 and then type a plus sign (+), Click on the sheet 02 and Click on C2 and then type a plus sign (+) Click on sheet 05 and click on C2 and press Enter, we ha

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

Hi Walekumassalam Sadia Welcome to the group On Wed, Jan 23, 2013 at 9:33 PM, Sadia Khalid wrote: > > > Hello All, > SALAM > I am SADIA KHALID , aged 30. I live in UAE. > > Regards > SADIA KHALID > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > F

$$Excel-Macros$$ Re: Introduce Yourself !!

Hello All, SALAM I am SADIA KHALID , aged 30. I live in UAE. Regards SADIA KHALID -- 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 Pr

Re: $$Excel-Macros$$ Re: VBA Code -Slide Show

Say sheet 1 has several picture placed in there so I want a code to preview the slide show in the excel file. Thnks Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Prince Sender: excel-macros@googlegroups.com Date: Wed, 23 Jan 2013 07:32:18 To: Reply-To:

$$Excel-Macros$$ Re: VBA Code -Slide Show

Hi Hilary, Do you want whatever pictures are there on your excel sheet must be converted into PPT for slid show or anything else please help me to understand the problem. Regards Prince On Wednesday, January 23, 2013 7:54:42 PM UTC+5:30, hilary lomotey wrote: > > Hello Experts, > > i need assi

Re: $$Excel-Macros$$ Fwd: Excel Spellcheck Help.

Hi saravanan Please see the attachment. I have placed the code provided by the Rajan Verma who has already posted a link for your question. For getting results. You have paste some data inside sheet1 and then press the button that i have provided it will create another sheet wrong words which w

Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet

OK... how does that affect the calculation? you asked:  "Is there any way to add date criteria". but in your workbook, these dates do not seem to be a reference of any kind. the phrase "add date criteria" COULD mean that you want to add the values that are recorded within the date range.. But

Re: $$Excel-Macros$$ VBA Code -Slide Show *

thanks Ashish, this is for charts, i was hoping for one with pictures instead, On Wed, Jan 23, 2013 at 2:26 PM, ashish koul wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (koul.ash...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet

Hi Paul Date is in the consolidation page there i give it under the heading from 01/01/13 to 05/01/13 Regards Rajesh kainikkara On Tuesday, January 22, 2013 7:03:13 PM UTC+5:30, Paul Schreiner wrote: > > how do you identify "date criteria"? > is it by sheet name? > > I don't see the dates on

$$Excel-Macros$$ drop down/radio button help

hi experts, i have made two combo box in excel both depended on each other and these are depended on Radio buttons the problem arise when ever i click on radio button and value changes incombo box. what i want to make my combo box 1st vale as a default when ever i change radio button. 1

Re: $$Excel-Macros$$ VBA Code -Slide Show

try this http://spreadsheetpage.com/index.php/tip/a_quick_and_dirty_slideshow_macro/ On Wed, Jan 23, 2013 at 7:54 PM, Hilary Lomotey wrote: > Hello Experts, > > i need assistance with a vba code to show pictures in slide show mode in > excel. any help will be appreciated. ie if i insert a num

$$Excel-Macros$$ VBA Code -Slide Show

Hello Experts, i need assistance with a vba code to show pictures in slide show mode in excel. any help will be appreciated. ie if i insert a number of pictures in excel, i want a code that will show the pictures in slide show mode. thanks -- Join official Facebook page of this forum @ https://

Re: $$Excel-Macros$$ Re: VBA Solution Requried * *

Hi Hilary, Very Helpful and thanks again providing this helpful knowledge.I always remind it in my mind in future work. Thanks again.. Regards Amar ** On Wed, Jan 23, 2013 at 6:17 PM, Hilary Lomotey wrote: > mostly if you are using large data it is advisable to use defined names, >

Re: $$Excel-Macros$$ Re: VBA Solution Requried * *

mostly if you are using large data it is advisable to use defined names, its works better and faster. On Wed, Jan 23, 2013 at 10:17 AM, amar takale wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (amartak...@gmail.com) Add cleanup > ru

Re: $$Excel-Macros$$ VBA Help:Excel table copy paste in word (with formatting as it)

Sir where is set code.it is replace old code or adjust on it.pls if possible send me full code or sheet example which I attached above (Report). Thanks very much On Wed, Jan 23, 2013 at 3:01 AM, bpascal123 wrote: > Set ws = wb.Worksheets("Feuil") > to > Set ws = wb.activesheet > > run the code f

Re: $$Excel-Macros$$ Re: VBA Solution Requried *

Dear Hilary Lomotey, This solution is beyond my expectation. Great work thanks a billionHilary.Sir but we use index formula & this 12 company only if there are more than 100 companies then our sheet is very slow?then it is possible to open file. Regards Amar On Tue, Jan 22, 2013 at 8:25 PM, Hilar

Re: $$Excel-Macros$$ Re: VBA Solution Requried

Hi Shekhar, As per you say all arrow assign to all SortData Code but current error show {Object required},where is I wrong pls tell me.I will send that sheet. On Wed, Jan 23, 2013 at 9:20 AM, Shekhar Pujari wrote: > > Hi Amar, > > SortButtons is called by program SortData every time you click on

RE: $$Excel-Macros$$ Formaula to calculate Turnaround time excluding non working hours

Yes, I want to exclude Sunday & time beyond 18:00 to 09:00. Best Regards, Amit Desai +91 98672 32534 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of rajan verma Sent: 23 January 2013 14:37 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ For

RE: $$Excel-Macros$$ Formaula to calculate Turnaround time excluding non working hours

How shall I remove the non office hours... Best Regards, Amit Desai +91 98672 32534 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of rajan verma Sent: 23 January 2013 14:02 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formaula to calculat