Re: $$Excel-Macros$$ something wrong with the attach macro

2017-01-18 Thread GENIUS
That's working for me as well, thank you -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles,

Re: $$Excel-Macros$$ converting sheet to macro

2017-01-18 Thread GENIUS
I think there is some misunderstanding, actually I need a macro for column A:F, I want to create the same i.e. column A:F thru macro, because if you see column A:F created thru formulas and the source of references has been taken from column I:L, so column I:L are just for references and nothing

Re: $$Excel-Macros$$ Double Asterisks Problem

2017-01-18 Thread Bill Q
Perfect. Thank you Paul. On Wednesday, 18 January 2017 12:20:55 UTC-5, Paul Schreiner wrote: > > The "escape" character in Excel filters is a tilde (~) > > so, in your filter, you could look for records that begin with ~*~* > > > *Paul* > - > > > > > > > >

Re: $$Excel-Macros$$ converting sheet to macro

2017-01-18 Thread silvers.r via MS EXCEL AND VBA MACROS
On Wed, 1/18/17, georgemartin812 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ converting sheet to macro To: excel-macros@googlegroups.com Date: Wednesday, January 18, 2017, 9:04 PM -

Re: $$Excel-Macros$$ converting sheet to macro

2017-01-18 Thread georgemartin812 via MS EXCEL AND VBA MACROS
On Wed, 1/18/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ converting sheet to macro To: excel-macros@googlegroups.com Date: Wednesday, January 18, 2017, 8:47 PM -

Re: $$Excel-Macros$$ converting sheet to macro

2017-01-18 Thread hopkinsruben865 via MS EXCEL AND VBA MACROS
On Wed, 1/18/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ converting sheet to macro To: excel-macros@googlegroups.com Date: Wednesday, January 18, 2017, 8:17 PM

Re: $$Excel-Macros$$ converting sheet to macro

2017-01-18 Thread karleenbiggs via MS EXCEL AND VBA MACROS
On Wed, 1/18/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ converting sheet to macro To: excel-macros@googlegroups.com Date: Wednesday, January 18, 2017, 6:13 PM ---

Re: $$Excel-Macros$$ Double Asterisks Problem

2017-01-18 Thread Paul Schreiner
The "escape" character in Excel filters is a tilde (~) so, in your filter, you could look for records that begin with ~*~*  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,

Re: $$Excel-Macros$$ How to use Index Match for two different files

2017-01-18 Thread Devendra Sahay
Paul, would you please look into this. On Jan 16, 2017 9:31 AM, "Devendra Sahay" wrote: > Hey Paul, > > > Would you please look into this. > > > On Sat, Jan 14, 2017 at 11:07 AM, Devendra Sahay < > devendrasahanypt...@gmail.com> wrote: > >> Hi Paul, >> >> Yes both columns have only one column, I

Re: $$Excel-Macros$$ something wrong with the attach macro

2017-01-18 Thread Paul Schreiner
I made a minor change and it works for me: Option Explicit Sub InvoiceVariables()Dim InvoiceDate As Date Dim InvoiceID As Long Dim Client As String Dim subTotal As Currency Dim Salestax As Currency Dim invoiceTotal As Currency InvoiceDate = Sheets("Invoice").Range("E2").Value InvoiceID = Sheets("In

$$Excel-Macros$$ Double Asterisks Problem

2017-01-18 Thread Bill Q
Hi, I have a large list with part descriptions. We use two asterisks at the beginning of a part number as a special internal message. In Excel I cannot find a way to filter two asterisks together as it is obviously treating it as a wildcard. How can I get around this ? Thanks. -- Are you

$$Excel-Macros$$ something wrong with the attach macro

2017-01-18 Thread Izhar
I want to move the details of sheet "Invoice" to "Invoice Tracker", Please check where I'm making a mistake. Thanks in advance -- 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

Re: $$Excel-Macros$$ converting sheet to macro

2017-01-18 Thread julienneschindler via MS EXCEL AND VBA MACROS
On Wed, 1/18/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ converting sheet to macro To: "excel-macros@googlegroups.com" Date: Wednesday, January 18, 2017, 4:37 PM So, you're saying that you're trying to learn how to write macros an

Re: $$Excel-Macros$$ converting sheet to macro

2017-01-18 Thread Paul Schreiner
So, you're saying that you're trying to learn how to write macros and you'd like us to write a macro that would take the list in columns A:F and create the list in columns I:L? The problem with that is that you're asking us to take the "input" (columns A:F) and compare it to the output (columns

$$Excel-Macros$$ DevOps Engineer @ San Francisco,CA.

2017-01-18 Thread govind ramanujam
Hello, Hope you are doing great We have an urgent below *"DevOps Engineer”* position with one of our client for C2C position at *San Francisco,CA.* If you are interested please share your updated resume along with contact details to *govind_ramanu...@visionisys.com * *Job Title : San F

$$Excel-Macros$$ DevOps Engineer @ San Francisco, CA

2017-01-18 Thread govind ramanujam
Hello, Hope you are doing great We have an urgent below *"DevOps Engineer”* position with one of our client for C2C position at *San Francisco,CA.* If you are interested please share your updated resume along with contact details to *govind_ramanu...@visionisys.com * *Job Title : San F

$$Excel-Macros$$ Pega Developer @ San Francisco, CA

2017-01-18 Thread govind ramanujam
Hello, Hope you are doing great We have an urgent below *"Pega Developer”* position with one of our client for C2C position at *San Francisco, CA.* If you are interested please share your updated resume along with contact details to govind_ramanu...@visionisys.com *Job Title : Pega De

$$Excel-Macros$$ "Sr.Microstrategy Developer" @ Weehawken, NJ.

2017-01-18 Thread govind ramanujam
Hello, Hope you are doing great We have an urgent below *"Sr. Microstrategy Developer”* position with one of our client for C2C position at *Weehawken, NJ.* If you are interested please share your updated resume along with contact details to *govind_ramanu...@visionisys.com * *Job Title