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

Want to excel formula on this Regards, Mohd Sadiq On Nov 21, 2016 6:54 PM, "Paul Schreiner" wrote: > OK, I'd need a bit more information. > I can make LOTS of assumptions, but I'd rather not do this multiple times. > > So, for each row of data, you want to determine

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

OK, I'd need a bit more information.I can make LOTS of assumptions, but I'd rather not do this multiple times. So, for each row of data, you want to determine the FIRST column containing WO and the LAST column containing WO. Are you wanting to use VBA or Excel functions?  A simple function would

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

Team , Pls update on this On Sat, Nov 19, 2016 at 2:00 AM, Mohd Sadiq wrote: > Team , I have data where I want to first date of "WO" and last date of > Week off in a week. > > attached is the excel sheet for your reference. > > Pls treat it on priority > > > > Regards >

$$Excel-Macros$$ Need help on Excel

Team , I have data where I want to first date of "WO" and last date of Week off in a week. attached is the excel sheet for your reference. Pls treat it on priority Regards Mohd Sadiq 979223 -- 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)

$$Excel-Macros$$ Need help with excel formula !!!

Hello Team, Can someone assist me with the excel formula based on the criteria from B44 to B50, PFA the excel file. Thanks in advance. -- Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of

$$Excel-Macros$$ Need help for Excel - sort expiry date in a seperate sheet

Hi Friends, I am having data in a excel which contains records of maturity deposits/securities in different. sheets the only common field is Maturity Date in all sheets. Now what i need is to sort the records in a separate sheet which are due within next 7 days from today when i run macro.

Re: $$Excel-Macros$$ Need help for Excel - sort expiry date in a seperate sheet

attach the sample file On Sat, Oct 27, 2012 at 10:41 PM, Rupendra Phatak rup...@gmail.com wrote: Hi Friends, I am having data in a excel which contains records of maturity deposits/securities in different. sheets the only common field is Maturity Date in all sheets. Now what i need is to

RE: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

Else MsgBox Range(rngValues).Value End If End If End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Pascal Baro Sent: Jan/Sun/2012 09:44 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need help in Excel-VBA

Re: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

dguille...@gmail.com From: Pascal Baro Sent: Sunday, January 29, 2012 10:13 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding Hi Ashish, Please find another version. With this, I've worked out the fact your data source is only

RE: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

If End If End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Bhalara Sent: Jan/Thu/2012 12:30 To: excel-macros@googlegroups.com Subject: Fwd: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding Dear

$$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

Dear experts, I have lower level knowledge in excel vba, so please check below coding which not working. I need the Msgbox when entered value match from another sheet. The example sheet attached herewith. Please also know the basic rules of how to use excel function in Visual Basic. Kindly solve

Fwd: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

Dear experts, I have lower level knowledge in excel vba, so please check below coding which not working. I need the Msgbox when entered value match from another sheet. The example sheet attached herewith. Please also know the basic rules of how to use excel function in Visual Basic. If

Re: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

Dear Ashish, Please try below code... Function check_value(rng As Range) As String Dim cell, rng1 As Range Set rng1 = Sheet2.Range(D4:D10) For Each cell In rng1 If cell.Value = rng.Value Then MsgBox Bill is made of this Chassis, vbInformation End If Exit Function Next cell End Function see

Re: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

Dear Ashish, Excel 2007 File Type Extension - xlsx - Excel http://en.wikipedia.org/wiki/Microsoft_Excel 2007 XML Workbook - xlsm - Excel 2007 XML Macro-Enabled Workbook - xltx - Excel 2007 XML Template - xltm - Excel 2007 XML Macro-Enabled Template - xlsb - Excel 2007 binary

Re: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

Dear Ashish, Please ignore previous mail..use it Function check_value(rng As Range) As String Dim cell, rng1 As Range Set rng1 = Sheet2.Range(D4:D10) For Each cell In rng1 If cell.Value = rng.Value Then MsgBox Bill is made of this Chassis, vbInformation Exit Function End If Next cell End

Re: $$Excel-Macros$$ need help in excel - data merge acorrs columns

use concatenate function or operator like =A1 B1 C1 etc On Tue, Mar 8, 2011 at 3:02 PM, sudhir kumar bluecore...@gmail.com wrote: Hi, Can u send Excel Sheet of this example. thanx On 7 March 2011 12:17, Krish kandy.kr...@gmail.com wrote: Hi , I have data in row and column

$$Excel-Macros$$ need help in excel - data merge acorrs columns

Hi , I have data in row and column 1-3, and needs to club the data in single row and column since the data acorss three columns, Pls help me. Regards, Krish Kandy. -- -- Some important links for excel users: 1.

$$Excel-Macros$$ Need help on Excel Dynamic List

Hi, I have two columns A and B. column A contains list of tasks and column B contains sub-tasks against each primary task. i would like to have two drop down cells in column C and D. whenever i select an option in the dropdown in cell C1, the list in D1 should show only the sub-tasks that

Re: $$Excel-Macros$$ Need help on Excel Dynamic List

Hi Sharath, Please check the attached file which has the resolution as per your requirements. :) Best Regards, DILIPandey On Wed, Dec 8, 2010 at 7:38 PM, Sharath Sambrani sharath.c.sambr...@gmail.com wrote: Hi, I have two columns A and B. column A contains list of tasks and column B

Re: $$Excel-Macros$$ Need help on Excel Dynamic List

: $$Excel-Macros$$ Need help on Excel Dynamic List To: excel-macros@googlegroups.com Cc: sharath.c.sambr...@gmail.com Hi Sharath, Please check the attached file which has the resolution as per your requirements. :) Best Regards, DILIPandey On Wed, Dec 8, 2010 at 7:38 PM, Sharath Sambrani

Re: $$Excel-Macros$$ Need help on excel sheet

: Manjunath C cmanjunathchen...@gmail.com Subject: Re: $$Excel-Macros$$ Need help on excel sheet To: excel-macros@googlegroups.com Date: Wednesday, December 1, 2010, 12:15 AM No,  I have different data (place wise) in 5 tabs, my expectation is that wile pasting the raw data in the first sheet

$$Excel-Macros$$ Need help on excel sheet

Hi All, Can anyone help me, I have data in 5 tabs, now i need to make it in seperate excel sheet and paste it local desktop. Any macros available - appreciate your help in advance. Thanks Manjunath -- -- Some

Re: $$Excel-Macros$$ Need help on excel sheet

, Manjunath C cmanjunathchen...@gmail.com wrote: From: Manjunath C cmanjunathchen...@gmail.com Subject: $$Excel-Macros$$ Need help on excel sheet To: excel-macros@googlegroups.com Date: Tuesday, November 30, 2010, 4:12 AM Hi All,   Can anyone help me, I have data in 5 tabs, now i need to make

$$Excel-Macros$$ need help on Excel VBA: refEdit control

Hello there, I need to have users to select the range in the spreadsheet and use what's selected to do further action. Is refEdit the right one to use? The ideal would be: when user selects the range, in the refEdit box it shows the values in the selected range. For example, A in A1, B in A2, C

Re: $$Excel-Macros$$ need help in excel

Thank you for all of my excel experts. On Wed, Dec 2, 2009 at 1:50 PM, Shilpa Rao shilpa...@gmail.com wrote: Hi Friends, I have 2 excel file having 12 sheets in it, what I want is to merge two file into one. I tried using move or copy but it din't work. Is there any method. Please not that

Re: $$Excel-Macros$$ need help in excel

This info helped me too. On Tue, Dec 15, 2009 at 1:24 PM, vinod rao vinod.ma...@gmail.com wrote: Thank you for all of my excel experts. On Wed, Dec 2, 2009 at 1:50 PM, Shilpa Rao shilpa...@gmail.com wrote: Hi Friends, I have 2 excel file having 12 sheets in it, what I want is to merge

Re: $$Excel-Macros$$ need help in excel

Hi Shilpa, please send me file Regards Amresh On Wed, Dec 2, 2009 at 1:50 PM, Shilpa Rao shilpa...@gmail.com wrote: Hi Friends, I have 2 excel file having 12 sheets in it, what I want is to merge two file into one. I tried using move or copy but it din't work. Is there any method. Please

Re: $$Excel-Macros$$ need help in excel

Hi Shilpa, Open both the files(Ex:- A B) and the select all the sheet u want move from B to A. Then right click on the tab and select move, w will see a new pop- up select Sheet A and press ok. On Wed, Dec 2, 2009 at 1:50 PM, Shilpa Rao shilpa...@gmail.com wrote: Hi Friends, I have 2

RE: $$Excel-Macros$$ need help in excel

Hi Shilpa, Just to add to Mahesh's email .. this will work if you open both Excel workbooks in the same Excel 'window'. Thanks, Amitabh Date: Wed, 2 Dec 2009 17:00:52 +0530 Subject: Re: $$Excel-Macros$$ need help in excel From: mahender.bi...@gmail.com To: excel-macros

Re: $$Excel-Macros$$ need help in excel

...@hotmail.com Hi Shilpa, Just to add to Mahesh's email .. this will work if you open both Excel workbooks in the same Excel 'window'. Thanks, Amitabh -- Date: Wed, 2 Dec 2009 17:00:52 +0530 Subject: Re: $$Excel-Macros$$ need help in excel From: mahender.bi

$$Excel-Macros$$ need help with excel macro

I have put one listbox add some '.xls' file path through inputbox and store as a button in a toolbar. now want to open listindex files.e.g : listbox contains 5 '.xls'-files when am clicking file path name its opening in new workbook.can any body help me about this?.

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

*Dear All,* * * *I am new in this group. And I really like the posting that you all have made. It's a very useful group as I am getting new things to learn. Could you please provide with help for the following topics below.* * * *I would appreciate if some one can send the material for the