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

Kindly help on the said issue. Thanks! On Mon, Sep 24, 2018 at 5:31 PM vikas khen wrote: > Hi All, > > > > Kindly find the attached two sheets, based on the same I need Conditional > formatting formula to highlight the cell value in color it the given > criteria matches. I have mentioned the

Re: $$Excel-Macros$$ Need Help in IF formula

*Regards,* *For quick responds click here for Message * On Mon, Feb 12, 2018 at 9:31 AM, Ruchin Gupta wrote: > I have a table where data changes continously (stock market data). I want > to apply IF formula. please understand with given

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

On Tue, 6/20/17, 'Liberty Stringer' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook To: excel-macros@googlegroups.com Date: Tuesday, J

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

On Tue, 6/20/17, Mustapha LMIDMANI <lmidmani.musta...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook To: "excel-macros" <excel-macros@googlegroups.com> Date: Tuesday,

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

I have fixed N° of product and fixed N° of customers. It would be great if I can modify customer and product list in separated sheet if I want to add or remove something :) Many thanks Paul​ Regards *LMIDMANI Mustapha* *Industrial engineer* lmidmani.musta...@gmail.com P Be green – leave it on

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

If you can give me a larger sample of data, I can try to work on something.Since it sounds like you have no background with VBA programming, I'll try to develop an Excel-Function solution.  Paul- “Do all the good you can, By all the means you can, In all

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

adjective: dynamic1. (of a process or system) characterized by constant change, activity, or progress. That's why I defined the meaning in my question: How "dynamic" is your data?Is the number of Products variable or fixed?is the number of Customers variable or fixed? Meaning, does the number

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

Sorry Paul, I didn't get what you mean by "dynamic". Regards *LMIDMANI Mustapha* *Industrial engineer* lmidmani.musta...@gmail.com P Be green – leave it on the screen *NOTICE:* This privileged and confidential email is intended only for the individual or entity to whom it is addressed. With

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

That didn't answer my questions. Paul- “Do all the good you can, By all the means you 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

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

Hi dears, Thanks for your feedback guys. Paul: sheets are filled weekly (manually). and the dashboard have to reflect data on sheets by selecting Customer and month thanks in advance Regards *LMIDMANI Mustapha* *Industrial engineer* lmidmani.musta...@gmail.com P Be green – leave it on the

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

There's not enough information for me to guess how you want the summary populated. How "dynamic" is your data?Is the number of Products variable or fixed?is the number of Customers variable or fixed?   Paul- “Do all the good you can, By all the means you

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

On Sun, 6/18/17, Rajan Verma <rajanverma1...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook To: excel-macros@googlegroups.com Date: Sunday, June 18, 2017, 7:09 PM countif,

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

countif, sumif, sumproduct can do this On Sun, 18 Jun 2017 at 9:23 PM, Mustapha LMIDMANI < lmidmani.musta...@gmail.com> wrote: > > Hi Guys, > > I'd like to know if there is any possibility with functions to fill my > Summary sheet from montly report sheet in the attached sample. or I need to >

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

On Thu, 6/8/17, Mustapha LMIDMANI <lmidmani.musta...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook To: "excel-macros" <excel-macros@googlegroups.com> Date: Thursday,

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

Hi, Can somone help on my issue please . On 6 June 2017 at 10:50, Mustapha LMIDMANI wrote: > Hi Guys, > > I'd like to know if there is any possibility with functions to fill my > Summary sheet from montly report sheet in the attached sample. or I need to > create

Re: $$Excel-Macros$$ Need Help please - Type Mismatch on rows insert macro

Thank you Paul, I've got a huge mental block on this type of expression. I appreciate the help! On Friday, June 2, 2017 at 11:56:24 AM UTC-4, Paul Schreiner wrote: > > Let's say that you have 100 rows of data. > > "bottom" ends up being 100. > so your Rows statement results in: >

Re: $$Excel-Macros$$ Need Help please - Type Mismatch on rows insert macro

Let's say that you have 100 rows of data. "bottom" ends up being 100.so your Rows statement results in:Rows(R:100).insert shift:=xldown I think it needs to beRows(100:100).insert shift:=xldown so you'd use:Rows(r & ":" & r).Insert Shift:=xlDown Paul- “Do

Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.

PFA Solved question.. On Thu, Jun 1, 2017 at 7:50 PM, Secret Shot wrote: > Dear Team, > > I have one very large excel table which i made from Raw data, accidentally > raw data has been deleted and the only option i have is that table to > convert back in raw data. > > Its

Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.

On Fri, 6/2/17, 'Yu Spain' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Need help in Macro to convert table into dump. To: excel-macros@googlegroups.com Date: Friday, June 2, 2017, 4

Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.

On Thu, 6/1/17, 'Martin George' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Need help in Macro to convert table into dump. To: excel-macros@googlegroups.com Date: Thursday, June 1, 2017, 6

Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.

Thanks Paul, This is exactly what i was needed. you are a life saviour On Thu, Jun 1, 2017 at 11:34 PM, Paul Schreiner wrote: > In THAT case: > > If you name a range "Result" and have it include the "summary" table > without the column headings or phone numbers > B4:G9

Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.

In THAT case: If you name a range "Result" and have it include the "summary" table without the column headings or phone numbersB4:G9 in your sample Then, name a range called "Data" that includes the original "Data" without the column headingsL4:M1000 in your example. Then you can use a macro

Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.

Dear Paul, I appreciate your quick response, However when i say raw data it means just simple table in Excel which i have shown in attached excel sheet only in column L and M. So you can consider it as requirement or data rearrangement from table 1 (Column A to G) to table 2 (Column L to M). I

Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.

On Thu, 6/1/17, Paul Schreiner <schreiner_p...@att.net> wrote: Subject: Re: $$Excel-Macros$$ Need help in Macro to convert table into dump. To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> Date: Thursday,

Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.

There is no standard format for "Raw Data".It depends on the original Application used to CREATE the source of data.Some systems output ASCII (text) files Some are tab delimited.Others are comma delimited (csv). The mechanism you used to read in the "raw data" used known characteristics of the

Re: $$Excel-Macros$$ Need help in Vba Macro

Hi Paul, The macro for this one is not working. Can you please share your file with macro. So i can compare with my file. I am getting error message the data cannot be pasted as shape and size are not same. Regards, Kaushik On Wednesday, May 24, 2017 at 4:29:56 PM UTC+5:30, Paul Schreiner

Re: $$Excel-Macros$$ Need help in Vba Macro

What isn't working?What does your code look like? I put random numbers in 100,000 cells in  Book1.xlsbThen, in Book2, I put 100,000 cells with links to the corresponding cell in Book1. I then created a macro module with:Option ExplicitSub RemoveLinks()     Dim aLinks, inx     aLinks =

Re: $$Excel-Macros$$ Need help in Vba Macro

Hi Paul, The code is not working. Can you please provide full code starting with Sub...till End sub Regards, kaushik Savla On Wed, May 24, 2017 at 12:42 AM, Paul Schreiner wrote: > If you also want to get rid of the "internal" links and formulas, you can > make use of

Re: $$Excel-Macros$$ Need help in Vba Macro

On Tue, 5/23/17, Paul Schreiner <schreiner_p...@att.net> wrote: Subject: Re: $$Excel-Macros$$ Need help in Vba Macro To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> Date: Tuesday, May 23, 2017, 9:53

Re: $$Excel-Macros$$ Need help in Vba Macro

Wow. This is what actually I require. I will test in my file. Thanks a lot. On May 24, 2017 00:43, "Paul Schreiner" wrote: > If you also want to get rid of the "internal" links and formulas, you can > make use of the fact that, for a given cell, the VALUE of the cell

Re: $$Excel-Macros$$ Need help in Vba Macro

If you also want to get rid of the "internal" links and formulas, you can make use of the fact that, for a given cell, the VALUE of the cell is what is displayed, while the FORMULA of the cell is just that, the formula. For cells with a simple value, like "3", then the formula and value are

Re: $$Excel-Macros$$ Need help in Vba Macro

This is think will definitely help. Thanks. On May 24, 2017 00:23, "Paul Schreiner" wrote: > That's very CPU intensive because it copies all cells to the clipboard > and pastes them from clipboard. > which can be a HUGE number of cells for each sheet. > > If you simply

Re: $$Excel-Macros$$ Need help in Vba Macro

That's very CPU intensive because it copies all cells to the clipboardand pastes them from clipboard.which can be a HUGE number of cells for each sheet. If you simply want to break the external links, you can use something like: alinks = ActiveWorkbook.LinkSources(xlExcelLinks)         If Not

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

Any hope on this _ Regards, Vikken On Wed, Mar 29, 2017 at 3:18 PM, vikas khen wrote: > Hi Team, > > Kindly find the attached sheet. In this sheet in need actual value in stud > of 1. hence kindly assist me on this. > > Regards, > VikKhen > > -- > Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Need Help - Data validation selection from drop down list to auto-populate a range of cells below it

You can create a Worksheet_Change event.check to see if the cell changed (Target) is the cell with your pull-down selection, then process accordingly:  Private Sub Worksheet_Change(ByVal Target As Range)     If (Target.Address = "$A$4") Then     Debug.Assert False     End If End Sub

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

Hi Team Any update regarding on the same?? Regards, On Mon, Dec 19, 2016 at 9:51 AM, vikas khen wrote: > Hi all, > > Good Morning!!! > > Team, need help for pooling data from Outlook2016 mails (Which is I kept > in the one folder) to Excel Sheet in Desired format. > > my

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 >

Re: $$Excel-Macros$$ Need Help in VBA

Thanks for Help On Tuesday, 11 October 2016 10:00:45 UTC+5:30, De Premor wrote: > > Try this one ! > > [dp] > > On 10/10/2016 19:46, sonur...@gmail.com wrote: > > Hi > > I need help for separate data through VBA. > > My Data is below type.. > sku Size > 10307963 XS,S,M,L >

Re: $$Excel-Macros$$ Need Help in VBA

Use this Man Sub SplitTest() Dim VarArrayAs Variant Dim LngRAs Long Dim LngCAs Long Dim LngIndexAs Long Dim VaresultAs Variant LngIndex = 1 VarArray = Intersect(Sheet2.Range("A1").CurrentRegion, Sheet2.Range("A1").CurrentRegion.Offset(1))

Re: $$Excel-Macros$$ Need Help in VBA

Hi Try below VBA code Option Base 1 Sub rr() For Each r In Range("b2:b" & Range("b9").End(xlUp).Row) x = Split(r, ",") For t = LBound(x) To UBound(x) Range("h9").End(xlUp).Offset(1).Value = Cells(r.Row, 1) Range("i9").End(xlUp).Offset(1).Value = x(t) Next Next End

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

HI Manju, See this help you -- On Sat, Aug 27, 2016 at 11:33 AM, Manju Deva wrote: > Hi > > > > I need your help to create a macro for the below mentioned scenario. > > > > *Scenario* > > > > We need two columns namely User, drop down > > > > *“IF user enter data in

Re: $$Excel-Macros$$ need help on finding the vales in attached sheet

HI , not sure but have you tried using the value "true" in vlookup, might as well work out for you. sorry in advance i am not a pro at it just amateur. thanks & regars On Mon, Jun 20, 2016 at 4:59 PM, Paul Schreiner wrote: > It works fine on my file. > However, I

Re: $$Excel-Macros$$ need help on finding the vales in attached sheet

It works fine on my file.However, I noticed in YOUR file, the Calculation option is set to "manual". (A "Calculate" reminder appears in the Status Bar.You have to hit an F9 to calculate. which means, when you copy the formula down the column, it retains the original value until you recalculate.

Re: $$Excel-Macros$$ need help on finding the vales in attached sheet

Hi Paul, Thanks for your quick reply, However your suggested formula is not working correctly it shows "No Record Found" for all the records. Hence request you to kindly help me on this. Regards, On Sat, Jun 18, 2016 at 12:50 AM, Paul Schreiner wrote: > You're looking

Re: $$Excel-Macros$$ need help on finding the vales in attached sheet

You're looking for a function like:=IFERROR(VLOOKUP(F2,D:D,1,FALSE),"No Record Found") Paul- “Do all the good you can, By all the means you 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

Re: $$Excel-Macros$$ need help on finding the vales in attached sheet

Hi Paul, Please find the details in the attached sheet. Regards, Vik On Fri, Jun 17, 2016 at 5:53 PM, Paul Schreiner wrote: > What array are you talking about? > Your file says: > "If E2 value is in Array then it should reflect in F > otherwise count as a not found" >

Re: $$Excel-Macros$$ need help on finding the vales in attached sheet

What array are you talking about?Your file says:"If E2 value is in Array then it should reflect in F otherwise count as a not found" So, since column E is labeled as "id", then I suspect you want to look in an array of ID's.The only other ID heading is column "B" which is "Employee Id"But those

Re: $$Excel-Macros$$ need help on finding the vales in attached sheet

Please Help me on this _ On Jun 17, 2016 14:43, "vikas khen" wrote: > Hi Team, > > Need your help on finding the value in attached sheet. > > Request all of you to kindly help me on this > > please find attached sheet for the reference. > > -- > Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Need help

Since I don't know anything about your workbook or the types of values, I'd suggest something like what follows.I've run into issues where Excel doesn't treat a "null" value and a "blank/empty" cell as the same.Plus, when using something like: wshD.Cells(r, "C")the "default" property is

Re: $$Excel-Macros$$ Need Help on attached sheet

Hi All, Expecting your valuable reply on this _ Regards, V!kas On Dec 3, 2015 12:32 AM, "vikas khen" wrote: > Hello Everyone, > > Please find the above attached sheet in which i need your help on the > below said points. > > 1) When i click on date the Date-picker should be

Re: $$Excel-Macros$$ Need Help on attached sheet

> > Here is attached two files , install the addin windatepicker.xlam first >> and then run that Att file, Double click on date which u want to select. > > Regards, Mandeep baluja -- 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

Re: $$Excel-Macros$$ Need help on keeping copy-paste simpler

Thank you DP! Thank you very much for your help. It worked perfectly. However, I tried to do the same in Calculation2 sheet, but inserting rows instead of columns and it did not work the same logic. It gives me a syntax error. Could you help me fix this? I used: Dim v As Integer v =

Re: $$Excel-Macros$$ Need help on keeping copy-paste simpler

Hi Isabel, I'am glad that its work, ok here is the problem in out 2nd case 1st, we need to step back to learn about how the function work, cpearson.com have a bunch article about this complete with explanation & sample, you can follow this link

Re: $$Excel-Macros$$ Need help on keeping copy-paste simpler

Thank you DP Your explanation was extraordinary. In addition to solve my problem, you taught me a lot! ;) Thank you very much again Regards Isabel On Monday, September 14, 2015 at 7:37:57 PM UTC-5, De Premor wrote: > > Hi Isabel, > > I'am glad that its work, ok here is the problem in out 2nd

Re: $$Excel-Macros$$ Need help on keeping copy-paste simpler

Hello Ashish, Thank you for your response. This is a simplified copy of my macro. The lines you can find there are repeated multiple times in my final workbook, in different spreadsheets because it has a broader mathematical formulation. Hope this helps, Regards On Saturday, September 12,

Re: $$Excel-Macros$$ Need help on keeping copy-paste simpler

We can avoid using loop in this case, try to replace your looping code with offset and resize, try this another solution Dim u As Integer u = Range("Months").Value - 1 If u > 1 Then Range("ColumnLong").Resize(, u).Insert Range("ColumnFormula").Copy Range("ColumnLong").Offset(,

Re: $$Excel-Macros$$ Need help on keeping copy-paste simpler

Can u pls share a sample file On Sep 12, 2015 9:38 PM, "Isabel Cristina Ortiz" wrote: > Thank you Basole for your message! > I have been already using your recommendation on my code, but it still > takes a lot of memory. > > Regards, > Isabel > > > > On Saturday, September 12,

Re: $$Excel-Macros$$ Need help on keeping copy-paste simpler

Thank you Basole for your message! I have been already using your recommendation on my code, but it still takes a lot of memory. Regards, Isabel On Saturday, September 12, 2015 at 9:20:05 AM UTC-5, Basole wrote: > > Hi isabel, try using "Application.ScreenUpdating = False" To Turn Off at >

Re: $$Excel-Macros$$ Need help on keeping copy-paste simpler

Hi isabel, try using "Application.ScreenUpdating = False" To Turn Off at the start of code. and "Application.Calculation = xlCalculationManual" To turn off the automatic calculation at the beginning of the code see example: Dim u As Integer, v As Integer u = Range("Months").Value - 1

Re: $$Excel-Macros$$ Need help to split numbers available in the last

: *To:* excel-...@googlegroups.com javascript: *Sent:* Wednesday, August 5, 2015 7:34 AM *Subject:* Re: $$Excel-Macros$$ Need help to split numbers available in the last KEY=55a65c4efb80535a8efd001eee190a4795a02accCLIENT=f090d7af-c960-0296-57db-a2d0ed8b4084 This secure message was sent using Dmail

Re: $$Excel-Macros$$ Need help to split numbers available in the last

What type of solution are you looking for?VBA macros? Excel function?Manual steps? how often do you need to do this?(is it a one-time thing, or daily/weekly/monthly?) What is the source of the data?Can you provide delimiters in the output?  Paul- “Do all

Re: $$Excel-Macros$$ Need help to split numbers available in the last

@googlegroups.com Sent: Wednesday, August 5, 2015 7:21 AM Subject: Re: $$Excel-Macros$$ Need help to split numbers available in the last What type of solution are you looking for?VBA macros? Excel function?Manual steps? how often do you need to do this?(is it a one-time thing, or daily/weekly

Re: $$Excel-Macros$$ Need help to split numbers available in the last

: $$Excel-Macros$$ Need help to split numbers available in the last What type of solution are you looking for? VBA macros? Excel function? Manual steps? how often do you need to do this? (is it a one-time thing, or daily/weekly/monthly?) What is the source of the data? Can you provide

Re: $$Excel-Macros$$ Need help to split numbers available in the last

- From: Paul Schreiner schreiner_p...@att.net To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Wednesday, August 5, 2015 7:24 AM Subject: Re: $$Excel-Macros$$ Need help to split numbers available in the last For MOST of the data, you could use an excel function

Re: $$Excel-Macros$$ Need help to split numbers available in the last

- From: Nasir Shaikh nasirsa...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, August 5, 2015 7:34 AM Subject: Re: $$Excel-Macros$$ Need help to split numbers available in the last KEY=55a65c4efb80535a8efd001eee190a4795a02accCLIENT=f090d7af

Re: $$Excel-Macros$$ Need help to split numbers available in the last

*To:* excel-macros@googlegroups.com *Sent:* Wednesday, August 5, 2015 7:34 AM *Subject:* Re: $$Excel-Macros$$ Need help to split numbers available in the last KEY=55a65c4efb80535a8efd001eee190a4795a02accCLIENT=f090d7af-c960-0296-57db-a2d0ed8b4084 This secure message was sent using Dmail

Re: $$Excel-Macros$$ Need help to split numbers available in the last

, August 5, 2015 7:34 AM *Subject:* Re: $$Excel-Macros$$ Need help to split numbers available in the last KEY=55a65c4efb80535a8efd001eee190a4795a02accCLIENT=f090d7af-c960-0296-57db-a2d0ed8b4084 This secure message was sent using Dmail. To view this message, simply click the button below

Re: $$Excel-Macros$$ need help with looping a find - cut - paste macro Excel 2013

Hi, Sub CommandButton_Click() Dim i As Long For i = 1 To Range(K65000).End(xlUp).Row If Trim(Range(K i).Text) = Empty Then Range(L i).Cut Range(P i).Select ActiveSheet.Paste End If Next I End Sub On Saturday, January 10, 2015 at 2:00:54 PM UTC+5:30, Vabz

Re: $$Excel-Macros$$ need help with looping a find - cut - paste macro Excel 2013

Hi Try below code.. Sub blah() Dim fRow As Range, lRow As Range, rRange As Range Dim c As Range Set fRow = Range(K2) Set lRow = Range(K Rows.Count).End(3) Debug.Print lRow.Row Set rRange = Range(fRow.Address : lRow.Address) Debug.Print rRange.Address For Each c In rRange If IsEmpty(c) Then

Re: $$Excel-Macros$$ Need help with formula:(

Hi You can do it using function sumifs Share sample data in excel sheet if you need further help.. Cheers!! ᐧ On Fri, Jan 9, 2015 at 7:39 PM, Janani Rajagopalan uthr...@gmail.com wrote: I have the below data. I want to dynamically sum the Value column when the CID and FID are the same and

Re: $$Excel-Macros$$ Need help to print only certain no of records from a payroll of employees

hi you are trying ti print payslip? Check my last email where i have given you solution to it.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Fri, Dec 26, 2014 at 11:49 PM, M.Rafique MRU imrafiqu...@gmail.com wrote: Dear Experts! I am facing

Re: $$Excel-Macros$$ Need Help

hi what is WID.. if you want to file Apr-Mar below then select range B2:B13, after that using mouse take your cursor to bottom end of right side till it becomes dark black plus sign then double click on it,. + *I did not do this for you. God is here working through me for you.* On Wed,

Re: $$Excel-Macros$$ Need Help

Check this... is this what you are looking for? + *I did not do this for you. God is here working through me for you.* On Wed, Dec 24, 2014 at 3:38 PM, Vaibhav Joshi v...@vabs.in wrote: hi what is WID.. if you want to file Apr-Mar below then select range B2:B13, after that using

Re: $$Excel-Macros$$ Need Help

hi, WIid is Whole seller unique id and i have to reflect total months from april to march individully based on WID so kidnly help me On 24 December 2014 at 15:38, Vaibhav Joshi v...@vabs.in wrote: hi what is WID.. if you want to file Apr-Mar below then select range B2:B13, after that

Re: $$Excel-Macros$$ Need Help

try this =TEXT(DATE(2014,3+COUNTIF($A$1:A2,A2),1),) On Wed, Dec 24, 2014 at 3:46 PM, Raj Kumar rajlu...@gmail.com wrote: hi, WIid is Whole seller unique id and i have to reflect total months from april to march individully based on WID so kidnly help me On 24 December 2014 at 15:38,

Re: $$Excel-Macros$$ Need Help

Try formula given by Ashish Koul, its working great!! + *I did not do this for you. God is here working through me for you.* On Wed, Dec 24, 2014 at 3:55 PM, ashish koul koul.ash...@gmail.com wrote: try this =TEXT(DATE(2014,3+COUNTIF($A$1:A2,A2),1),) On Wed, Dec 24, 2014 at 3:46

Re: $$Excel-Macros$$ Need help with Run Time Error 424 Object required

Vabz...Thank you very much for the explanation and fix...it works... Rob On Friday, December 12, 2014 12:53:25 AM UTC-8, Vabz wrote: hi You will get error if no value is added in list box. add line on error resume next in beginning to avoid this error.. cheers + *I did not do

Re: $$Excel-Macros$$ Need help with Run Time Error 424 Object required

cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Dec 16, 2014 at 11:09 PM, Rob Flott robfl...@gmail.com wrote: Vabz...Thank you very much for the explanation and fix...it works... Rob On Friday, December 12, 2014 12:53:25 AM UTC-8, Vabz wrote: hi

Re: $$Excel-Macros$$ Need help with Run Time Error 424 Object required

hi You will get error if no value is added in list box. add line on error resume next in beginning to avoid this error.. cheers + *I did not do this for you. God is here working through me for you.* On Fri, Dec 12, 2014 at 1:03 AM, Rob Flott robfl...@gmail.com wrote: On a worksheet I

Re: $$Excel-Macros$$ need help to convert this code into excel macro

hi experts pls convert to vba macro mmc input text box mnc input text box lac input text box cid input text box button below code table width=450 trtd /td/tr /table form method=post action=?php echo $PHP_SELF;? table tr tda

Re: $$Excel-Macros$$ need help to convert this code into excel macro

Hi pl share us code in proper html file format instead of this code.. + *I did not do this for you. God is here working through me for you.* On Mon, Dec 1, 2014 at 1:36 PM, my excel myxlg...@gmail.com wrote: hi experts pls convert to vba macro mmc input text box mnc input text box

Re: $$Excel-Macros$$ need help to convert this code into excel macro

Guruji, please send to my email id only html php in attached file it's my request thank you using System; using System.Collections.Generic; using System.Text; using System.Net; using System.IO; using System.Diagnostics; /* * Sample code to obtain geo codes from a cell info * GSM/UMTS setting

Re: $$Excel-Macros$$ Need help to click on Ok button when message from web page

hi you can use following line in stead of yours ieobj2.getlementbyid(cmdclose).click IE.document.all.Item Call IE.document.parentWindow.execScript(javafunction(), JavaScript) in above secone line replace javafunction with a function which is called by your webpage on clicking ok button... hope

Re: $$Excel-Macros$$ Need help to click on Ok button when message from web page

Hi Ravi/Vaibhav its not working at all.. i hv button from ASP that ieobj2.getlementbyid(cmdclose).click once i click it generate alert..and my code stops debugging next, aleart is do u really want to close this.. i hv to click on ok button please siggest me further solution On Fri, Nov 28,

Re: $$Excel-Macros$$ Need help to click on Ok button when message from web page

Hi Can you share url of webpage which you are acessing.. On Nov 30, 2014 12:29 AM, Sunil Patil sunil.patil...@gmail.com wrote: Hi Ravi/Vaibhav its not working at all.. i hv button from ASP that ieobj2.getlementbyid(cmdclose).click once i click it generate alert..and my code stops

RE: $$Excel-Macros$$ Need help to click on Ok button when message from web page

Hi, Add below line in your code. Might be it works webbrowser.Silent = True ‘webbrowser’ is your webbrowser object name like if you are using ‘ie’ so use ie instead of ‘webbrowse’ Regards, Ravi Kumar. From: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Need help to click on Ok button when message from web page

hi you can try adding either of foll lines... Application.SendKeys({enter}) or Application.SendKeys(~) however its always not the same thing what we percieve, if it doent work pl share ur code to chek further... Cheers!! + *I did not do this for you. God is here working through me for

Re: $$Excel-Macros$$ Need Help

Hi Chandru, PFA Regards Ashish On 24 November 2014 at 11:57, Chandru chandr...@gmail.com wrote: I need Excel formula or VBA for the following. *) To set cell width(for headers). *) To make hyper link text blue. *) Font Formatting(for headers). Regards, Chandru -- Are you

Re: $$Excel-Macros$$ Need Help

Used this Formula in D2 and drag down. . =SUBSTITUTE(A2, ,) Cheers On Nov 16, 2014 9:32 AM, Imran Khan ikha...@gmail.com wrote: To All:- PLease help me to provide formula to eliminate the space. Example file attached. Regards, *Imran Khan* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))

Re: $$Excel-Macros$$ Need help on data validation: List

Hi Ashish, I am sorry I was not clear in my email. Let me clarify. Cell A1 has a drop down list (Global, Local) If someone selects Global, Cell B1 should show a drop-down list which is coming through a named range. I have that assigned. But, if the user selects Local, the Cell B1 should not

Re: $$Excel-Macros$$ Need help on data validation: List

Hi Sharath, PFA..! Change your data in A1. If you select Global in A1 then drop down list will show in B1 and If you select Local in A1 then drop down list will be deleted in B1. you are able to write anything in B1 Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

Re: $$Excel-Macros$$ Need help on data validation: List

Thanks Ashish, This is exactly what I wanted! Regards, Sharath On Thu, Nov 13, 2014 at 7:26 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Sharath, PFA..! Change your data in A1. If you select Global in A1 then drop down list will show in B1 and If you select Local in A1 then

Re: $$Excel-Macros$$ Need help on data validation: List

Welcome Sharath. 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, like

Re: $$Excel-Macros$$ Need help to create a user form.

Opening a file to show form. To import the data: Typing data into the form and click the Data Entry To edit data:Click listbox to select data, The data will appear on the form, Edit the data needed, and click Edit Data. 2014-11-12 13:34 GMT+07:00 Kamal Ganeshan ganesh.theva...@gmail.com:

Re: $$Excel-Macros$$ Need help to create a user form.

Great one buddy! On Nov 13, 2014 4:13 AM, Bé Trần Văn betnmtdongna...@gmail.com wrote: Opening a file to show form. To import the data: Typing data into the form and click the Data Entry To edit data:Click listbox to select data, The data will appear on the form, Edit the data needed, and

Re: $$Excel-Macros$$ Need help to create a user form.

Hi All, I want you to understand the requirements. Sub Brand numbers Invoice number combination will be multiple. Can anyone will be help me out to create a user form. for eg: Brand numbers Invoice numbersStatus 90121 97012

Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

Hi Vaibhav Bhai, Sheet is working fine. Superb! 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

Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

Hi Vaibhav Bhai, Working Perfectly. Thanks... Superb...!! You are amazing *Thanks,* *Nilkanth Raval* *+91 900 428 0 428* *+91 808 000 1620* *Think Before You Print.Consider ENVIRONMENT.* *“SAVE TREES, SAVE EARTH” * *“All appears to change when we change!”* On 28 October 2014 11:38,

  1   2   3   4   5   6   7   >