Re: $$Excel-Macros$$ Need help in creating macro

2014-07-28 Thread Jocky Beta
Hi Vaibhav, It's highliting only row, it's not showing wich entry or exit is missing out of 18nos. It would be very helpful if it would be done. Regards On Friday, July 25, 2014, Vaibhav Joshi wrote: > Hi > > Pl check this... > > Cheers!! > > > On Fri, J

Re: $$Excel-Macros$$ Need help in creating macro

2014-07-25 Thread Jocky Beta
Hi All, Any hope regarding on this? On Friday, July 25, 2014, Jocky Beta wrote: > Hi vaibhav it will be ok for me if it will be highlited by colour , > > Regards > > On Friday, July 25, 2014, Vaibhav Joshi > wrote: > >> Don't you think there will be too mu

Re: $$Excel-Macros$$ Need help in creating macro

2014-07-25 Thread Jocky Beta
Hi vaibhav it will be ok for me if it will be highlited by colour , Regards On Friday, July 25, 2014, Vaibhav Joshi wrote: > Don't you think there will be too much of pop ups, instead how about > highlighting it with color? > > Cheers!! > > > On Fri, Jul 25, 20

$$Excel-Macros$$ Need help in creating macro

2014-07-24 Thread Jocky Beta
Hi team, I need some help in creating macro for an excel sheet. I have worksheet in which 18 nos of in and out transaction are reflected. I need macro for any one of transaction out of these 18 is missed it shuld show a popup message stating that transaction Your help on the same will be apprecia

Re: $$Excel-Macros$$ Help required on Macro

2014-06-29 Thread Jocky Beta
Hi Team, Can anybody help me for converting above attached file to comfortable for office 2010 as this file is made in office 2007 and its not working in office 2010 Regards On 6/27/14, Jocky Beta wrote: > -- Forwarded message -- > From: Abhishek Jain > Date: Thu, 26

Re: $$Excel-Macros$$ Help required on Macro

2014-06-26 Thread Jocky Beta
ork ? > > > On Thu, Jun 26, 2014 at 1:46 PM, Jocky Beta wrote: > >> Hi all, >> >> Any hope regarding on the same. >> >> Regards >> >> On 6/26/14, Jocky Beta wrote: >> > Hi Manoj , >> > >> > Thianks for the reply,

Re: $$Excel-Macros$$ Help required on Macro

2014-06-26 Thread Jocky Beta
Hi all, Any hope regarding on the same. Regards On 6/26/14, Jocky Beta wrote: > Hi Manoj , > > Thianks for the reply, > > But sheet provided by you is not working It's showing *"Can't exit design > mode because control Combobox5 can not be created" *error

Re: $$Excel-Macros$$ Help required on Macro

2014-06-25 Thread Jocky Beta
gt; Date: Wed, 25 Jun 2014 11:52:30 +0530 > Subject: Re: $$Excel-Macros$$ Help required on Macro > To: excel-macros@googlegroups.com, Jocky Beta > > pfa > > > On Wed, Jun 25, 2014 at 11:05 AM, Jocky Beta wrote: > > > Hi Team, > > > > I got below attached s

Re: $$Excel-Macros$$ Data Fetching

2014-06-17 Thread Jocky Beta
Hi every time I received new sheet from my colleague in. That situation your sheet not working Regards On 6/17/14, Vaibhav Joshi wrote: > I didnt get you what you are trying to say! > > > > > On Tue, Jun 17, 2014 at 12:36 PM, Jocky Beta wrote: > >> Hi, >> &

Re: $$Excel-Macros$$ Data Fetching

2014-06-17 Thread Jocky Beta
>> need to keep open sheet 1 & sheet 2 (Only 2 sheets). Goto sheet 2 >> workbook, >> hit that blue button & select the date which is in sheet one in column A >> e.g. cell A8 & value will be fetched. >> >> Hope it helps. >> >> Cheers!! >> >

Re: $$Excel-Macros$$ Data Fetching

2014-06-16 Thread Jocky Beta
Hi vaibhav, Fist upon thanks for the reply. I will prefer both the way It would be very helpful If u help me on the same. Regards On 6/16/14, Vaibhav Joshi wrote: > Hey > > How do you want to fetch? Formula or Macro? > > > > > On Sun, Jun 15, 2014 at 11:27 PM, Jocky B

Re: $$Excel-Macros$$ Data Fetching

2014-06-16 Thread Jocky Beta
Hi Team, Your valuable replay on this will be appreciated. Regards On 6/15/14, Jocky Beta wrote: > Hi Team, > > I want to fetch data from one sheet to another sheet by referring the data, > Attached sheet will explain you what i want exactly. > > Request all of you to kind

$$Excel-Macros$$ help on #VALUE! and #NUM! error

2014-04-01 Thread Jocky Beta
Hi Team, Please find the attached sheet in winch i have already put the formula for finding particulate values. but it me shows #VALUE! and #NUM! error. It would be very helpful if somebuddy will help me to rectify the same. Regards Jocky -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

Re: $$Excel-Macros$$ Help required on formula

2014-03-31 Thread Jocky Beta
Please help Regards On 3/29/14, Jocky Beta wrote: > Hi pramod, > > Please find the attached sheet in which i had explain what i required, > Request you to kindly go through it and help me to solve the problem. > > Regards > > > On Sat, Mar 29, 2014 at 10:13 AM, Pr

Re: $$Excel-Macros$$ Help required on formula

2014-03-29 Thread Jocky Beta
2014 at 8:08 AM, Jocky Beta wrote: > >> Hi, >> I have already assigned formula but its showing error. >> >> Please help me. >> >> Regards >> >> >> On Fri, Mar 28, 2014 at 1:51 PM, Jocky Beta wrote: >> >>> Hi, >>> >

Re: $$Excel-Macros$$ Help required on formula

2014-03-28 Thread Jocky Beta
Hi, I have already assigned formula but its showing error. Please help me. Regards On Fri, Mar 28, 2014 at 1:51 PM, Jocky Beta wrote: > Hi, > > Please help me on this _ > > > Regards > > > On Fiday, March 28, 2014, Jocky Beta wrote: > > Hi All, > > &g

Re: $$Excel-Macros$$ Help required on formula

2014-03-28 Thread Jocky Beta
Hi, Please help me on this _ Regards On Fiday, March 28, 2014, Jocky Beta wrote: > Hi All, > > Pls fin above attached sheet in which Query sheet when i type any word related to Item code ELEC0001 (Kindly see the master sheet) it will search the Item Name automatically. But when i

$$Excel-Macros$$ Help required on formula

2014-03-27 Thread Jocky Beta
Hi All, Pls fin above attached sheet in which Query sheet when i type any word related to Item code ELEC0001 (Kindly see the master sheet) it will search the Item Name automatically. But when i put bulb it's not showing any vale as well as Item name also. hence request you to kindly help me on th

$$Excel-Macros$$

2014-02-12 Thread Jocky Beta
Hi Group, I need excel based inventory sheet for my office purpose, It would be very helpful if anybody share the same as many templates available on Internet very basic and did not contains full information like Vendor Details, material issue, material received etc.. *Regards* *Jocky* -- Are

Re: $$Excel-Macros$$ material Stock Inventory in Excel

2013-12-19 Thread Jocky Beta
> Hi Jockey, > > Please specify your requirement. > Thanks & Regards, > Sandeep Kumar Chhajer > Mumbai > India > > Sent on my BlackBerry® from Vodafone > ------ > *From: * Jocky Beta > *Sender: * excel-macros@googlegroups.com &

$$Excel-Macros$$ material Stock Inventory in Excel

2013-12-19 Thread Jocky Beta
Hi All, Does anybody have material Stock Inventory sheet in Excel. if Yes kindly share *Rgerads* *Jocky* -- 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

Re: $$Excel-Macros$$ Password Assistance

2013-12-17 Thread Jocky Beta
Hi, Can you share the Excel sheet? Regards On Wed, Dec 18, 2013 at 3:06 AM, Adam Subelka wrote: > I have a Excel 2010 file that is VBA Password protected. The person who > protected the file is no longer with the company and I cannot find anyone > who can unlock the file. > > I have a macro t

Re: $$Excel-Macros$$ Re: Need macro for converting PDF in to given format

2013-10-18 Thread Jocky Beta
install the file "pdftotext.exe" folder in "C: \ windos \ > system32". > > > > > Em quarta-feira, 16 de outubro de 2013 11h40min34s UTC-3, jocky Beta > escreveu: >> >> Hi Team, >> >> I need help on above attached sheets, In the excel sh

Re: $$Excel-Macros$$ Re: Need macro for converting PDF in to given format

2013-10-17 Thread Jocky Beta
ice? > > > > > Em quarta-feira, 16 de outubro de 2013 11h40min34s UTC-3, jocky Beta > escreveu: >> >> Hi Team, >> >> I need help on above attached sheets, In the excel sheet i should browse >> the PDF file (which is attached in this mail ) and the

Re: $$Excel-Macros$$ help required on attached Macro

2013-10-17 Thread Jocky Beta
Anil Narayan > Software Developer, > Abacus Software Services Pvt Ltd > > > On Thu, Oct 17, 2013 at 1:59 PM, Jocky Beta wrote: > > Hi Team, > > > > Can anybody fix this attached error for me. i am also attaching the excel > > file for your reference. > >

Re: $$Excel-Macros$$ Need macro for converting PDF in to given format

2013-10-16 Thread Jocky Beta
Hi Ashish, Thanks for the prompt reply but i can not use the same due to policy, request you to kindly give me the alternate option. Regards On Wed, Oct 16, 2013 at 8:34 PM, ashish koul wrote: > try *able2extract *professional version > > > On Wed, Oct 16, 2013 at 8:10 PM, Jocky

$$Excel-Macros$$ Need macro for converting PDF in to given format

2013-10-16 Thread Jocky Beta
Hi Team, I need help on above attached sheets, In the excel sheet i should browse the PDF file (which is attached in this mail ) and then the output data should be come in given format. Looking forward your co-operation Regards -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wann

Re: $$Excel-Macros$$ Need Help for formula

2013-01-04 Thread jocky Beta
Hi Anoop, There is No formula in the attached sheet, :( On Fri, Jan 4, 2013 at 5:27 PM, Anoop K Sharma wrote: > Hi Jocky, > > Please find attached with solution. > > Regards, > Anoop > Sr. Developer > > > On Fri, Jan 4, 2013 at 4:59 PM, jocky Beta wrote: > >

$$Excel-Macros$$ Need Help for formula

2013-01-04 Thread jocky Beta
Hi Team, I have attached one excel sheet in wich i need to set the formula for the person for the entire week.i.e is if one person is working form Mon to Fri it should mark 9:00 and when same person working on Sat & Sun it shoud mark the time as 12:00 Please help me on this -- Join official Fac

Re: $$Excel-Macros$$ beed to create further micros for genrating the other reports

2012-08-23 Thread jocky Beta
Hi, Any Update regarding on the same Jocky On Thu, Aug 23, 2012 at 12:01 AM, jocky Beta wrote: > Hi, > Any one help me on crating further micros for genrating the other reports? > please find the above attached excek file, > Jocky > > -- > Join official facebo

$$Excel-Macros$$ Anybody have total Floor's Electrical Load Calculation Sheet.Xls

2012-05-17 Thread jocky Beta
Hi, Anybody have total Floor's Electrical Load Calculation Sheet.Xls If YES then request you to forward me the same * * * * *JOCKY* -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Form

Re: $$Excel-Macros$$ Need help on Micro Button!!!!!!!!!!!!!!!!!!!

2011-11-14 Thread jocky Beta
t; ActiveSheet.Range("B53:B69").EntireRow.Hidden = Not > ActiveSheet.Range("B53:B69").EntireRow.Hidden > > End Sub > Private Sub CommandButton4_Click() > ActiveSheet.Range("B72:B88").EntireRow.Hidden = Not > ActiveSheet.Range("B72:B88"

$$Excel-Macros$$ Need help on Micro Button!!!!!!!!!!!!!!!!!!!

2011-11-14 Thread jocky Beta
HI Team, I had created one sheet in which i made the Groups Now i want to link the Buttons which i created in the sheet (When i click the Button it should expand the group and wen again click the button it needs to be close). Please help me on this * * *Regards,* *Jocky* -- FORUM RULES (93

$$Excel-Macros$$ Unable to open the password Protected PPT Help me on this -------------------------------------------

2011-11-09 Thread jocky Beta
Hi Team, I had made one PPT file few days ago and now i had forgot the password of that PPT. Hence request you anybody help me on this Regards, Jocky -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Hel

Re: $$Excel-Macros$$ Need help --------

2011-08-28 Thread jocky Beta
ick. > > > On Sun, Aug 28, 2011 at 12:20 PM, jocky Beta wrote: > >> >> Hi Team, >> >>I had create Compound Calculator in Excel VB sheet , i had already set >> the Formula in VB but when i Click on the Calculate Button it shows error, >> he

$$Excel-Macros$$ Need help --------

2011-08-27 Thread jocky Beta
Hi Team, I had create Compound Calculator in Excel VB sheet , i had already set the Formula in VB but when i Click on the Calculate Button it shows error, hence i request you to help me on this. Regards -- -- Som

Re: $$Excel-Macros$$ Daily Interest calculator

2011-08-26 Thread jocky Beta
Hi, request all of you Help me on this _, Regards, On Fri, Aug 26, 2011 at 1:25 PM, jocky Beta wrote: > > HI Team , > > I am Trying to make the Daily Interest (cumulative) calculator, Please > see the attached sheet and help me for the same. > > Looking forw

$$Excel-Macros$$ Daily Interest calculator

2011-08-26 Thread jocky Beta
HI Team , I am Trying to made the Daily Interest calculator, Please see the attached sheet and help me for the same. Looking forward your Co-operation Regards -- -- Some important links for excel users: 1. Follow

$$Excel-Macros$$ Need Formula

2011-08-01 Thread jocky Beta
Hi Team, I have one sheet in which Two Columns are there in which first Column there is Employee id and employee name. In Second column i need the exact employee id as per there names. Hence pls tell me formula for the same. Please find the attached sheet for your Reference. Regards, --

$$Excel-Macros$$ Need Help!!!!!!!!!!!!!!!

2011-04-25 Thread jocky Beta
Hi, I have Two Different Sheets one is mail sheet and another is general sheet. when i open the both sheets and select the arrange all then tilled, then booth sheets open side by side now my Question is, is it possible when i select one name in main sheet it automatically highlight in the Second

Re: $$Excel-Macros$$ need Formula Correction !!!!!!!!!!!!!

2011-01-18 Thread jocky Beta
.com/5_minute_tips/general/learning_vlookup_in_excel > http://www.techonthenet.com/excel/formulas/vlookup.php > > > I think this help u out.... > > > > Regards, > Manoj Kumar > > > On Mon, Jan 17, 2011 at 8:40 PM, jocky Beta wrote: > >> >> Hi Manoj, &g

Fwd: $$Excel-Macros$$ need Formula Correction !!!!!!!!!!!!!

2011-01-17 Thread jocky Beta
-operation. *Please Help me for the above Query!!! * * * * * *Thanks * *Jocky * On Mon, Jan 17, 2011 at 1:03 PM, Manoj kumar wrote: > Attached for ur reference > > > > Regards, > Manoj Kumar > > > On Mon, Jan 17, 2011 at 12:16 PM, jocky Beta wrote:

$$Excel-Macros$$ need Formula Correction !!!!!!!!!!!!!

2011-01-16 Thread jocky Beta
Hi, I made a Excel sheet with help of V lookup using the Data validation, but my formula shows unknown error. hence pls explain me the step by step procedure for the same. Regards Jocky -- -- Some important links