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

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

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

2017-09-19 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

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

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

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

2017-07-10 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

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

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

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 <chatterjee.kolk...@gmail.com> wrote: Subject: Re: Fwd: Fwd: $$Excel-Macros$$ copy data from one sheet to other based on condition To: "excel-macros" <excel-macros@googlegroups.com>

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

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

2017-05-19 Thread Sanjib Chatterjee
Sent from BlueMail <http://www.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 <chatterjee.kolk...@gmail.com> >>

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

2017-05-19 Thread Jitendra Singh
b Chatterjee <chatterjee.kolk...@gmail.com> >Date: Fri, May 19, 2017 at 1:18 PM >Subject: Re: Fwd: $$Excel-Macros$$ copy data from one sheet to other >based >on condition >To: excel-macros <excel-macros@googlegroups.com>, >schreiner_p...@att.net > > >Dear Paul Schrei

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

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

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

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 <

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

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 <excel-macros@googlegroups.com> wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 6

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 <excel-macros@googlegroups.com> wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 5

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 <excel-macros@googlegroups.com> wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 4

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 <excel-macros@googlegroups.com> wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 2

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 <excel-macros@googlegroups.com> wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 12

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 <excel-macros@googlegroups.com> wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 10

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 <excel-macros@googlegroups.com> wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 6

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 <excel-macros@googlegroups.com> wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 2

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

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 <excel-macros@googlegroups.com> wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 12

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 <excel-macros@googlegroups.com> wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 12

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 <shrinivas...@gmail.com> 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

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

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

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 <excel-macros@googlegroups.com> wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Wednesday, January 4, 2017, 4

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

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 <schreiner_p...@att.net> wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> Date: Wednesday, January 4, 2017

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

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

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

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 <dbank...@gmail.com> Date: Sun, Oct 9, 2016 at 1:24 PM Subject: Fwd: $$Excel-Macros$$ Conditional calculation required for multiple criteria. To: excel-macros@googlegrou

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

2016-10-11 Thread Dheeraj Bankoti
HI IS IT POSSIBLE? -- Forwarded message -- From: Dheeraj Bankoti <dbank...@gmail.com> 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 m

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

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

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

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

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

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

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

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

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

2016-05-24 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

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 <dbank...@gmail.com> 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 D

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:

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

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

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

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

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

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

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"

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 nilkanth.ra...@gmail.com mailto:nilkanth.ra...@gmail.com

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 d...@premor.net wrote: Hi Nilkanth, PFA, hope it

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 nilkanth.ra...@gmail.com Date: Jul 28, 2015 3:59 PM Subject: $$Excel-Macros$$ Send Bulk Mail Macro To: excel-macros@googlegroups.com Cc: Hi, I have created Macro to

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 chatterjee.kolk...@gmail.com Date: Mon, Jul 20, 2015 at 10:44 AM Subject: $$Excel-Macros$$ cut option is disable in excel 2003 To: excel-macros excel-macros@googlegroups.com,

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

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 soumyendu...@gmail.com wrote: -- Forwarded message -- From: Soumyendu Paul soumyendu...@gmail.com Date: Jun 3, 2015 4:21 PM Subject: $$Excel-Macros$$ Query (Outlook VBA) To: excel-macros@googlegroups.com Cc: Hi, I

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 rameshwarish...@gmail.com 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,

Fwd: $$Excel-Macros$$ PLS SOLVE

2015-03-09 Thread Pramod Singh
Hi David. .. PFA Pramod -- Forwarded message -- From: Pramod Singh pramod...@gmail.com Date: 9 Mar 2015 11:33 Subject: Fwd: $$Excel-Macros$$ PLS SOLVE To: Pramod Singh pramod.si...@analec.com Cc: Pramod -- Forwarded message -- From: sush.dav...@gmail.com Date: 9

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

2015-03-03 Thread Sanjib Chatterjee
-- Forwarded message -- From: Sanjib Chatterjee chatterjee.kolk...@gmail.com Date: Tue, Mar 3, 2015 at 2:51 PM Subject: $$Excel-Macros$$ need solution without vba function To: excel-macros excel-macros@googlegroups.com, NOORAIN ANSARI noorain.ans...@gmail.co, NOORAIN ANSARI

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

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

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 nilkanth.ra...@gmail.com Date: Feb 28, 2015 2:04 AM Subject: $$Excel-Macros$$ Income Statement Review Macro To: excel-macros@googlegroups.com, Vaibhav Joshi v...@vabs.in Cc:

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

2015-02-27 Thread Ashish Bhalara
-- Forwarded message -- From: Ashish Bhalara ashishbhalar...@gmail.com 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.

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

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

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 v...@vabs.in Date: Fri, Jan 30, 2015 at 2:29 PM Subject: Re: $$Excel-Macros$$ Colour the Group Rows To:

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

2015-01-10 Thread Rakesh
Kindly with suitable formula urgenly required Rakesh -- Forwarded message -- From: Mandeep Baluja rockerna...@gmail.com Date: 06-Jan-2015 5:52 PM Subject: $$Excel-Macros$$ Re: Vlookup Help required To: excel-macros@googlegroups.com Cc: noorain.ans...@gmail.com,

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

2015-01-06 Thread Paul Schreiner
: 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 providing NA#. Please Help. Thanks Ashu Kenith -- Forwarded message -- From: Ashu k direct2as

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 direct2as...@gmail.com Date: Wed, Dec 31, 2014 at 11:52 AM Subject: Fwd: $$Excel-Macros$$ Re: Help required for Match DATA

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 sandeepsharma4...@gmail.com 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:

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 ganeshg...@gmail.com Date: Thu, Jan 1, 2015 at 9:41 AM Subject: Re: $$Excel-Macros$$ Happy New 2015

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

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 kumar.bemlmum...@gmail.com Date: Mon Dec 22 2014 at 7:09:55 PM Subject: Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory To:

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 v...@vabs.in Date: Sat, Dec 20, 2014 at 6:33 PM Subject: Re: $$Excel-Macros$$ solve vba Query To: Ashish Kumar kumar.ashish...@gmail.com Check formula

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 rockerna...@gmail.com 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

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 v...@vabs.in Date: Sat, Nov 1, 2014 at 3:17 PM Subject: Re: $$Excel-Macros$$ Automatic update excel file from website To: excel-macros@googlegroups.com

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

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

2014-09-21 Thread Eugene Bernard
-- Forwarded message -- From: Eugene Bernard eugene.bern...@gmail.com 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

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

2014-08-23 Thread Marcio Bandeira
,To all the people you can,As long as ever you can.” - John Wesley* - *From:* Marcio Bandeira marciobandeir...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thursday, August 21, 2014 9:04 PM *Subject:* Fwd: $$Excel-Macros$$ Doubt MBA i forgot

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

2014-08-22 Thread Paul Schreiner
-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!!! Hi. I need a help. I have a worksheet and I need to build

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

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

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

2014-08-04 Thread Paul Schreiner
you can, As long as ever you can.” - John Wesley - From: Mayank Agarwal lko.may...@gmail.com To: excel-macros@googlegroups.com Sent: Monday, August 4, 2014 2:35 PM Subject: Fwd: $$Excel-Macros$$ Need VBA code to convert multi

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

2014-08-04 Thread 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 your help to write macro for atached file; In a file I need to filter data on a country

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 @

Fwd: $$Excel-Macros$$ quick help

2014-07-13 Thread daya p
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 to edit it (provided by sen) needed urgently for 2marow work thanks in advance

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 princedaya2...@gmail.com 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

Fwd: $$Excel-Macros$$ Excel table view to xml format

2014-06-25 Thread yogananda muthaiah
Can anyone help me out -- Forwarded message -- From: yogananda muthaiah yogananda.mutha...@gmail.com Date: Tue, Jun 24, 2014 at 10:39 PM Subject: $$Excel-Macros$$ Excel table view to xml format To: excel-macros excel-macros@googlegroups.com Hello Champs, Attached Excel in

Re: Fwd: $$Excel-Macros$$ Value need to update as per master (excel sheet Attached)

2014-05-05 Thread Vaibhav Joshi
*To:* excel-macros@googlegroups.com *Sent:* Thursday, May 1, 2014 2:26 AM *Subject:* Fwd: $$Excel-Macros$$ Value need to update as per master (excel sheet Attached) Dear Ravinder, Thanks for writing. Hope I clarify on below. I have one macro by that macro some value get calculate

Re: Fwd: $$Excel-Macros$$ Value need to update as per master (excel sheet Attached)

2014-05-05 Thread rameshwari shyam
the times you can, To all the people you can,As long as ever you can.” - John Wesley* - *From:* rameshwari shyam rameshwarish...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thursday, May 1, 2014 2:26 AM *Subject:* Fwd: $$Excel-Macros$$ Value

  1   2   3   4   >