Re: $$Excel-Macros$$ Conditional Formatting

Dear Experts, Still waiting for your kind response. Regards, Zafar Iqbal - On Mon, Aug 29, 2011 at 12:59 PM, Zafar Iqbal wrote: > Dear Expert, > > One last thing to remind that Color bar should increase or decrease when > duration is changed. Ple

Re: $$Excel-Macros$$ Re: Query

Dear Shasi, You are Welcome... *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Sun, Sep 4, 2011 at 8:37 AM, Shashi Ranjan wrote: > Dear Venkat & Noorain Sir > > I am very thankful to you for sharing your precipus time helping m

Re: $$Excel-Macros$$ Re: Query

Dear Venkat & Noorain Sir I am very thankful to you for sharing your precipus time helping me solve this task. Thanks & Regards Shashi Ranjan On 1 September 2011 15:09, NOORAIN ANSARI wrote: > Dear Shashi, > > Please see attached sheet if it help to u... > > On Thu, Sep 1, 2011 at 2:22 PM, s

Re: $$Excel-Macros$$ Counter in a Cell

Hi Everbody Thanks for all your options. I would like to explain a little more. I want a small 5 pad keyboard to plug usb into laptop. Operator will not necessary have access to screen. The operator will just use up or down button to change the speed. So the H11 will need to be frozen I guess

$$Excel-Macros$$ *** CLOSING STOCK REPORT WITH PARAMETERS***

Hi Friends, I needs to Identify the Closing stock based on part numbers from the Purchase and sales transactions . And then i need to identify the closing stock which is lying over 60 days in the inventory. *Example:* * * I purchased Part number "XYZ' *70* Nos on 1of Jan'11and *30* Nos on 15t

RE: $$Excel-Macros$$ date in range

Paste the below macro into the sheet module : Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Intersect(Target, [G11:G23]) Is Nothing Then Exit Sub Cancel = True frmCalendar.Show End Sub Daniel De : excel-macros@go

$$Excel-Macros$$ date in range

Dear Experts, I have attached my part of project file. plz see it and give me solution. regards sajid memon -- -- Some important links for excel users: 1. Follow us on T

Re: $$Excel-Macros$$ extracting data from a datasheet

send the attachment in excel-macros@googlegroups.com email id On Sat, Sep 3, 2011 at 9:41 AM, Bheema Shankar wrote: > how to attach my file.? > > On Sep 1, 8:08 pm, ashish koul wrote: > > Can you attach the sample file > > > > On Thu, Sep 1, 2011 at 4:16 PM, Bheema Shankar >wrote: > > > > > > >

Re: $$Excel-Macros$$ ***VBA code to copy and save as new book***

Hi Mahesh, Pzl find the workbook. I would like to ask one more doubt when i click the pivot table value (in the attached sheet summary)a new sheet is appearing. In that sheet all the amount columns are appearing in date format. Can you help me how to change get amount in number format and date

RE: $$Excel-Macros$$ Counter in a Cell

Mr.Charlie, Please find the attached file. I have used Spin button (Form Control). It can be used another sheet linked with sheet 1 - H11 as you requested. - Xcel Inspiration From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Cab Boose Sent: 03 Septe

Re: $$Excel-Macros$$ extracting data from a datasheet

how to attach my file.? On Sep 1, 8:08 pm, ashish koul wrote: > Can you attach the sample file > > On Thu, Sep 1, 2011 at 4:16 PM, Bheema Shankar wrote: > > > > > > > > > > > I made an userform with Empno, Name, Design, DOB textboxes with the > > save command. I am able to save the data. Now, I n

Re: $$Excel-Macros$$ extracting data from a datasheet

Ya i attached. Pls provide me solution. On Sep 1, 8:08 pm, ashish koul wrote: > Can you attach the sample file > > On Thu, Sep 1, 2011 at 4:16 PM, Bheema Shankar wrote: > > > > > > > > > > > I made an userform with Empno, Name, Design, DOB textboxes with the > > save command. I am able to save th

$$Excel-Macros$$ Re: Counter in a Cell

On Sep 3, 2:12 am, Cab Boose wrote: > Hi > > In attached Sheet1, I want the cell to count from 0 to 16 up and down in > between. The count is of times up arrow and down arrow are pressed. > > To set speed from, 0 to 16 for model railroad project. > > Your advice appreciated. > > Thanks > > Charlie

Re: $$Excel-Macros$$ Counter in a Cell

Use a SPIN button from the control toolbox. See atttached From: Cab Boose Sent: Friday, September 02, 2011 8:12 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Counter in a Cell Hi In attached Sheet1, I want the cell to count from 0 to 16 up and down in between. The count is

RE: $$Excel-Macros$$ Counter in a Cell

Sorry, In ThisWorkbook, change for : Private Sub Workbook_Open() Sheets("Sheet1").Activate Application.OnKey "{UP}", "Plus" Application.OnKey "{DOWN}", "Moins" End Sub Private Sub Workbook_SheetActivate(ByVal Sh As Object) If Sh.Name = "Sheet1" Then Applica

Re: $$Excel-Macros$$

Hello Haeruddin, Please send your Query.. *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Sat, Sep 3, 2011 at 3:53 AM, Udin Haeruddin wrote: > -- > == Haeruddin, S.Pd == > > -- > > -

RE: $$Excel-Macros$$ Counter in a Cell

Hi, Paste the below macro in the ThisWorkbook module : Private Sub Workbook_Open() Application.OnKey "{UP}", "Plus" Application.OnKey "{DOWN}", "Minus" End Sub Paste the bellows macros in a standard module : Sub Plus() With Sheets("Sheet1") If ActiveSheet.Na

Re: $$Excel-Macros$$ Vlookup with more than one condition

Dear All I am a member of this group for last more than 2 years. I can proudly say that u will find the solutions(not solution) for all u r problem. By reading the above mail (from Noorani and Excel Learner) I got some different feeling.So my suggestion is dont critise any one Dont write any mail w