Re: $$Excel-Macros$$ Need Help

2014-11-23 Thread Ashish Kumar
Hi Chandru, PFA Regards Ashish On 24 November 2014 at 11:57, Chandru wrote: > I need Excel formula or VBA for the following. >*) To set cell width(for headers). >*) To make hyper link text blue. >*) Font Formatting(for headers). > > Regards, > Chandru > > -- > Are you =EXP(E:RT) or

$$Excel-Macros$$ Need Help

2014-11-23 Thread Chandru
I need Excel formula or VBA for the following. *) To set cell width(for headers). *) To make hyper link text blue. *) Font Formatting(for headers). Regards, Chandru -- 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

$$Excel-Macros$$ Re: Copy data form “input sheet” to “output sheet “ by macro

2014-11-23 Thread Mandeep Baluja
Hey Nur, Kindly find the attachment. frankly speaking this is first time i made this code without any help from blogs. :) Regards, Mandeep Baluja Excel Specialist. https://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl On Sunday, November 23, 2014 9:03:

$$Excel-Macros$$ compare column header with the array list

2014-11-23 Thread sani
Hi, I am new to excel vba. I have an array with list of column headers myarray=("employee","department","salary","year","position") and the excel sheet has following columns "employee" | "salary" i need to compare my array with excel headers and as "department","year" and "position" is not av

$$Excel-Macros$$ Copy data form “input sheet” to “output sheet “ by macro

2014-11-23 Thread Nur Hossain
Dear all, I am having two sheet ,need to copy particular data range of “input sheet” and past to “output sheet “ conditionally . here my data range of input sheet is A1:E8, F1:J8,K1:O8 . this range need to past to the output sheet in the column rage A:E , I have attached my excel sheet & also s

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

2014-11-23 Thread pp kk
use data entry like 8:00AM 8:20 AM Then 8:20 AM - 8:00 AM = 0:20 Pankaj Michael On Sun, Nov 23, 2014 at 10:25 AM, son nguyen wrote: > Dear all, > > I have problem when calculate total equipment downtime as there are > overlap periods. > For example : > start time Finish time > 8:00

$$Excel-Macros$$ Break Tracker Requirement by VBA

2014-11-23 Thread kapil Gupta
Hello, Please any one send me any example of Break tracker. Which is requirement of anyone go to break they marked in tracker break and start time and end time automatically in go to excel sheet. and also first start the tracker use login and end of day logout included. Regards, Kapil