$$Excel-Macros$$ Need Help with Index Match

Hi Friends, Need help with Index Match for getting multiple values based on multiple criteria. Please see attached file. Any help will be appreciated. Regards, AJ -- 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

$$Excel-Macros$$ Need Help of percentage based on condition

Hi Team, I need help on Percentage based on the condition. Units Amount Rate Answer 851400 7821722 7.021,05,496.560 If A2 is >10 and up to 100 then ((A2-10)* 2%)*C2 discount on the amount Now for next up to 500 units percentage will be 1.5% and for units in excess of 500

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

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

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 criteria in the Book 1. Your help in the regards will be highly appreciated. -- Are you =EXP(E:RT)

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

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

I have a table where data changes continously (stock market data). I want to apply IF formula. please understand with given example. A1 = 10 B1 = 20 C1 = 5 D1 = where i want to put formula. Now the value of A1 keeps changing. I want that if A1>B1, it shld write "Buy" in D1 cell. Similarly if

$$Excel-Macros$$ Need Help!! For each loop not executing

Hi All, Below is my macro code to get the items from my pivots present in different sheets. Sub somename() Dim pt As PivotTable, pt2 As PivotTable, pi As PivotItem, pi2 As PivotItem, pf As PivotField, pf2 As PivotField, pf3 As PivotField Dim pf4 As PivotField, pi3 As PivotItem, pi4 As

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 >

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

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 a macro? By selecting Customer and month (Blue cells) filling the indicator . If I have to code a macro, can somone help me ?

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

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

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 a macro? By selecting Customer and month (Blue cells) filling the indicator . If I have to code a macro, can somone help me ?

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

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

Trying to insert a blank row between each line. The line starting with: Rows is getting a type mismatch error. - Dim bottom As Integer Dim r As Integer bottom = Cells(Rows.Count, "A").End(xlUp).Row For r = bottom To 2

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

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

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 about my job so pls help, i have attached of the sample of what i am talking about. if anyone can me in

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

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

Hi Team, I am trying to do below in an excel. You can assume there are 60 worksheets minimum in a workbook. 1. In opened excel file. Which has links from several files 2. All cells of the workbook I am doing paste special values 3. Then to come at the first cell in all worksheets (i.e. Cell A1)

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

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

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 =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$$ 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

$$Excel-Macros$$ Need Help in Macros for Currency change in numbers to text

Dear Experts, Please help to resolve below requirement. File attached for reference. *Numbers .: 1,054,265* *Result Shows .: *Ten Lakh Fifty Four Thousand Two Hundred Sixty Five Rupees Only *Required format .: *Ten Lakh Fifty Four Thousand Two Hundred *and *Sixty Five Rupees Only

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

Hi all, I'm stuck trying to find the correct method to auto-populate a range of cells based on a selection. See the image below. When a teacher selects the subject from the list (cell A4), a list of standards (A5:A9) automatically paste below. What's the best method to accomplish this?

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

$$Excel-Macros$$ Need Help for Data

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 mail contains following data in table format wich I need to export in excel sheet in the same manner. It would be very helpful if you could

$$Excel-Macros$$ Need help on Arrey Formula

Hi, I need to calculate final billing product of several product with respective MRP. sample file is attached. Regards, Deepak -- 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$$ 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)

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

$$Excel-Macros$$ Need Help in VBA

Hi I need help for separate data through VBA. My Data is below type.. sku Size 10307963 XS,S,M,L 10307973 XS,S,L 10307978 XS,S,M,L 10307979 XS,S,L 10307980 XS,S,XL 10307981 XS,S,M,L 10307984 XS,M,L Need this type data in result. skuSize

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

$$Excel-Macros$$ Need help in macro

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 User column(cells) a automatic drop down needs to create in a column B* *Else* *No drop down required”* *And the macro should

$$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

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

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

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 =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

$$Excel-Macros$$ need help with Evaluate function

I am looping thru and getting a count of values in an array for a specific user in a single row range. I switch to another range and add in the value fro that rnage Here is the code: If Evaluate("ISREF('" & "Game" & i & "'!A1)") Then Set ws = ThisWorkbook.Sheets("Game" &

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

$$Excel-Macros$$ Need help

Hello, I have formulated a macro to search data, from a worksheet, using user forms. User form has Date picker and couple of comboxes. Idea is to search between two dates along with two criterias. My problem is, macro doesnt function if I do not enter all the search criterias. Ideally, it

$$Excel-Macros$$ Need help Using Isblank and days360 in Macro

Hello all! Please I need macro help with the below in red: What is the best way to achieve this without using the formula that I got from running the macro and also making the code short? I have already completed the Sum in column AH 1. Column AI to the last row should

$$Excel-Macros$$ Need Help in Macro Loop for data dirstribution

Good Evening Experts, I am stuck in a very big problem, In Attached file, I have some data in RAW data file and I want to distribute that data in all the other sheets basis on Wave name date and employee name. Sheet would be different basis on WAVE mean. for example data for Wave 1 need to go

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

Dear Team, Please find the attached excel sheet in which the raw data is sheet 1 and the required output is in Sheet 2. It would be very helpful if you help me on this. Regards -- 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

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

End With Next rw End Sub *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>* *Skype** pankaj.sharma_pj* -- Forwarded messag

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

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 popup and when i select the date it should enter only in cell *E6.* 2) All column of Saturday and Sunday needs to be highlighted in color

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

$$Excel-Macros$$ Need Help on Extract the XML file particulate tag into Excel sheet

Requirement: 1. I have a Excel sheet contains XML file names on the column A. 2. Need to get the xml file name from the excel sheet column A cell and find the *.xml file in folder "C:/" 3. and extract the specified node from the XML file into column C to G on the corresponding row I am very

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

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

Hello, I have been working on a workbook. It is a cash flow and macro helps me to change the numbers of years (columns) because each project needs different time periods. What I do is that I have two columns named as "ColumnLong" and "ColumnFormulas". The first one is empty and only serves as a

$$Excel-Macros$$ Need Help in Extracting Daily Numbers from Cumulative file

Hi Friends, The scenario is : We are getting a file daily containing cumulative numbers till date. The task is: to subtract numbers in today's file from yesterday's file to get daily numbers. The file format is simple : Category(String), total(Int). This seems pretty simple but I am not able

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

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

Hi, Please help me out to split numbers from a cells if the numbers available in the last then. Example attached. Thanks. -- 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$$ Need help to split numbers available in the last

MACROS excel-macros@googlegroups.com Sent: Wednesday, August 5, 2015 3:35 AM Subject: $$Excel-Macros$$ Need help to split numbers available in the last Hi, Please help me out to split numbers from a cells if the numbers available in the last then. Example attached. Thanks. -- Are you =EXP

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

  1   2   3   4   5   6   7   8   9   10   >