$$Excel-Macros$$ To seek help on displaying the first column and a given active column

Hi I need a VBA Macro that will do the following: 1) Always display the first column (Column A) & its value 2) On clicking a column heading (any one column from column B to Column AAA), only that column gets displayed along with Column A 3) On clicking a cell in unused area of the excel sheet, th

$$Excel-Macros$$ To automate the transformation of a data column to a two dimensional table

I need help of expert, in the attachment, when I run the macro it transform the data column to the two dimensional table, but the problem arises when I run this macro it takes only the first column data instead the three column, in this regard I need the expert help. -- Are you =EXP(E:RT) or =NO

Re: $$Excel-Macros$$ to pickup only require number or word

pfa On Tue, Jun 13, 2017 at 6:27 PM, wrote: > > Respected All, > > please help me to separate the require number or word in excel,means how > can i separate of pick the numbers or alphabet which only i need.for the > example i am attaching the excel sheet > > -- > Are you =EXP(E:RT) or =NOT(EXP(

$$Excel-Macros$$ to pickup only require number or word

Respected All, please help me to separate the require number or word in excel,means how can i separate of pick the numbers or alphabet which only i need.for the example i am attaching the excel sheet -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,

Re: $$Excel-Macros$$ to add - sign in vehical number

thank so much for help me now its easy for me, once again thanks a lot. On Tue, Feb 21, 2017 at 5:49 PM, Paul Schreiner wrote: > Its simple enough to determine the last 4 characters using the right() > function. > But because the length varies (from 7 to 11), you need to be a bit more > "cre

Re: $$Excel-Macros$$ to add - sign in vehical number

On Tue, 2/21/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ to add - sign in vehical number To: "excel-macros@googlegroups.com" Date: Tuesday, February 21, 2017, 2:19 PM Its simple enough to determine the last 4 characters

Re: $$Excel-Macros$$ to add - sign in vehical number

Its simple enough to determine the last 4 characters using the right() function.But because the length varies (from 7 to 11), you need to be a bit more "creative" with the left() function. try inserting a column with:=LEFT(F3,LEN(F3)-4)&"-"&RIGHT(F3,4) copy to all rows, then copy/paste Values to

Fwd: $$Excel-Macros$$ To seek help on writing Excel formula

& regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valuation, Deloitte US India Gurgaon India Mob:-+91-8588802543 -- Forwarded message -- From: Sandeep Kumar Baranwal Date: Sun, Sep 11, 2016 at 6:39 PM Subject: Re: $$Excel-Macros$$ To seek he

Re: $$Excel-Macros$$ To seek help on writing Excel formula

Hi Kindly note that the match operation is to be performed basis the variable "dataset" in "Sheet1" and Variable_sheet2 in "Sheet1" should be populated using "Sheet2". Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valuation, Deloitte US India Gurgaon India

Re: $$Excel-Macros$$ To seek help on writing Excel formula

Is there any relation between both sheets? If yes you can use vlookup. It would be great if you can upload (attache) some sample data with your requirement -- On Fri, Sep 9, 2016 at 5:17 PM, Sandeep Kumar Baranwal < sandeepkumarbaran...@gmail.com> wrote: > Hi > > I have a spreadsheet with two t

$$Excel-Macros$$ To seek help on writing Excel formula

Hi I have a spreadsheet with two tab: Sheet1 has three variable: NameFirstNameLastName abc_xyz abc xyz rpm_xyz rpm xyz Sheet2 has one variable: Name abc_xyz rpm_xyz I need to write an excel formula in Sheet1 such that I obtain: NameFirs

Re: $$Excel-Macros$$ To Print .msg Files Saved in Folder

Where did the .msg files come from?By looking online, it sounds like .msg files COULD be: MSG is a file extension for a mail message file format used by Microsoft Outlook and Exchange.  An MSG file can contain plain ASCII text for the headers and the main message body as well as hyperlinks and

$$Excel-Macros$$ To Print .msg Files Saved in Folder

Dear All, I have the below macro in excel which opens and takes print of a word file saved in a folder. In the same way i need to print .msg file saved in a folder, could you please guide me how to edit the macro to do the same. I am using Excel 2016. Appreciate if anybody could help me on this.

Re: $$Excel-Macros$$ to change cell value in Column A daily

Hi Paul, Thank you for your reply. Thanks a lot for your suggestion. I've changed to use another way for the time being. Hope you have a very nice day! Cheers On Thursday, 18 February 2016 20:59:51 UTC+8, Paul Schreiner wrote: > > "Without opening the file manually".. > I think there's a way

Re: $$Excel-Macros$$ to change cell value in Column A daily

"Without opening the file manually"..I think there's a way to do that, but from what I understand the technique still requires the excel file with the macro to be open. Instead, you can write macro that tests for the current date/time and changes  the cell when the file is opened.(it would then s

$$Excel-Macros$$ to change cell value in Column A daily

Hi all, I have an xlsm sheet and would like to change the cell content in Column A at 9am everyday. If cell value in column A equals to "Yes" today, then it needs to be changed to "No" automatically at 9am tomorrow without opening the file manually. May I know how can I get this done? Please s

$$Excel-Macros$$ To insert new row below when the data is unmatched

Hi all, I'm trying to insert a new row below the matched data in trial.xlsm and copy the unmatched data and write 'New' in column B when the data is found unmatched. However, I can't achieve this. I've attached the pp.xlsx file in which the Sheet2 in pp.xlsx is the result that I want to achiev

Re: $$Excel-Macros$$ To seek help on fuzzy text matching of list of 30000 text values from a list of 300000 text values

Hi Ashish Koul Do you have the excel template for the same? I think I will not be able to download it on my office laptop. Is there any way out to do the same? Thanks and regards Sandeep Kumar Baranwal > On Aug 14, 2015, at 10:39 PM, ashish koul wrote: > > download fuzzy match addin > http:

Re: $$Excel-Macros$$ To seek help on fuzzy text matching of list of 30000 text values from a list of 300000 text values

download fuzzy match addin http://www.microsoft.com/en-in/download/details.aspx?id=15011 On Fri, Aug 14, 2015 at 10:38 PM, wrote: > Hi > > Could anyone help me in performing fuzzy text matching of a list of 3 > text values from a list of 30 text values? > If you have a spreadsheet templa

$$Excel-Macros$$ To seek help on fuzzy text matching of list of 30000 text values from a list of 300000 text values

Hi Could anyone help me in performing fuzzy text matching of a list of 3 text values from a list of 30 text values? If you have a spreadsheet template from the same, could you please send it across to me? Thanks and regards Sandeep Kumar Baranwal -- Are you =EXP(E:RT) or =NOT(EXP(E:

Re: $$Excel-Macros$$ To Select a Pivot Item

Dear Faisal, Can u pls elborate more detail? I unable to understand your requirement. Regards, Gawli Anil On Sat, Mar 14, 2015 at 3:34 PM, Faisal Pk wrote: > Can anybody help me with a solution. > > Regards, > Faisal PK > > On Fri, Mar 13, 2015 at 11:04 AM, Faisal Pk wrote: > >> I have the b

Re: $$Excel-Macros$$ To Select a Pivot Item

Can anybody help me with a solution. Regards, Faisal PK On Fri, Mar 13, 2015 at 11:04 AM, Faisal Pk wrote: > I have the below code to select an item from the Pivotfield "Customer". > > Request if anybody can help with a code which don't loop through each item > because it leads slow performance

Re: $$Excel-Macros$$ To find ADO object reference

Hi check this.. http://stackoverflow.com/questions/9879825/how-to-add-a-reference-programmatically-vba-excel do let us know for further help... Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Dec 9, 2014 at 7:25 PM, Eugene Bernard wrote: > How to f

$$Excel-Macros$$ To find ADO object reference

How to find programattically using VBA, whether Ms-ADO object is already referenced in my excel vba project. TIA Eugene [image: Inline image 1] On Mon, Dec 8, 2014 at 4:51 PM, Rakesh wrote: > hello Experts, > > Need an index formula which combined the index which have na data > > reference

Re: $$Excel-Macros$$ To create a sheet with macro and overwrite on next attempt

Thank you everyone. On Fri, Nov 14, 2014 at 5:42 PM, Ashish Kumar wrote: > Hi Pravin, > > PFA!! > > > Edit your data in Pending CN and Highlight the row which you want to paste > in Party Wise and hit the macro. > > > > Regards > Ashish > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in E

Re: $$Excel-Macros$$ To create a sheet with macro and overwrite on next attempt

r you can.” - John Wesley - > > From: Pravin Gunjal >To: excel-macros@googlegroups.com >Sent: Friday, November 14, 2014 2:07 AM >Subject: Re: $$Excel-Macros$$ To create a sheet with macro and overwri

Re: $$Excel-Macros$$ To create a sheet with macro and overwrite on next attempt

Hi Pravin, PFA!! Edit your data in Pending CN and Highlight the row which you want to paste in Party Wise and hit the macro. Regards Ashish -- 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 @

Re: $$Excel-Macros$$ To create a sheet with macro and overwrite on next attempt

*Hi Paul :* If I add this code in my code it creates new sheet and deletes immediately. Pl look in to this. *Hi Ashish :* Your file is creating new sheet every time but I want the same sheet to be overwritten with changes. Thank you, On Thu, Nov 13, 2014 at 7:46 PM, Ashish Kumar wrote: > Hi P

Re: $$Excel-Macros$$ To create a sheet with macro and overwrite on next attempt

Hi Pravin, PFA.!! Regards Ashish -- 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 RULES 1) Use concise, accurate thread titles. Poor thread titles,

Re: $$Excel-Macros$$ To create a sheet with macro and overwrite on next attempt

From: Pravin Gunjal >To: excel-macros@googlegroups.com >Sent: Thursday, November 13, 2014 7:53 AM >Subject: $$Excel-Macros$$ To create a sheet with macro and overwrite on next >attempt > > > >Hi, > >I have recorded a macro to create a new sheet called "

$$Excel-Macros$$ To create a sheet with macro and overwrite on next attempt

*Hi,I have recorded a macro to create a new sheet called "Party Wise" based on the info available in sheet called "Pending CN"When I go for second attempt it's giving an error because of the sheet name.Could you please look in to this and arrange a solu

Re: $$Excel-Macros$$ To one digit calculation

please share the sample sheet . Enjoy Team XLS On Thu, Nov 28, 2013 at 8:53 PM, Kongsambath PEN wrote: > Hi there, > > Hi, > > Please help me out in excel to find functions in the result cell following > by calculation. > > >

$$Excel-Macros$$ To one digit calculation

Hi there, Hi, Please help me out in excel to find functions in the result cell following by calculation. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:I

$$Excel-Macros$$ How to connect Excel macros to Quality center

Plz send the process as iam new to QC -- 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 RULES 1) Use concise, accurate thread titles. Poor thread titles, li

Re: $$Excel-Macros$$ To Share and View Excel Dashboards.

It can be possible through Google Drive or Sky Drive. On 26 October 2013 17:22, Excel_Lover wrote: > Dear All, > > What is the best way to share and View the excel dashboard online. > > Basically, We have one excel dashboard which we send by e-mail on > updation. What I need is an alternate sol

Re: $$Excel-Macros$$ To Share and View Excel Dashboards.

try this http://office.microsoft.com/en-in/sharepoint-server-help/introduction-to-excel-services-and-excel-web-access-HA010105476.aspx http://msdn.microsoft.com/en-us/library/ms572330(v=office.14).aspx http://blogs.msdn.com/b/mvpawardprogram/archive/2012/05/21/embedded-excel-services-on-your-websit

$$Excel-Macros$$ To Share and View Excel Dashboards.

Dear All, What is the best way to share and View the excel dashboard online. Basically, We have one excel dashboard which we send by e-mail on updation. What I need is an alternate solution to the users to view this online than downloading it from e-mail every time. Appreciate your suggestions.

Re: $$Excel-Macros$$ to

Visit below group link http://groups.google.com/group/excel-macros. and click on "Apply to joingroup" . Enjoy Team XLS On Sat, Sep 28, 2013 at 10:41 AM, TIWARI wrote: > dear Sir, > How can make new member of excel-macros groups. > > -- > Are you =EXP(E:RT) or =NOT

$$Excel-Macros$$ to

dear Sir, How can make new member of excel-macros groups. -- 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 RULES 1) Use concise, accurate thread titles. Po

Re: $$Excel-Macros$$ To SUM Dynamic Columns

Dear Excel_Lover, it is exactly in attachment you are asking for. Regards, Waseem Saifi On Sat, Jul 20, 2013 at 2:12 PM, Waseem Saifi wrote: > Dear Excel_Lover, > > PFA your query file with solved formula. > > Regards, > Waseem Saifi > > On 7/19/13, Excel_Lover wrote: > > Dear All, > > > > At

Re: $$Excel-Macros$$ To SUM Dynamic Columns

Dear Excel_Lover, PFA your query file with solved formula. Regards, Waseem Saifi On 7/19/13, Excel_Lover wrote: > Dear All, > > Attached is a sample data in which I have some month wise item total, I > need a formula which can calculate SUM of an item from the Month Jan-12 to > till the month w

Re: $$Excel-Macros$$ To SUM Dynamic Columns

ll the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - > >From: Excel_Lover >To: excel-macros@googlegroups.com >Sent: Friday, July 19, 2013 8:29 AM

Re: $$Excel-Macros$$ To SUM Dynamic Columns

ou can, >> In all the ways you can, >> In all the places you can, >> At all the times you can, >> To all the people you can, >> As long as ever you can.” - John Wesley >> *--------- >> >>*From:* Excel_Lover >> *

Re: $$Excel-Macros$$ To SUM Dynamic Columns

can, > To all the people you can, > As long as ever you can.” - John Wesley > *- > > *From:* Excel_Lover > *To:* excel-macros@googlegroups.com > *Sent:* Friday, July 19, 2013 8:12 AM > *Subject:* Re: $$Excel-Macros$$ To SUM Dyn

Re: $$Excel-Macros$$ To SUM Dynamic Columns

esley - > >From: Excel_Lover >To: excel-macros@googlegroups.com >Sent: Friday, July 19, 2013 8:12 AM >Subject: Re: $$Excel-Macros$$ To SUM Dynamic Columns > > > >Dear Mr.Deepak, > > >Thanks for a quick reply, your formula works fine but it's

Re: $$Excel-Macros$$ To SUM Dynamic Columns

the times you can, To all the people you can, As long as ever you can.” - John Wesley --------- > >From: Excel_Lover >To: excel-macros@googlegroups.com >Sent: Friday, July 19, 2013 7:35 AM >Subject: $$Excel-Macros$$ T

Re: $$Excel-Macros$$ To SUM Dynamic Columns

Dear Mr.Deepak, Thanks for a quick reply, your formula works fine but it's not considering the items (A,B,C,D etc), it should also be a criteria because its order may vary. Hope it needed a formula like SUMIF which provides SUM by multiple criteria. Thanks again.. On Fri, Jul 19, 2013 at 2:58

Re: $$Excel-Macros$$ To SUM Dynamic Columns

On Fri, Jul 19, 2013 at 5:05 PM, Excel_Lover wrote: > Dear All, > > Attached is a sample data in which I have some month wise item total, I > need a formula which can calculate SUM of an item from the Month Jan-12 to > till the month which we are selecting in the column D1. > > Appreciate if som

$$Excel-Macros$$ To SUM Dynamic Columns

Dear All, Attached is a sample data in which I have some month wise item total, I need a formula which can calculate SUM of an item from the Month Jan-12 to till the month which we are selecting in the column D1. Appreciate if somebody can help me with formula. Best Regards Excel_Lover -- Are

$$Excel-Macros$$ To know about the substitute of SQL.REQUEST

Hi Kindly note that sql.request is functional in MS Excel 2007 but not in MS Excel 2010. Could you please let me know any VBA code that would be a substitute for sql.request. If yes, Please let me know with the help of an example. We use sql.request to transfer data from MS Access to MS Excel in v

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

est. >> >>> >> >>> On 7/6/13, ravinder negi wrote: >> >>> > PFAtry this and advise if this does not work propery.. you just >> >>> > need >> >>> to >> >>> > copy paste formula in validation rng

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

ose will be also add in list...but your second sheet data should >> > formated as given by you. >> > >> > --- On Sat, 7/6/13, Mangesh Vimay wrote: >> > >> > From: Mangesh Vimay >> > Subject: Re: $$Excel-Macros$$ To create drop down list for ma

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

re > data > > and those will be also add in list...but your second sheet data should > > formated as given by you. > > > > --- On Sat, 7/6/13, Mangesh Vimay wrote: > > > > From: Mangesh Vimay > > Subject: Re: $$Excel-Macros$$ To create drop down li

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

e: > > From: Mangesh Vimay > Subject: Re: $$Excel-Macros$$ To create drop down list for many IDs as per > many lists > To: excel-macros@googlegroups.com > Date: Saturday, July 6, 2013, 11:20 AM > > Hi Be Tran Van, > > Thank you for your quick help. > > Howev

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

Simply Great !!! Could you please share final workbook. Sorry, for this. Thanks a ton !!! On 7/6/13, vba wrote: > Hi > > You dont have to create name, this will be created programatically for data > in DATA sheet. > > Just copy paste B2 or drag down. > > > Hoe Name is created by this Macro: >

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

Hi You dont have to create name, this will be created programatically for data in DATA sheet. Just copy paste B2 or drag down. Hoe Name is created by this Macro: First Data sheet is sort on the basis of ID; then unique ID is pasted in range J2 & downwards. Then Name is defined for each ID begi

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

Hi, Thanks for the help. But, how to create data validations in the first sheet based on the list which you have retrieved by using code. Please help. On 7/6/13, vba wrote: > Hey > > PFA. > > HTH > > > On Sat, Jul 6, 2013 at 11:20 AM, Mangesh Vimay > wrote: > >> Hi Be Tran Van, >> >> Thank you

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

Hey PFA. HTH On Sat, Jul 6, 2013 at 11:20 AM, Mangesh Vimay wrote: > Hi Be Tran Van, > > Thank you for your quick help. > > However, in my original workbook there are total 1200 lists and its > quite time consuming job to create named range for all 1200 lists and > then to specify the source f

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

Hi Be Tran Van, Thank you for your quick help. However, in my original workbook there are total 1200 lists and its quite time consuming job to create named range for all 1200 lists and then to specify the source for all the lists for data validations. Could you please suggest shortcut way/method

$$Excel-Macros$$ To create drop down list for many IDs as per many lists

Hi Friends, I have attached Excel file for the reference. I am unable to create a list for each ID as there are such 1200 lists for many IDs. So I need formula or vba macro to create such drop down lists for every Id given in the column A so that I can select required option from the drop down lis

Re: $$Excel-Macros$$ To count values in a changeble range

Since its focising on sheet1 you got to delete that part... Just put hyphen before the line and before end with line. You may simply delete it also. Hth Vabs On 28 Jun 2013 22:47, "Thiago Souza" wrote: > I'm trying to make it work on the workbook for all sheets, I pasted as you > say and didnt

Re: $$Excel-Macros$$ To count values in a changeble range

I'm trying to make it work on the workbook for all sheets, I pasted as you say and didnt work. So i tried to change With ThisWorkbook.Worksheets("sheet1") for With ThisWokbook.ActiveSheet or With ActiveWorkbook.ActiveSheet, neither of them worked. I dont want to run it on a module where I hav

Re: $$Excel-Macros$$ To count values in a changeble range

Fastest way to learn is try to learn from queries posted here in forum. I have learned VBA thru forum participation. Thanks for Acknowledgement. You can paste code in This workbook so as to get result in all sheet. Alternatively, you can also use in standard module where you have to run this cod

Re: $$Excel-Macros$$ To count values in a changeble range

Very nice, Thank You. I would never get there. I only know the basic programming language for fortran from eng. School. How do I learn VBA like that? Any book you recommend? Backing to work, I made the total days dont count the blank cells, for now everything is perfect. Thank ou so much for your

$$Excel-Macros$$ To count values in a changeble range

I need some help with a code to the workbook uploaded. I'm having a hard time in finding a way to start! The workbook is to control day works of employes where they cannot work more than 183 days in the last 365 continuous days. I need a code where based on the selected cell it shows me anywher

Re: $$Excel-Macros$$ To Add Comments based on Cell Value

Hi Ashish, Thank you very much. Works fine, saved lot of time. Thanks. On Mon, Dec 17, 2012 at 7:11 PM, ashish koul wrote: > Sub add_comment() > Dim i As Long > Dim x As String, found As Range > Dim j As Long, k As Long > > For i = 2 To Sheets("Clients").Range("a1").End(xlDown).Row > Se

Re: $$Excel-Macros$$ To Add Comments based on Cell Value

Sub add_comment() Dim i As Long Dim x As String, found As Range Dim j As Long, k As Long For i = 2 To Sheets("Clients").Range("a1").End(xlDown).Row Set found = Sheets("Details").Range("a:a").Find(Sheets("Clients").Cells(i, 1).Value, LookIn:=xlValues) If Not found Is Nothing Then j

$$Excel-Macros$$ To Add Comments based on Cell Value

Hi All, Good Afternoon!!! Can Somebody help me by giving a macro which can add comments based on a cell value like, In the attached workbook, sheet named 'Clients' I have a list of client codes against which 'Details' sheet they have some requirements in columns named 'Req.1' , 'Req.2', '

$$Excel-Macros$$ to insert rows ,rows inserted should be equal to integer in corresponding cell in the top row

Hi Experts, I need a macro which coluld do the following 1)top row contains integer 1 to 50 from B column to BZ column 2)other rows contain entries in column A 3)Also rows contains one entry beneath the integers in top row the macro should read the columm corresponding to entries in co

Re: $$Excel-Macros$$ To The Group Owner

yes i agree with deepak Please don't banned job posting. On Thu, May 31, 2012 at 12:15 PM, Deepak Pal Singh < deepaktheind...@gmail.com> wrote: > Hi Ayush, > > Rather than banning all job posts you can ban repetitive job posts, > because these job posts really help the group members to find goo

$$Excel-Macros$$ To The Group Owner

Hi Ayush, Rather than banning all job posts you can ban repetitive job posts, because these job posts really help the group members to find good openings. Regards Deepak -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like

Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

Hi Sub kTest() Dim r As Range, s As String s = [c1].Text Set r = Range("c2:c" & Range("d" & Rows.Count).End(3).Row) With r .Cells(1).Offset(-1) = 0 .FormulaR1C1 = "=IF(R[-1]C[2]<>RC[2],R[-1]C+1,IF(COUNTIF(R2C5:RC[2],RC[2])>5,R[-1]C+1,IF(AND(RC[2]=

Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

Sent:* Monday, May 07, 2012 1:18 PM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ To create a serial number based on some > conditions using macro. > > ** ** > > It should be assigned to a button. > > On Mon, May 7, 2012 at 10:4

RE: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

Will the list already be sorted when the button is pressed? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Excel_Lover Sent: Monday, May 07, 2012 1:18 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ To create a serial number based on

Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

; *Sent:* Monday, May 07, 2012 6:48 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ To create a serial number based on some > conditions using macro. > > ** ** > > Dear Mr.Noorain, > > > > Please find the attached sheet with more clarific

RE: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

acros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Excel_Lover Sent: Monday, May 07, 2012 6:48 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro. Dear Mr.Noorain, Please find the attached

RE: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

-macros@googlegroups.com] On Behalf Of Excel_Lover Sent: 08 May 2012 12:57 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro. Dear Rajan, Thanks for your effort, I was seeking for a macro solution for this. How is

Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

Excel_Lover > *Sent:* 07 May 2012 2:50 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ To create a serial number based on some > conditions using macro. > > ** ** > > Dear All, > > > > Appreciate an help to write a macro to crea

Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

Yes Mr. Excel_Lover, Please provide more clarification. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, May 7, 2012 at 2:50 AM, Excel_Lover wrote: > Dear All, > > Appreciate an help to write a macro to create a request number as per the > bel

Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

Was my question not clear? On Mon, May 7, 2012 at 12:20 AM, Excel_Lover wrote: > Dear All, > > Appreciate an help to write a macro to create a request number as per the > below condition. > > for each name on the same date should be a same request number, but should > not be repeated more than

$$Excel-Macros$$ To create a serial number based on some conditions using macro.

Dear All, Appreciate an help to write a macro to create a request number as per the below condition. for each name on the same date should be a same request number, but should not be repeated more than five times. Important: If the date column is blank and Name column having data macro should g

$$Excel-Macros$$ to remove time

CTRL+1 --->Custom format , choose the one you need. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not

RE: $$Excel-Macros$$ to remove time

ubject: $$Excel-Macros$$ to remove time Hi , 12/2/2001 12:00 PM --- How to remove time ? i need only date .. is thr any formula ..Thanks in advance -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Pleas

Re: $$Excel-Macros$$ to remove time

Not much info but you can probably change the format. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: vijayajith VA Sent: Thursday, April 05, 2012 10:54 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ to remove time Hi , 12/2/2001 12:00 PM

Re: $$Excel-Macros$$ to remove time

HI Vijay, You can use very simple formula '=int(your date) Int is basically use for Rounds a number down to the nearest integer. On Thu, Apr 5, 2012 at 9:24 PM, vijayajith VA wrote: > Hi , > > 12/2/2001 12:00 PM --- How to remove time ? i need only date .. is > thr any formula ..Th

Re: $$Excel-Macros$$ to remove time

Thanks Noorain ... & Mareshwaran On Thu, Apr 5, 2012 at 9:36 PM, NOORAIN ANSARI wrote: > Dear Vijay, > > Please try it..after selection the required range.. > > Sub remove_Time() > Dim mycell As Range > For Each mycell In Selection > if vba.isdate(mycell) then > mycell.Value = VBA.Left(mycell, VB

Re: $$Excel-Macros$$ to remove time

Dear Vijay, Please try it..after selection the required range.. Sub remove_Time() Dim mycell As Range For Each mycell In Selection if vba.isdate(mycell) then mycell.Value = VBA.Left(mycell, VBA.InStr(1, mycell, " ") - 1) Selection.NumberFormat = "m/d/" endif Next End Sub On Thu, Apr 5, 20

Re: $$Excel-Macros$$ to remove time

*Try it, =TEXT(INT(A1),"DD/MM/")* On Thu, Apr 5, 2012 at 7:54 PM, vijayajith VA wrote: > Hi , > > 12/2/2001 12:00 PM --- How to remove time ? i need only date .. > is thr any formula ..Thanks in advance > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use conci

$$Excel-Macros$$ to remove time

Hi , 12/2/2001 12:00 PM --- How to remove time ? i need only date .. is thr any formula ..Thanks in advance -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code

Re: $$Excel-Macros$$ To calculate the maximum and minimum appearance in Staff Roster Plan

-macros@googlegroups.com > *Sent:* Tuesday, April 3, 2012 12:02 PM > *Subject:* $$Excel-Macros$$ To calculate the maximum and minimum > appearance in Staff Roster Plan > > Dear all, > > I have a roster with staff allocated on different roster plan, i.e. > different working hour

Re: $$Excel-Macros$$ To calculate the maximum and minimum appearance in Staff Roster Plan

I realy don't know what are you looking for so check if this is what you are looking for.   Regards,   Pawel From: Darwin Chan To: excel-macros@googlegroups.com Sent: Tuesday, April 3, 2012 12:02 PM Subject: $$Excel-Macros$$ To calculate the maximu

Re: $$Excel-Macros$$ To calculate the maximum and minimum appearance in Staff Roster Plan

Dear Darwin, Please find the attached file. {I am not understant exact wt you want in from time & please revert me with sample like count or sum total working hours ) Thanks & Regards Anil Kumar 113784 On Tue, Apr 3, 2012 at 4:32 PM, Darwin Chan wrote: > Dear all, > > I have a roster

$$Excel-Macros$$ To calculate the maximum and minimum appearance in Staff Roster Plan

Dear all, I have a roster with staff allocated on different roster plan, i.e. different working hours. I have a task to analyse the maximum and minimum of staff who would appear at concurrent period. However, volume of data is huge and formula is needed for assistance in analysis. I have atta

$$Excel-Macros$$ To Present a Slab Wise Target and Actual sales in Graph

Dear All, We have two suppliers with different target slabs for a same product, target slabs are as follows: Supplier: A Slab 3% 4% 5% Target 2 25000 3 Actual 25000 Supplier: B Slab 3% 4% 6% Target 15000 25000 3 Actual 25000 Can somebody help me to present it in a

RE: $$Excel-Macros$$ to access in Public Variable of Workbook A module by WorkBook B Procedure

ct.var module.var VBAProject.module.var Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Divaker Pandey Sent: Friday, March 02, 2012 2:11 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ to access in Public Variable of Wo

Re: $$Excel-Macros$$ to access in Public Variable of Workbook A module by WorkBook B Procedure

Still waiting for reply? On Thu, Mar 1, 2012 at 4:47 PM, Divaker Pandey wrote: > > Hi Expert, > > Is there any way to access in Public Variable of Workbook A module by > WorkBook B Procedure. > > if I can't do any modification in Workbook A macros. > > > Thanks in addvance > > -- > FORUM RULES

$$Excel-Macros$$ to access in Public Variable of Workbook A module by WorkBook B Procedure

Hi Expert, Is there any way to access in Public Variable of Workbook A module by WorkBook B Procedure. if I can't do any modification in Workbook A macros. Thanks in addvance -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles

Re: $$Excel-Macros$$ To excel macro team

oday. > > > Don Guillett > > SalesAid Software > > dguille...@gmail.com > > > From: Pascal Baro > > Sent: Wednesday, February 01, 2012 3:48 PM > > To: excel-macros@googlegroups.com > > Subject: $$Excel-Macros$$ To excel macro team > > > Hi, &g

Re: $$Excel-Macros$$ To excel macro team

Hi Pascal, Check your group membership setting ( go to edit my membership (* https://groups.google.com/group/excel-macros/subscribe?hl=en* ))... On Thu, Feb 2, 2012 at 3:18 AM, Pascal Baro wrote: > Hi, > I'm not receiving mail summary from group posting anymore. Is there

Re: $$Excel-Macros$$ To excel macro team

Dear Pascal, Check below link.. http://www.discussexcel.com/contact-me On Thu, Feb 2, 2012 at 3:18 AM, Pascal Baro wrote: > Hi, > I'm not receiving mail summary from group posting anymore. Is there any > reasons? > Regards, > Pascal > > -- > FORUM RULES (986+ members already BANNED for violati

  1   2   >