$$Excel-Macros$$ Count number of times a part is out of stock without counting all days part is out of stock

I have a spreadsheet that has dates across the top row and a list of items in the first column. Under each date, if a part had a back- order, the total quantity appears under the respective date. What I am trying to do is figure out how many times an item has been on back-order in the last X days

Re: $$Excel-Macros$$ Does anybody have games

Try these links http://www.excelgames.org/ http://www.automateexcel.com/2005/01/13/52_excel_games/ Regards, Andy On Wed, Apr 7, 2010 at 12:37 AM, Nani Ram <06n...@gmail.com> wrote: > Hi All, > > Does anybody have games in excel sheet, if so please send me. > > > Thanks, > Naniram > > -- > > ---

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

Paul your solution is working fine thanks, i always get to learn something new from this group Thanks to all On Wed, Apr 7, 2010 at 9:07 AM, ashish koul wrote: > hi > > > yes to avoid making it text u an got right click on cell -> format -> > cutom format -> [mm] > > On Tue, Apr 6, 2010 at

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

hi yes to avoid making it text u an got right click on cell -> format -> cutom format -> [mm] On Tue, Apr 6, 2010 at 11:36 PM, paulwillekens < paul.johan.willek...@gmail.com> wrote: > Hi Gaurav, > > Did you try my solution? =(D3 - C3) * 24 * 60 > What's wrong about that? The result remains num

$$Excel-Macros$$ Re: Modifying input data

Paul, This is simply amasing...Thanks a ton Cheers!!! Harry On Apr 6, 10:54 pm, paulwillekens wrote: > Hi Harpreet, > > Here it comes... I made a new sheet "test" to test it, but you can > change that statement in > cCooked = "MODIFIED DATA" > after testing, of course. > > Feedback is

$$Excel-Macros$$ Need Help to find a date and time calculation

Hi All., Need your help with the following macro.. there are Four date and time columns in the attached spreadsheet. Date A1, Date A2, Date B1 and Date B2. The macro I'm looking for should color the entire row if the date and time range of B1 to B2 falls within (or same as) the date and time ran

Re: $$Excel-Macros$$ Request Help to make code more efficient.

HI, Try out the following: Sub trial() Dim rng As Range Dim what(9) As String what(1) = "FD" what(2) = "EX" what(3) = "NA" what(4) = "NB" what(5) = "NC" what(6) = "HN" what(7) = "CLD" what(8) = "Location" what(9) = "of" For i = 1 To 9 Do Se

$$Excel-Macros$$ Does anybody have games

Hi All, Does anybody have games in excel sheet, if so please send me. Thanks, Naniram -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailyti

$$Excel-Macros$$ Excel, go through Column B

All: I have the following sub that will go down Column B and stop if there is no more value presented. However, it only works on currently active sheet. How do I modify it so that I can specify a specific work sheet named "furniture"? Sub GoColumnB() Dim rngClnB As Range, Cell As Range Set rn

RE: $$Excel-Macros$$ Request Help to make code more efficient.

Hi Jason, One way of speeding this up is to use: Application.ScreenUpdating=False at the beginning of your code. (And don't forget the Application.ScreenUpdating=True at the end.) But I'm sure we could speed it up in other ways as well. Any chance of attaching the file, or a sample file? Reg

RE: $$Excel-Macros$$ VBA VLookup dates

You're welcome. Glad to help. Dave. > Date: Tue, 6 Apr 2010 03:47:24 -0700 > Subject: Re: $$Excel-Macros$$ VBA VLookup dates > From: andyr...@hotmail.co.uk > To: excel-macros@googlegroups.com > > Dave, > > Apologies for the late response. > > Very much appreciate the effort you have put into

Re: $$Excel-Macros$$ Plz Help me urgent

Good one guyz nice to see such creative formulas, here is my share of knowledge. Kindly check out the index match function without adding additional column. Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless On Tue, Apr 6, 2010 at 4:59 PM, Born to Win wrote: > your welcome. > >

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

Hi Gaurav, Did you try my solution? =(D3 - C3) * 24 * 60 What's wrong about that? The result remains numeric, while Ashish's solution becomes text! cu Paul Willekens -- -- Some important links for excel users: 1. F

$$Excel-Macros$$ Re: Modifying input data

Hi Harpreet, Here it comes... I made a new sheet "test" to test it, but you can change that statement in cCooked = "MODIFIED DATA" after testing, of course. Feedback is welcome. Kind regards, Paul Willekens '=== Sub CookData()

$$Excel-Macros$$ Re: Any Excel file for Payroll

I have designed Excel base Payroll program but it is for India Please download from www.jiguparmar.com and see whether It may helful to You. On Apr 6, 5:22 pm, "Vasi S D" wrote: > Hi, > > I am looking for a format in Excel for Payroll & Overtime compatiable to UAE > > With Summary reports. > > Th

Re: $$Excel-Macros$$ Re: Help: OUTLOOK VBA

You ought to look for an Outlook VBA group. this group is focused on Excel VBA. With all microsoft applications, VBA has sepecific capabilities for each application. For instance, Outlook and Word have no use for a .Range object. at the same time, Excel has no use for a .Body object. your questio

Re: $$Excel-Macros$$ HELP: Appending multiple sheet into one

are the workbook names listed somewhere? or are they all in one folder? Paul From: janet dickson To: excel-macros@googlegroups.com Sent: Tue, April 6, 2010 1:18:13 PM Subject: $$Excel-Macros$$ HELP: Appending multiple sheet into one Hello Team I have more tha

$$Excel-Macros$$ HELP: Appending multiple sheet into one

Hello Team I have more than 52 workbooks each contain 3 sheets but only one sheet "sheet1" contain data. all sheets containing data have the same column names in the 1st row, i want to append all sheets into one excel sheet. Please send me some codes to accomplish the task. Thanks in advance Jen

Re: $$Excel-Macros$$ Re: Help: OUTLOOK VBA

Okay Am looking for codes to forward emails which am receiving in my OUTLOOK 2007 to my second mail/Account and if some emails contain attachment, then all email with attachment file >=3MB will be excluded automatically. I hope you understood Thanks for helping Jenie.. On Tue, Apr 6, 2010 at 8:2

$$Excel-Macros$$ Request Help to make code more efficient.

Hello all fellow fellow Macro friends :) I have a short bit of code that I was wondering if it's possible to make it run more efficiently. When it runs currently it takes up to 1 minute which seems like a long time. Notes: This is designed to remove an entire row if the condition is met. There is

Re: $$Excel-Macros$$ Urgent Help

Done, see attach On Tue, Apr 6, 2010 at 7:44 PM, sudhir kumar wrote: > *Hi friends* > ** > *Please help me urgent* > *problem of Hlookup formula in attached file. > * > -- > Sudhir Verma > Asstt. Mngr. A/c's > 9211219649 > > -- > > -

$$Excel-Macros$$ Re: Modifying input data

Thanks Seema and Paul, for posting your reply to my problem. I am aware of the fuctionality to import data from text files. Seema: the file you have attached is the exact point from where i have my problem, i need to modify the input data from here. If you see at Column A: you will find the foll

$$Excel-Macros$$ Urgent Help

*Hi friends* ** *Please help me urgent* *problem of Hlookup formula in attached file. * -- Sudhir Verma Asstt. Mngr. A/c's 9211219649 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips trick

Re: $$Excel-Macros$$ list of file name from explorer to excel

Hi Shyam, I created a folder on C ; & on D; and copied the file to the folder from the server when I run the Macro , I get an error as below : "Run time error 445 Object doesn't support this action"  Regards, Vishal Chaturvedi Mo# +971504532896 From: rf

Re: $$Excel-Macros$$ hi-help required .

thanks ..thanks a lot. one little doubt...if i delete or add a qty in the list...then pivot table is not updated immediately ? i need it to be updated regards,sarvesh lahoti. --- On Tue, 6/4/10, rf1234 rf1234 wrote: From: rf1234 rf1234 Subject: Re: $$Excel-Macros$$ hi-help required . To: exce

Re: $$Excel-Macros$$ Group Data

Thanks AJ I was able to solve the problem. Thanks again!! On Mar 26, 12:18 am, Abhishek Jain wrote: > Hi, > > A sample file of your query would help to understand better, please attach > if possible. However, you may try subtotal. Data>Subtotal. > > Cheers! > > AJ > > > > On Thu, Mar 25, 2010 at

Re: $$Excel-Macros$$ list of file name from explorer to excel

Hi Shyam, I can save the folders in my desktop for sure as I do have an access .. Please advice the solution .. I am greatful to you for giving me light in the tunnel Further , do advice me where i have to change the path names in the Macro or the solution.  Regards, Vishal Chaturvedi Mo#

Re: $$Excel-Macros$$ Plz Help me urgent

your welcome. Thanks, Chandrabhan Singh 9911255330 On Tue, Apr 6, 2010 at 3:57 PM, Anil Saxena wrote: > Thanks Lot Chandrabhan Singh Ji > > > > On Tue, Apr 6, 2010 at 2:24 PM, Born to Win wrote: > >> Dear Mr. Saxena, >> >> Please find Attached file. >> >> Thanks, >> Chandrabhan Singh >> 991125

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

Hi, Ashish Koul is right. His formula is working prefectly fine. Superb Ashish. Cheers Gaurav Jain On Tue, Apr 6, 2010 at 10:44 AM, seema mba wrote: > Hi, > > I have attached your sheet with formula for finding the difference in > minutes. > > I have used the formula CONVERT. > If the CONVE

Re: $$Excel-Macros$$ VBA VLookup dates

Dave, Apologies for the late response. Very much appreciate the effort you have put into this - it works perfectly! Thanks again! Andy. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

Re: $$Excel-Macros$$ list of file name from explorer to excel

Hello Dear, I do not know. that is there any way,to bypass network security and access that folder,but if u can save that folder in your pc,then i can provide u the macro, which will display or list file in particular folder. Hope it Will Help Happy To Help :) Shyam On Tue, Apr 6, 20

Re: $$Excel-Macros$$ How can I Add tool tips to each of list items ?

Hello Dear, I am using excel 2003. Ok,So generally we can add text on our controlls which can be highlighted after any event triggers..i.e MouseOver MouseClick ETC. If you want to create your sample 1.use the stem. Tools-->Macro-->Visual Basic Editor-->Insert-->UserForm-->Addcontrols(TOOLS)

Re: $$Excel-Macros$$ Plz Help me urgent

Thanks Lot Chandrabhan Singh Ji On Tue, Apr 6, 2010 at 2:24 PM, Born to Win wrote: > Dear Mr. Saxena, > > Please find Attached file. > > Thanks, > Chandrabhan Singh > 9911255330 > > > > On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena wrote: > >> >> >> Hi Dilip >>> plz do the needful it is urgent >>

$$Excel-Macros$$ list of file name from explorer to excel

Dear All, I am looking for a solution which can provide me the list of file names from a folder which has sub folders on a server (not on my desktop) in excel Few pointers : - I am using excel 2007 - the server is a restricted server and can be accessed only if permission is provided I did goo

Re: $$Excel-Macros$$ How can I Add tool tips to each of list items ?

Dear Sir May i know how can we use that excel tool tip file. sry i m new to excel but like this group much its help me a lot pls tell me the way how can we use that as i m clicking on that there is some id type is there and nothing else please suggest me Regards On 4/6/10, rf1234 rf1234 wrote

Re: $$Excel-Macros$$ Plz Help me urgent

Dear Anil Saxena Find attached solution to your problem. Hope this suffies Regards Sivakumar ES On Tue, Apr 6, 2010 at 12:40 PM, Anil Saxena wrote: > Hi Dilip > plz do the needful it is urgent > > I want the same ans match with ID and Questions ? > > Plz Sir show the Formula also > > > > > Re

Re: $$Excel-Macros$$ How can I Add tool tips to each of list items ?

Dear Sir May i know how can we use that excel tool tip file. sry i m new to excel but like this group much its help me a lot pls tell me the way how can we use that as i m clicking on that there is some id type is there and nothing else please suggest me Regards LKmodi On 4/6/10, rf1234

Re: $$Excel-Macros$$ Plz Help me urgent

You're welcome Anil. On Tue, Apr 6, 2010 at 2:09 PM, Anil Saxena wrote: > Thanks to Lot Abhishek Ji > about help me thanks > > > On Tue, Apr 6, 2010 at 1:55 PM, Abhishek Jain wrote: > >> Dear Anil, >> >> Please see the attached file. I've used an array formula. Press >> Ctrl+Shift+Enter while app

Re: $$Excel-Macros$$ Plz Help me urgent

Dear Mr. Saxena, Please find Attached file. Thanks, Chandrabhan Singh 9911255330 On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena wrote: > > > Hi Dilip >> plz do the needful it is urgent >> >> I want the same ans match with ID and Questions ? >> >> Plz Sir show the Formula also >> >> >> >> >> Regar

Re: $$Excel-Macros$$ Plz Help me urgent

Thanks to Lot Abhishek Ji about help me thanks On Tue, Apr 6, 2010 at 1:55 PM, Abhishek Jain wrote: > Dear Anil, > > Please see the attached file. I've used an array formula. Press > Ctrl+Shift+Enter while applying it. Also to ease the formula, I've defined > the range names. > > Let me know if y

Re: $$Excel-Macros$$ Plz Help me urgent

Dear Anil, Please see the attached file. I've used an array formula. Press Ctrl+Shift+Enter while applying it. Also to ease the formula, I've defined the range names. Let me know if you need any further help on this. Dilip's friend... :) Abhishek On Tue, Apr 6, 2010 at 12:40 PM, Anil Saxena wr

Re: $$Excel-Macros$$ Plz Help me urgent

check it if this helps u On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena wrote: > > > Hi Dilip >> plz do the needful it is urgent >> >> I want the same ans match with ID and Questions ? >> >> Plz Sir show the Formula also >> >> >> >> >> Regards >> >> Anil Saxena >> >> -- >> >> ---

Re: $$Excel-Macros$$ How can I Add tool tips to each of list items ?

Hello Dear, Attached workbook have the solution for your proble. Hope it Will Help Happy To Help :) Shyam On Tue, Apr 6, 2010 at 1:26 PM, Anantha wrote: > Hello Folks, > > Can someone help me in adding tooltips for each listbox items > selected. > > I'm using Excel 2007

$$Excel-Macros$$ How can I Add tool tips to each of list items ?

Hello Folks, Can someone help me in adding tooltips for each listbox items selected. I'm using Excel 2007 and using list box from Active x control. Thanks in Advance, Regards, Anantha -- -- Some important links f

Re: $$Excel-Macros$$ Plz Help me urgent

Hi Dilip > plz do the needful it is urgent > > I want the same ans match with ID and Questions ? > > Plz Sir show the Formula also > > > > > Regards > > Anil Saxena > > -- > > -- > Some important links for excel users:

Re: $$Excel-Macros$$ hi-help required .

Here is the solution attached you can do it with the help of sumproduct formula or with Sumif Formula Regards Hemant On Mon, Apr 5, 2010 at 2:24 PM, Sarvesh wrote: > > hi > > i have a worksheet where sizes and qty are maintained for each item in this > way > > 460*12 Pet 31 460*12 Pet 265 46

Re: $$Excel-Macros$$ Importing Text file

HI, Right Click .txt file and open with excel just try it On Mon, Apr 5, 2010 at 2:37 PM, Mahesh wrote: > Dear All, > > Need ur advise... > > I got around 20 text files in a day,which had 13 to 15 columns separated by > "|" this sign. each file contains around 15 lacs or more line items. >

Re: $$Excel-Macros$$ hi-help required .

Hello Dear, Use the following instruction. Select Range Data Menu Pivot Table And Pivot Chart Report Next("Follow the instruction") or go to link below http://www.cpearson.com/excel/pivots.htm http://www.contextures.com/xlpivot07.html Hope it Will Help Happy to Help :) Shyam On Tue,

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

Hi Sandeep, Just try the simple function as follows... on row 3 =(D3 - C3) * 24 * 60 make sure the editing of the result column is standard (i.e. nothing) Let me know... Greetings Paul Willekens -- -- Some impor

$$Excel-Macros$$ Plz Help me urgent

Hi Dilip plz do the needful it is urgent I want the same ans match with ID and Questions ? Plz Sir show the Formula also Regards Anil Saxena -- -- Some important links for excel users: 1. Follow us on TWITTER f

Re: $$Excel-Macros$$ Worksheets password break

Thanks alot Shyam, But it has VBA Password ,will you please help me in breaking that password. Regards, Kumara Datta On Mon, Apr 5, 2010 at 6:01 PM, rf1234 rf1234 wrote: > Hello Dear > > Try to use > tools--> unprotect workbook > > tools-->unprotect sheets > > tools-->unprotect & share wo

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

Hi, I have attached your sheet with formula for finding the difference in minutes. I have used the formula CONVERT. If the CONVERT function is not available, install and load the Analysis ToolPak add-in. On the Tools menu, click Add-Ins. In the Add-Ins available list, select the Analysis ToolPak

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

Dear sandeep, Please Find Attached File Thanks, Chandrabhan 2010/4/6 ╚►♥ѕαη∂єєρ♥◄╝ > > Hi All, > > I want to calculate difference between two date , but i want result > in minute's. > please suggest function, > Please find attached & if u r sending solved reply Please "CC" > sandeepxxxku...@gm

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

Sandeep, Please check the attached file. I used a custom format of "[m]:ss" (without quotes). Remove ":ss" part if you don't want seconds. Is this what you want ? Best, AJ 2010/4/6 ╚►♥ѕαη∂єєρ♥◄╝ > > Hi All, > > I want to calculate difference between two date , but i want result > in minute'

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

=TEXT(D5-C5,"[MM]") On Tue, Apr 6, 2010 at 10:06 AM, ashish koul wrote: > =TEXT(D5-C5,"[MM]") > > 2010/4/6 ╚►♥ѕαη∂єєρ♥◄╝ > > >> Hi All, >> >> I want to calculate difference between two date , but i want result >> in minute's. >> please suggest function, >> Please find attached & if u r sending

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

=TEXT(D5-C5,"[MM]") 2010/4/6 ╚►♥ѕαη∂єєρ♥◄╝ > > Hi All, > > I want to calculate difference between two date , but i want result > in minute's. > please suggest function, > Please find attached & if u r sending solved reply Please "CC" > sandeepxxxku...@gmail.com > > > > -- > > Thanks & Regards: >