Fwd: $$Excel-Macros$$ Req - how to enable add in in excel 2016.

2018-12-10 Thread Mohammed Hamed Ajaz
-- Forwarded message - From: Mohammed Hamed Ajaz Date: Wed, Nov 21, 2018 at 1:29 PM Subject: $$Excel-Macros$$ Req - how to enable add in in excel 2016. To: Dear All, Pls help to enable ADD IN in excel 2016. i was using in 2007 now updated excel 2016 but unable to enable the ADD

Fwd: $$Excel-Macros$$ Formula needed

2018-09-09 Thread KAUSHIK SAVLA
Hi All, Awaiting for your help on formula. Thanks, Kaushik Savla -- Forwarded message - From: KAUSHIK SAVLA Date: Wed, Sep 5, 2018 at 8:06 PM Subject: $$Excel-Macros$$ Formula needed To: MS EXCEL AND VBA MACROS KAUSHIK SAVLA [image: Attachments]1:53 PM (6 hours ago) to exce

Fwd: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group

2017-09-18 Thread N.Shivkumar
Dear Mr. Prabhu Please add me in WHATAPP GROUP M: 9422613567 -- 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

Re: Fwd: $$Excel-Macros$$ for multiple condition to calculate A SIMPLE RESULT

2017-07-10 Thread Sanjib Chatterjee
Many Many thank you Maul Schreiner I is really what i am looking for On Mon, Jul 10, 2017 at 6:38 PM, Paul Schreiner wrote: > I'm not sure I COMPLETELY understand, but at least I can give it a start. > > first: your description keeps saying "BD = ..." > But your workbook has a column heading

Re: Fwd: $$Excel-Macros$$ for multiple condition to calculate A SIMPLE RESULT

2017-07-10 Thread Paul Schreiner
I'm not sure I COMPLETELY understand, but at least I can give it a start. first: your description keeps saying "BD = ..."But your workbook has a column heading "DB", so I'm assuming one or the other is transposed. also, .06% is .0006  do you really mean "B Value" * .06  (formula: =B2 * .06)or"B V

Fwd: $$Excel-Macros$$ for multiple condition to calculate A SIMPLE RESULT

2017-07-09 Thread Sanjib Chatterjee
please help -- Forwarded message -- From: Sanjib Chatterjee Date: Sat, Jul 8, 2017 at 1:22 PM Subject: $$Excel-Macros$$ for multiple condition to calculate A SIMPLE RESULT To: excel-macros Dear Sir / Madam, Please see the attachment and Please help me how to solve the prob

Fwd: $$Excel-Macros$$ for multiple condition to calculate A SIMPLE RESULT

2017-07-08 Thread Sanjib Chatterjee
Sir / Madam, Please go through the mail and help Sanjib -- Forwarded message -- From: Sanjib Chatterjee Date: Sat, 8 Jul 2017 13:22:20 +0530 Subject: $$Excel-Macros$$ for multiple condition to calculate A SIMPLE RESULT To: excel-macros Dear Sir / Madam, Please see the atta

Fwd: Fwd: Fwd: $$Excel-Macros$$ copy data from one sheet to other based on condition

2017-05-21 Thread Sanjib Chatterjee
Thank you everyone I got the solution Many Many thank you for supporting me Sanjib Chatterjee -- Forwarded message -- From: 'Carmelita Cronin' via MS EXCEL AND VBA MACROS < excel-macros@googlegroups.com> Date: Fri, May 19, 2017 at 9:32 PM Subject: Re: Fwd: Fwd

Re: Fwd: Fwd: $$Excel-Macros$$ copy data from one sheet to other based on condition

2017-05-19 Thread 'Carmelita Cronin' via MS EXCEL AND VBA MACROS
On Fri, 5/19/17, Sanjib Chatterjee wrote: Subject: Re: Fwd: Fwd: $$Excel-Macros$$ copy data from one sheet to other based on condition To: "excel-macros" Cc: "Paul Schreiner" Date: Friday, May 19, 2017, 1:56 PM Thank

Re: Fwd: $$Excel-Macros$$ Introduce Yourself !!

2017-05-19 Thread Saleem Ansari
hi i m saleem ansari i m jobless On Fri, May 19, 2017 at 1:15 PM, Jitendra Singh wrote: > My self Jitendra Singh working as a data analyst in noida. > > Thanks > > Sent from BlueMail > On 19 May 2017, at 1:12 PM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.co

Re: Fwd: Fwd: $$Excel-Macros$$ copy data from one sheet to other based on condition

2017-05-19 Thread Sanjib Chatterjee
.bluemail.me/r?b=9660> > On 19 May 2017, at 1:19 PM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com> wrote: >> >> >> -- Forwarded message -- >> From: Sanjib Chatterjee >> Date: Fri, May 19, 2017 at 1:18 PM >> Subject: Re: Fwd: $$Exce

Re: Fwd: Fwd: $$Excel-Macros$$ copy data from one sheet to other based on condition

2017-05-19 Thread Jitendra Singh
7 at 1:18 PM >Subject: Re: Fwd: $$Excel-Macros$$ copy data from one sheet to other >based >on condition >To: excel-macros , >schreiner_p...@att.net > > >Dear Paul Schreiner, > >Here find the attachment, >I have a problem I want to copy data base on the Person na

Re: Fwd: $$Excel-Macros$$ copy data from one sheet to other based on condition

2017-05-19 Thread Sanjib Chatterjee
Dear Paul Schreiner, Here find the attachment, I have a problem I want to copy data base on the Person name which i highlighted with yellow colour. suppose if the person name "JKM" a sheet will created with the name "JKM" and the entire rows data relating to Jkm WILL copy to the new sheets of JKM.

Re: Fwd: $$Excel-Macros$$ Introduce Yourself !!

2017-05-19 Thread Jitendra Singh
My self Jitendra Singh working as a data analyst in noida. Thanks ⁣Sent from BlueMail ​ On 19 May 2017, 1:12 PM, at 1:12 PM, Sanjib Chatterjee wrote: >I am Sanjib Chatterjee, working in a stock broking firm, name Sunidhi >securities and finance ltd,Kolkata, sa Bank office Mis executive. I >ge

Fwd: $$Excel-Macros$$ Introduce Yourself !!

2017-05-19 Thread Sanjib Chatterjee
I am Sanjib Chatterjee, working in a stock broking firm, name Sunidhi securities and finance ltd,Kolkata, sa Bank office Mis executive. I get lot of support from the excel community whenever I need any help. I have a great passion of Excel. Hope You will continue supporting us. Thanking you Sanj

Re: Fwd: $$Excel-Macros$$ copy data from one sheet to other based on condition

2017-05-18 Thread Paul Schreiner
Your error seems to indicate that you're trying to create a sheet and change the name to one that already exists. without seeing a sample of your file and macros, it will be difficult to determine what is going on. Paul- “Do all the good you can, By all the

Fwd: $$Excel-Macros$$ copy data from one sheet to other based on condition

2017-05-16 Thread Sanjib Chatterjee
-- Forwarded message -- From: Sanjib Chatterjee Date: Tue, May 16, 2017 at 3:14 PM Subject: Re: $$Excel-Macros$$ copy data from one sheet to other based on condition To: excel-macros , jitendra kumar < jitendr...@gmail.com>, jeetexcelt...@gmail.com Dear Jitendra Singh, I want au

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-06 Thread Shrinivas Shevde
Dear Paul Sir Really a excellent work Its magic its work like anything. Thanks very much Regards Shrinivas On Thu, Jan 5, 2017 at 9:03 PM, Paul Schreiner wrote: > Shrinivas: > > I wrote a macro that created from 1 to 5 files in 25 folders for a total > of 73 files. > I put values in cells A2 t

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread silvers.r via MS EXCEL AND VBA MACROS
On Fri, 1/6/17, ashleypartridge via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 6:30 AM

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread ashleypartridge via MS EXCEL AND VBA MACROS
On Fri, 1/6/17, mahergeorge503 via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 5:36 AM

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread mahergeorge503 via MS EXCEL AND VBA MACROS
On Fri, 1/6/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 4:10 AM On

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread keisha.fry via MS EXCEL AND VBA MACROS
On Fri, 1/6/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 3:01 AM On

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread karleenbiggs via MS EXCEL AND VBA MACROS
On Fri, 1/6/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 2:27 AM

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread julienneschindler via MS EXCEL AND VBA MACROS
On Fri, 1/6/17, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 12:49 AM

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread storeythomas725 via MS EXCEL AND VBA MACROS
On Thu, 1/5/17, georgemartin812 via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 10:25 PM

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread georgemartin812 via MS EXCEL AND VBA MACROS
On Thu, 1/5/17, spainy via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 6:55 PM On Thu

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread spainy via MS EXCEL AND VBA MACROS
On Thu, 1/5/17, derrickandrew994 via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 2:13 PM

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread Paul Schreiner
Shrinivas: I wrote a macro that created from 1 to 5 files in 25 folders for a total of 73 files.I put values in cells A2 through E10. In your original email, you said you wanted the values from cells E3, F5, E8 and E9but in your sample, you used E5. I'm sure you can figure out how to modify the c

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread derrickandrew994 via MS EXCEL AND VBA MACROS
On Thu, 1/5/17, ileanakeating via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 12:53 PM

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread ileanakeating via MS EXCEL AND VBA MACROS
On Thu, 1/5/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 12:02 PM On

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread silvers.r via MS EXCEL AND VBA MACROS
On Thu, 1/5/17, Shrinivas Shevde wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 11:32 AM Dear Paul Thanks for replyPlease find detila you asked forThere will

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread GENIUS
Hi Pual would be please see my question as well. -- 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

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread Shrinivas Shevde
Dear Paul Thanks for reply Please find detila you asked for There will be seperate summary sheet which contain folowing Please find attached sheet Thanks once again for great Help Regards Shrinivas On Wed, Jan 4, 2017 at 7:52 PM, Paul Schreiner wrote: > This can be easily done. > I recen

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-04 Thread mahergeorge503 via MS EXCEL AND VBA MACROS
On Wed, 1/4/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Wednesday, January 4, 2017, 4:58 PM

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-04 Thread GENIUS
Hi Experts, I have mentioned question in my workbook, 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 @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titl

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-04 Thread julienneschindler via MS EXCEL AND VBA MACROS
On Wed, 1/4/17, Paul Schreiner wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: "excel-macros@googlegroups.com" Date: Wednesday, January 4, 2017, 4:22 PM This can be easily done.I recently created a "C

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-04 Thread Paul Schreiner
This can be easily done.I recently created a "Combined Summary" report that opened over 500 files in subfolders and copied 160 columns of data from a variable number of rows on the "Summary" sheet of each workbook to the "combined" workbook.Resulting in over 2700 rows of data.Since the files wer

Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-03 Thread Shrinivas Shevde
Dear Friends Waiting for reply -- Forwarded message -- From: Shrinivas Shevde Date: Tue, Jan 3, 2017 at 4:55 PM Subject: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Dear All I want a macro for following can Anyone help me. I have a folder ,which cont

Re: Fwd: $$Excel-Macros$$ Copying Value by Column Header Name into new Sheet

2016-10-28 Thread Paul Schreiner
I'm not sure exactly what you're trying to say.Because some of what you're describing doesn't match up with the sample file you provided. However, I THINK the problem is that in your original macro, you copied columns A,B and Cand called them "Part Number", "Qty" and "VALUE" essentially, you were

Fwd: $$Excel-Macros$$ Copying Value by Column Header Name into new Sheet

2016-10-27 Thread C.G.Kumar
Hi, The macro is close to expectation but still need fix. Total Quantity as per data sheet(Sheet 1) is matching with "results" sheet .. But, *total value* as per data sheet (Sheet 1) is not matching with but the value captured by macro is not correct. Guess the price pulled by macro is first

Fwd: $$Excel-Macros$$ Conditional calculation required for multiple criteria.

2016-10-14 Thread Dheeraj Bankoti
Hi Can any expert resolve the query.. Regards -- Forwarded message -- From: Dheeraj Bankoti Date: Sun, Oct 9, 2016 at 1:24 PM Subject: Fwd: $$Excel-Macros$$ Conditional calculation required for multiple criteria. To: excel-macros@googlegroups.com -- Forwarded message

Fwd: $$Excel-Macros$$ Conditional calculation required for multiple criteria.

2016-10-11 Thread Dheeraj Bankoti
HI IS IT POSSIBLE? -- Forwarded message -- From: Dheeraj Bankoti Date: Sun, Oct 9, 2016 at 1:24 PM Subject: Fwd: $$Excel-Macros$$ Conditional calculation required for multiple criteria. To: excel-macros@googlegroups.com -- Forwarded message -- From: Dheeraj

Fwd: $$Excel-Macros$$ Conditional calculation required for multiple criteria.

2016-10-09 Thread Dheeraj Bankoti
-- Forwarded message -- From: Dheeraj Bankoti Date: Tue, Oct 4, 2016 at 4:41 PM Subject: $$Excel-Macros$$ Conditional calculation required for multiple criteria. To: excel-macros@googlegroups.com Dear Experts, I am seeking your help for Conditional calculation in attached file.

Fwd: $$Excel-Macros$$ Conditional calculation required for multiple criteria.

2016-10-06 Thread Dheeraj Bankoti
hi is it possible? -- Forwarded message -- From: Dheeraj Bankoti Date: Tue, Oct 4, 2016 at 4:41 PM Subject: $$Excel-Macros$$ Conditional calculation required for multiple criteria. To: excel-macros@googlegroups.com Dear Experts, I am seeking your help for Conditional calculation

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

2016-09-12 Thread Sandeep Kumar Baranwal
Hi Thanks for the concern. Please find the details in spreadsheet attached. Please note that the match operation need 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 Solut

Fwd: $$Excel-Macros$$ Single Quotes Added to Email Address

2016-09-10 Thread Dheeraj Bankoti
hi is any expert there in group who can short out the issue.. Regards -- Forwarded message -- From: Dheeraj Bankoti Date: Sun, Sep 4, 2016 at 9:11 AM Subject: Re: $$Excel-Macros$$ Single Quotes Added to Email Address To: excel-macros@googlegroups.com Hello experts, Is it pos

Fwd: $$Excel-Macros$$ Single Quotes Added to Email Address

2016-09-02 Thread Dheeraj Bankoti
Hi Is any group member short it out? Regards -- Forwarded message -- From: Dheeraj Bankoti Date: Tue, Aug 30, 2016 at 5:31 PM Subject: $$Excel-Macros$$ Single Quotes Added to Email Address To: excel-macros@googlegroups.com Dear Group Members, I am using Out look10 and after sen

Fwd: $$Excel-Macros$$ Lock some cell for edit with option to copy raw & paste - Waiting for reply

2016-08-23 Thread big smile
-- Forwarded message -- From: big smile Date: 20 August 2016 at 12:00 Subject: $$Excel-Macros$$ Lock some cell for edit with option to copy raw & paste - Waiting for reply To: excel-macros@googlegroups.com Paul sir -- waiting for your reply. & no body other have any idea. how to

Fwd: $$Excel-Macros$$ Lock some cell for edit with option to copy raw & paste -reminder ###

2016-08-21 Thread big smile
-- Forwarded message -- From: big smile Date: 20 August 2016 at 12:00 Subject: $$Excel-Macros$$ Lock some cell for edit with option to copy raw & paste - Waiting for reply To: excel-macros@googlegroups.com Paul sir -- waiting for your reply. & no body other have any idea. how to

Fwd: $$Excel-Macros$$ Help !

2016-06-15 Thread Shaikh Iqbal
Dear ALL, Anybody can help me ! Regards, IQbal -- Forwarded message -- From: Shaikh Iqbal Date: 8 June 2016 at 11:31 Subject: $$Excel-Macros$$ Help ! To: excel-macros@googlegroups.com Hi, Export Pls find attached a file and pls do the correction in formula. T

Fwd: $$Excel-Macros$$ Need to correction in formula

2016-05-30 Thread Shaikh Iqbal
-- Forwarded message -- From: Shaikh Iqbal Date: 30 May 2016 at 16:03 Subject: $$Excel-Macros$$ Points data To: excel-macros@googlegroups.com Dear Export, Need help on attached this file. Regards, Iqbal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wa

Fwd: $$Excel-Macros$$ Need - Formula weekly bonus

2016-05-23 Thread Shaikh Iqbal
Hi, Anybody help me ! -- Forwarded message -- From: Shaikh Iqbal Date: 23 May 2016 at 19:55 Subject: $$Excel-Macros$$ Need - Formula weekly bonus To: excel-macros@googlegroups.com Dear Export, Please find attached daily tracking file. I need the a formula in Column Q as per

Fwd: $$Excel-Macros$$ Copy and Paste Data to another workbook (closed workbook)

2016-05-10 Thread Hilary Lomotey
> > > > Hello Guys, > > kindly assist with VBA code to copy data from workbook A (PTRS) and paste > the data in workbook B-Daily Trades (With workbook B possible closed). > > from the attached sheet, i want to copy data from PTRS workbook in PTRS > worksheet and paste it in Daily Trades workbook

Fwd: $$Excel-Macros$$ Formula for Sum of nearest target value

2016-04-19 Thread Dheeraj Bankoti
-- Forwarded message -- From: Dheeraj Bankoti Date: Mon, Apr 18, 2016 at 7:22 AM Subject: Fwd: $$Excel-Macros$$ Formula for Sum of nearest target value To: excel-macros@googlegroups.com It seems now there is no excitement in group to help. Regards Dheeraj

Fwd: $$Excel-Macros$$ Formula for Sum of nearest target value

2016-04-17 Thread Dheeraj Bankoti
It seems now there is no excitement in group to help. Regards Dheeraj -- Forwarded message -- From: Dheeraj Bankoti Date: Sat, Apr 16, 2016 at 11:53 AM Subject: Fwd: $$Excel-Macros$$ Formula for Sum of nearest target value To: excel-macros@googlegroups.com Dear Experts

Fwd: $$Excel-Macros$$ Formula for Sum of nearest target value

2016-04-16 Thread Dheeraj Bankoti
Dear Experts, Please advise if it is possible and I need your help in this regard. Regards Dheeraj -- Forwarded message -- From: Dheeraj Bankoti Date: Thu, Apr 14, 2016 at 11:24 AM Subject: $$Excel-Macros$$ Formula for Sum of nearest target value To: excel-macros@googlegroups.com

Fwd: $$Excel-Macros$$ Sorting Comma Separated Values in a cell

2016-01-15 Thread Pankaj Sharma
Hi Dev,, little long process but working as per your requirement. Check this out Option Explicit Sub SortRangeData() Dim sh1 As Worksheet, sh2 As Worksheet Dim rng1 As Range, rng2 As Range, rng As Range, data As Range Dim arr As Variant, arr2 As String, txt As String Dim i As Long Set sh1

Fwd: $$Excel-Macros$$ Refresh d15 automatically when last any entry of any raw change

2016-01-10 Thread Pankaj Sharma
use this: Private Sub Worksheet_Change(ByVal Target As Range) Dim r As Long: r = Target.Row If r >= 5 And r < Sheet1.Range("A" & Rows.Count).End(xlUp).Row Then r = r - 3 Range("C15").FormulaR1C1 = "=OFFSET(R[-12]C[1]," & r & ",0)" End If End Sub *Pankaj Sharma

Re: Fwd: $$Excel-Macros$$ Extract reports into a new workbook

2015-12-31 Thread jayaraj metta
Please find the attached file with solution In case of any problem please let me know On Dec 31, 2015 4:05 PM, "Rajeev Kumar" wrote: > ANY UPDATE PLEASE!!! > -- Forwarded message -- > From: Rajeev Kumar > Date: Thu, Dec 31, 2015 at 9:09 AM > Subject: $$Excel-Macros$$ Extract repo

Fwd: $$Excel-Macros$$ Extract reports into a new workbook

2015-12-31 Thread Rajeev Kumar
ANY UPDATE PLEASE!!! -- Forwarded message -- From: Rajeev Kumar Date: Thu, Dec 31, 2015 at 9:09 AM Subject: $$Excel-Macros$$ Extract reports into a new workbook To: excel-macros@googlegroups.com Dear Experts, Please find attached excel file and help accordingly. I have explained

Fwd: $$Excel-Macros$$ Re: Enable/Disable text box based on User Login

2015-12-30 Thread Pankaj Sharma
Hi Rajeev, You can also use this Form too. ☺ user1 USER PASSWORD user2 GUEST *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p ankaj123...@gmail.com * *Skype** pankaj.sharma_pj* -- Forwarded message

Fwd: $$Excel-Macros$$ How to download data of a Google sheet in excel sheet with VBA

2015-12-30 Thread Devendra Sahay
Hi Experts, I have searched a lot on Google for above concern but none of the code is running, So If you can help then please help me out here on this issue. Any help on this would be appreciated & thanks in advance for your help -- With Regard !!! Devendra Rahi -- Are you =EXP(E:RT) or =NOT

Fwd: $$Excel-Macros$$ plz help

2015-12-26 Thread Pankaj Sharma
use this: "=TEXT(IF(LEFT(B6,17)="Ship (P/U) Date: ",TRIM(MID(B6,18,10)),K5),"MM/DD/")" instead of "=TEXT(IF(LEFT(B10,17)="Ship (P/U) Date: ",RIGHT(B10,11),K9),"MM/DD/")" *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *

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

2015-12-23 Thread Pankaj Sharma
Use this : Sub Data_Formatting() Dim rw As Long For rw = 17 To ActiveSheet.UsedRange.Rows.Count Step 6 With Worksheets("Required").Range("B" & Rows.Count).End(xlUp) .Offset(1, 0).Value = Range("D" & rw).Value .Offset(1, 1).Value = Range("D" & rw).Offset(3).Value .Offs

Fwd: $$Excel-Macros$$ How to export data from Outlook to excel

2015-09-26 Thread Suman
Dear All, Please help on below *Suman Kumar* -- Forwarded message -- From: Suman Date: Thu, Sep 24, 2015 at 1:48 PM Subject: $$Excel-Macros$$ How to export data from Outlook to excel To: "excel-macros@googlegroups.com" Dear All, I want to learn that how to export d

Re: Fwd: $$Excel-Macros$$ Send Bulk Mail Macro

2015-07-29 Thread Nilkanth Raval
Thanks a lot sir. *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 29 July 2015 at 22:00, De Premor wrote: > Hi Nilkanth, > > PFA, hope it solve your requi

Re: Fwd: $$Excel-Macros$$ Send Bulk Mail Macro

2015-07-29 Thread De Premor
Hi Nilkanth, PFA, hope it solve your requirement Rgds, [dp] On 29/07/2015 17:01, Nilkanth Raval wrote: Hi All, Can anyone help me in below mail??? Thanks, Nilkanth Raval -- Forwarded message -- From: "Nilkanth Raval" > Date: Jul 28, 2015 3:

Fwd: $$Excel-Macros$$ Send Bulk Mail Macro

2015-07-29 Thread Nilkanth Raval
Hi All, Can anyone help me in below mail??? Thanks, Nilkanth Raval -- Forwarded message -- From: "Nilkanth Raval" Date: Jul 28, 2015 3:59 PM Subject: $$Excel-Macros$$ Send Bulk Mail Macro To: Cc: Hi, I have created Macro to send bulk emails from Excel file. This macro is *wor

Fwd: $$Excel-Macros$$ cut option is disable in excel 2003

2015-07-20 Thread Sanjib Chatterjee
Dear Sir / madam, Please help -- Forwarded message -- From: Sanjib Chatterjee Date: Mon, Jul 20, 2015 at 10:44 AM Subject: $$Excel-Macros$$ cut option is disable in excel 2003 To: excel-macros , excelvbacli...@googlegroups.com Dear Sir / Madam, I am using Ms Office 2003, When I

Fwd: $$Excel-Macros$$ PIVOT TABLE & CHART TAKE SCREEN SHOT

2015-07-08 Thread saravanan R
Hello Team, I have an requirement where the data from Pivot table & chart as to be copied into the Power point slide(or in the excel itself as bitmap image) . In the same pivot table i have multiple filter(values) to select. since I have to take 12(conditions) print screen from same pivot table a

Re: Fwd: $$Excel-Macros$$ Query (Outlook VBA)

2015-06-03 Thread Soumyendu Paul
Thanks for help On Jun 3, 2015 4:43 PM, "Soumyendu Paul" wrote: > -- Forwarded message -- > From: "Soumyendu Paul" > Date: Jun 3, 2015 4:21 PM > Subject: $$Excel-Macros$$ Query (Outlook VBA) > To: > Cc: > > Hi, > > I have an outlook message stored in hard drive folder. Want to

Fwd: $$Excel-Macros$$ Formula based on some criteria

2015-03-14 Thread rameshwari shyam
Dear Team, Can any one help on this. Thanks, Rameshwari -- Forwarded message -- From: rameshwari shyam Date: Fri, Mar 13, 2015 at 10:08 AM Subject: Re: $$Excel-Macros$$ Formula based on some criteria To: excel-macros@googlegroups.com Dear gaurav, required some more modificatio

Fwd: $$Excel-Macros$$ PLS SOLVE

2015-03-08 Thread Pramod Singh
Hi David. .. PFA Pramod -- Forwarded message -- From: "Pramod Singh" Date: 9 Mar 2015 11:33 Subject: Fwd: $$Excel-Macros$$ PLS SOLVE To: "Pramod Singh" Cc: Pramod -- Forwarded message -- From: Date: 9 Mar 2015 10:05 Subject: $$Excel-Macros

Fwd: $$Excel-Macros$$ need solution without vba function

2015-03-03 Thread Sanjib Chatterjee
-- Forwarded message -- From: Sanjib Chatterjee Date: Tue, Mar 3, 2015 at 2:51 PM Subject: $$Excel-Macros$$ need solution without vba function To: excel-macros , NOORAIN ANSARI < noorain.ans...@gmail.co>, NOORAIN ANSARI Dear Sir / Madam, Please see the attachment and give a sol

Fwd: $$Excel-Macros$$ Income Statement Review Macro

2015-03-02 Thread Nilkanth Raval
Date: 28 February 2015 at 22:16 Subject: Fwd: $$Excel-Macros$$ Income Statement Review Macro To: excel-macros@googlegroups.com, Vaibhav Joshi Hello Sir, Can you please help me. Thanks, Nilkanth Raval. -- Forwarded message -- From: "Nilkanth Raval" Date: Feb 28, 20

Fwd: $$Excel-Macros$$ Income Statement Review Macro

2015-02-28 Thread Nilkanth Raval
Hello Sir, Can you please help me. Thanks, Nilkanth Raval. -- Forwarded message -- From: "Nilkanth Raval" Date: Feb 28, 2015 2:04 AM Subject: $$Excel-Macros$$ Income Statement Review Macro To: , "Vaibhav Joshi" Cc: Dear Sir, I want to write a macro for IS Review. In attache

Fwd: $$Excel-Macros$$ Function for Data validataion

2015-02-27 Thread Ashish Bhalara
-- Forwarded message -- From: Ashish Bhalara Date: Fri, Feb 27, 2015 at 9:20 AM Subject: $$Excel-Macros$$ Function for Data validataion To: excel-macros@googlegroups.com Dear experts, I want to formula for data validation to fulfill below conditions. 1. Total character shou

Fwd: $$Excel-Macros$$ Colour the Group Rows

2015-02-03 Thread Ganesh Acharya
Hello, Amazing macro Thanks a lot -- Forwarded message -- From: Vaibhav Joshi Date: Fri, Jan 30, 2015 at 7:01 PM Subject: Re: $$Excel-Macros$$ Colour the Group Rows To: "excel-macros@googlegroups.com" Hi Check this...I have created to Macros, one for clearing format, press

Fwd: $$Excel-Macros$$ Colour the Group Rows

2015-01-30 Thread Ganesh Acharya
Hello, Attachment doesn't have any formula Is there any way to make a Macro for that Thanks Ganesh Acharya -- Forwarded message -- From: Vaibhav Joshi Date: Fri, Jan 30, 2015 at 2:29 PM Subject: Re: $$Excel-Macros$$ Colour the Group Rows To: "excel-macros@googlegroups.com"

Fwd: $$Excel-Macros$$ Re: Vlookup Help required

2015-01-10 Thread Rakesh
Kindly with suitable formula urgenly required Rakesh -- Forwarded message -- From: "Mandeep Baluja" Date: 06-Jan-2015 5:52 PM Subject: $$Excel-Macros$$ Re: Vlookup Help required To: Cc: , Try this. > Regards, Mandeep Baluja LearningZmyPassion https://www.linkedin.com/profile/v

Re: Fwd: $$Excel-Macros$$ Re: Help required for Match DATA

2015-01-06 Thread Paul Schreiner
----- From: Ashu k >To: Mandeep Baluja ; excel-macros > >Sent: Tuesday, January 6, 2015 11:38 AM >Subject: Fwd: $$Excel-Macros$$ Re: Help required for Match DATA > > > >Dear Mandeep Sir, > > >Please help on this. The sheet is provided by you is

Fwd: $$Excel-Macros$$ Re: Help required for Match DATA

2015-01-06 Thread Ashu k
Dear Mandeep Sir, Please help on this. The sheet is provided by you is providing NA#. Please Help. Thanks Ashu Kenith -- Forwarded message -- From: Ashu k Date: Wed, Dec 31, 2014 at 11:52 AM Subject: Fwd: $$Excel-Macros$$ Re: Help required for Match DATA To: Mandeep Baluja

Re: Fwd: $$Excel-Macros$$ Happy New 2015

2015-01-01 Thread Rupesh Patil
Happy new year to all!!! On 01-Jan-2015 12:14 PM, "Sandeep Sharma" wrote: > Welcome and wish u Happy new year all Group members. > > > With Regards > Sandeep Kumar Sharma > > *“Always laugh when you can. It is cheap medicine.*” > > -- Forwarded message -- > From: Ganesh N > Date:

Fwd: $$Excel-Macros$$ Happy New 2015

2014-12-31 Thread Sandeep Sharma
Welcome and wish u Happy new year all Group members. With Regards Sandeep Kumar Sharma *“Always laugh when you can. It is cheap medicine.*” -- Forwarded message -- From: Ganesh N Date: Thu, Jan 1, 2015 at 9:41 AM Subject: Re: $$Excel-Macros$$ Happy New 2015 To: "excel-macros@go

Fwd: $$Excel-Macros$$ Re: Help required for Match DATA

2014-12-30 Thread Ashu k
Dear Mandeep Sir, Please help me on the same issue. Thse sheet is provided by you is not giving correct output. It gives NA# again. Kindly run macro and see the result in Cell C1 and C2. Sheet is attached. Thanks Ashu Kenith -- Forwarded message -- From: Ashu k Date: Tue, Dec

Fwd: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

2014-12-23 Thread C.G.Kumar
May someone please look and advise macro to solve the puzzle. Thanks and Regards, C.G.Kumar -- Forwarded message - From: C.G.Kumar Date: Mon Dec 22 2014 at 7:09:55 PM Subject: Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory To: excel-macros@googlegroups.com Macro is not

Fwd: $$Excel-Macros$$ solve vba Query

2014-12-22 Thread Vaibhav Joshi
PFA + *I did not do this for you. God is here working through me for you.* -- Forwarded message -- From: Vaibhav Joshi Date: Sat, Dec 20, 2014 at 6:33 PM Subject: Re: $$Excel-Macros$$ solve vba Query To: Ashish Kumar Check formula column... Cheers!! + *I did not do t

Fwd: $$Excel-Macros$$ Re: Dates

2014-12-12 Thread Pol Ktk
Sir, Check this [image: Inline image 1] On Fri, Dec 12, 2014 at 6:07 PM, Mandeep Baluja wrote: > > Hey paul, > > Thanks for reply I have highlighted number of *Dates *not days. I want > number of dates between two dates. > > Like Start date > 12/12/2014 > end date > 12/22/2014 > > Formula shou

Fwd: $$Excel-Macros$$ Automatic update excel file from website

2014-11-04 Thread Vaibhav Joshi
FYI + *I did not do this for you. God is here working through me for you.* -- Forwarded message -- From: Vaibhav Joshi Date: Sat, Nov 1, 2014 at 3:17 PM Subject: Re: $$Excel-Macros$$ Automatic update excel file from website To: "excel-macros@googlegroups.com" check this...

Fwd: $$Excel-Macros$$ Moving Completed rows to sheet2

2014-09-22 Thread Eugene Bernard
Dear Joshi, Thanks for your reply. As already explained in my first post, rows having code with 11 is not to be treated as completed, since 3 rows having codes as 11 is with status tag blank. The logic for moving the rows from sheet1 to sheet2 is rows with status tag with "C" if it has un

Fwd: $$Excel-Macros$$ Moving Completed rows to sheet2

2014-09-21 Thread Eugene Bernard
-- Forwarded message -- From: Eugene Bernard Date: Sun, Sep 21, 2014 at 8:54 PM Subject: $$Excel-Macros$$ Moving Completed rows to sheet2 To: excel-macros@googlegroups.com Dear all, Please find attached a sample worksheet, where in i like to move the completed rows to sheet 2 fr

Re: Fwd: $$Excel-Macros$$ Doubt MBA

2014-08-23 Thread Marcio Bandeira
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* > - > >*From:* Marcio Bandeira > *To:* excel-macros@googlegroups.com > *S

Re: Fwd: $$Excel-Macros$$ Doubt MBA

2014-08-22 Thread Paul Schreiner
> From: Marcio Bandeira >To: excel-macros@googlegroups.com >Sent: Thursday, August 21, 2014 9:04 PM >Subject: Fwd: $$Excel-Macros$$ Doubt MBA > > > >i forgot something very importante. I need a extra collum to say if I send the >file to this cliente or not. New example. Tks!!!

Fwd: $$Excel-Macros$$ Doubt MBA

2014-08-21 Thread Marcio Bandeira
i forgot something very importante. I need a extra collum to say if I send the file to this cliente or not. New example. Tks!!! Hi. I need a help. I have a worksheet and I need to build a macro that send a file, with the name is in collum B to the e-mails at collum c. THere is a Excel attached to

Fwd: $$Excel-Macros$$X Copy sand paste dynamic data range

2014-08-14 Thread C.G.Kumar
Hi, Can añy one would suggest ; 1. How to copy data from specific worksheeet . data range is dynamic meaning end row is varying but header row remain from m a1 to h1. 2. Paste data so copied in body of the email. Or copy data from excel , store it as image and then use some code to pull this im

Fwd: $$Excel-Macros$$ Fwd: Excel Query

2014-08-04 Thread Satendra kumar
Hi All Expert, Please find the attachment & assist me, what i do in this condition? -- Thanks & Regards Satendra Kumar -- 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/di

Re: Fwd: $$Excel-Macros$$ Need VBA code to convert multi-pages PDF file into multiple sheets Excel Spreadsheet

2014-08-04 Thread Mayank Agarwal
- > >*From:* Mayank Agarwal > *To:* excel-macros@googlegroups.com > *Sent:* Monday, August 4, 2014 2:35 PM > *Subject:* Fwd: $$Excel-Macros$$ Need VBA code to convert multi-pages PDF > file into multiple sheets Excel Spreadsheet > > Hello expert, > > need

Re: Fwd: $$Excel-Macros$$ Need VBA code to convert multi-pages PDF file into multiple sheets Excel Spreadsheet

2014-08-04 Thread Paul Schreiner
all the people you can, As long as ever you can.” - John Wesley - > > From: Mayank Agarwal >To: excel-macros@googlegroups.com >Sent: Monday, August 4, 2014 2:35 PM >Subject: Fwd: $$Excel-Macros$$ Need VBA c

Fwd: $$Excel-Macros$$ Need VBA code to convert multi-pages PDF file into multiple sheets Excel Spreadsheet

2014-08-04 Thread Mayank Agarwal
Hello expert, need your help to write macro for atached file; In a file I need to filter data on a country wise and to create new tab for a respective country with the country name as a tab name and patste respective country data there Thanks for your help Regards, Mayank -- Are you =EXP(E:R

Re: Fwd: $$Excel-Macros$$ quick help

2014-07-13 Thread Vaibhav Joshi
Chek Rule no. 3. On Jul 13, 2014 12:04 PM, "daya p" wrote: > sir, > my request prob not done by group members > is any expert? pls see. > > > Subject: $$Excel-Macros$$ quick help > To: excel-macros@googlegroups.com > > > > i am new member, > the file contains sales vlook data unlock pls > i want

  1   2   3   4   5   >