Re: $$Excel-Macros$$ Help Required

Select the column, right click then select “Format Cells”. In that category select as Date and in Type select as per your required format. Hope this is helpful. On Tuesday, November 27, 2018, Neeraj Gmail wrote: > Dear Expert, > > > > I want to change the date format as per given below > > > >

Re: $$Excel-Macros$$ Help - Recorded Formula Not Ending Up In Cell Correctly

Hi, I really appreciate the assistance, but that has nothing to do with my issue. The formula I'm using is the recorded version of the working formula. But thanks! John On Tuesday, April 3, 2018 at 7:02:47 AM UTC-4, Aas mh wrote: > Hi You are using a slightly wrong one, > > try to change R[-7]

Re: $$Excel-Macros$$ Help - Recorded Formula Not Ending Up In Cell Correctly

Hi You are using a slightly wrong one, try to change R[-7] to R[-6] like below: =IF(AND(R[-6]C[-5]<>R[-7]C[-5].. and rest yourself. On Sat, Mar 31, 2018 at 4:55 AM, Johnny wrote: > Hi All, this is the strangest problem I've ever had with inserting a > formula into a cell

Re: $$Excel-Macros$$ Help Req.

help if formula will implement at sheet 2 > > > > *From:* excel-macros@googlegroups.com [mailto:excel-macros@ > googlegroups.com] *On Behalf Of *Rabindra Thapa > *Sent:* 20 September 2017 03:46 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help Req. &

Re: $$Excel-Macros$$ Help Req.

Last Date =INDEX(Sheet1!$C:$C,MATCH($A2,Sheet1!$A$2:$A$11270,0)+(COUNTIF(Sheet1!$A:$A,$A2))) Second Last Date =INDEX(Sheet1!$C:$C,MATCH($A2,Sheet1!$A$2:$A$11270,0)+(COUNTIF(Sheet1!$A:$A,$A2))-1) if need for quantity wise, have to use vba *Regards,* *For quick responds click here for Message

Re: $$Excel-Macros$$ Help Req.

=RIGHT(B3,2) *Regards,* *For quick responds click here for Message * On Sat, Sep 16, 2017 at 7:17 PM, Neeraj Gmail wrote: > Dear experts, > > > > Kindly find the sheet I want to put last two entries against Indus ID, can > we solve with

Re: $$Excel-Macros$$ Help on Week Formula

AND VBA MACROS < > excel-macros@googlegroups.com> wrote: > > Subject: Re: $$Excel-Macros$$ Help on Week Formula > To: excel-macros@googlegroups.com > Date: Sunday, July 30, 2017, 11:56 PM > > > > On Sun, 7/30/17, 'Marti

Re: $$Excel-Macros$$ Help on Week Formula

On Sun, 7/30/17, 'Yu Spain' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Help on Week Formula To: excel-macros@googlegroups.com Date: Sunday, July 30, 2017, 11

Re: $$Excel-Macros$$ Help on Week Formula

On Sun, 7/30/17, 'Martinez David' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Help on Week Formula To: excel-macros@googlegroups.com Date: Sunday, July 30, 2017, 8

Re: $$Excel-Macros$$ Help on Week Formula

On Sun, 7/30/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Help on Week Formula To: excel-macros@googlegroups.com Date: Sunday, July 30, 2017, 3

Re: $$Excel-Macros$$ Help on Week Formula

On Sun, 7/30/17, Chandra Shekar <chandrashekarb@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ Help on Week Formula To: excel-macros@googlegroups.com Date: Sunday, July 30, 2017, 2:57 PM Hello Paul, For Ex: If I mention date as

Re: $$Excel-Macros$$ Help on Week Formula

Hello Paul, For Ex: If I mention date as 07/01/2017(Sat) formula should give Week 1 from there every week it should increase by 1. 1) 07-01-2017 to 07-07-2017 = Week1 2) 22-01-2017 to 28-07-2017 = Week4 3) 29-07-2017 - 04-08-2017 = Week5 Regards, Chandru On Tue, Jul 25, 2017 at 4:31 PM, Paul

Re: $$Excel-Macros$$ Help on Week Formula

I think you'll need to be more specific on how you want the "weeks" calculated.For instance, in August (2017) August 1 is on  a Tuesday. so, the weeks are handled: but, July 1 is on a Saturday,so, does Week 1 only have a single day? Or is July 1 counted as part of week 5 of June.If so, what is

Re: $$Excel-Macros$$ Help on Week Formula

Please use the following formula in the cell C2 ="WK"((DAY(A2)+6)/7) And drag down to copy the formula. Cheers!! Aindril On Tue, Jul 25, 2017 at 1:03 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello Team, > > Could you please help me in attached week formula. > > Regards, > >

Re: $$Excel-Macros$$ Help required in excel

On Sun, 7/16/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Help required in excel To: excel-macros@googlegroups.com Date: Sunday, July 16, 2017, 1

Re: $$Excel-Macros$$ Help required in excel

On Sat, 7/15/17, Manoj Garg <datac...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ Help required in excel To: excel-macros@googlegroups.com, srinu88...@gmail.com Date: Saturday, July 15, 2017, 7:19 PM You can use Exact(text1,

Re: $$Excel-Macros$$ Help required in excel

You can use Exact(text1, text2) On Sat, Jul 15, 2017 at 8:01 PM, Srinivas G wrote: > Hi Friends, > > I want to help in Excel > > ramu Ramu False > Raju Raju True > mohan Mohan False > Venu VenuTrue > SAISai False

Re: $$Excel-Macros$$ Help with a formula problem.

> > So it would be as simple as... > # Of Transactions = 250 100 Transactions @ $60 = $6,000 x Billing Rate of .003 = $18 Fee 150 Transactions @ $40 = $6,000 x Billing Rate of .002 = $12 Fee Total Fees = $30 -- # Of Transactions = 50 25 Transactions @ $60 = $1,500 x Billing Rate of

Re: $$Excel-Macros$$ Help with a formula problem.

Hi, Please provide sample data and expected output. Regards, Swapnil Suresh Palande On Thu, May 4, 2017 at 8:21 PM, Spencer Patterson < williamspencerpatter...@gmail.com> wrote: > I need to solve a problem and I need help with the IF:THEN:ELSE > calculation please. > > > I need to create a

Re: $$Excel-Macros$$ Help Required

On Sun, 1/22/17, julienneschindler via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Help Required To: excel-macros@googlegroups.com Date: Sunday, January 22, 2017, 6

Re: $$Excel-Macros$$ Help Required

On Sat, 1/21/17, sriram ji <sriramg...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ Help Required To: excel-macros@googlegroups.com Date: Saturday, January 21, 2017, 12:24 PM Thank you so much  Saleem Ansari. File working fine and

Re: $$Excel-Macros$$ Help Required

Thank you so much Saleem Ansari. File working fine and also i need same format splitup in master file. i attached the file. Kindly help me.. Thank in advance. Thanks & Regards, Sriram G On Thu, Jan 12, 2017 at 6:35 PM, Saleem Ansari wrote: > Dear Friend, > >

Re: $$Excel-Macros$$ Help Required

On Thu, 1/12/17, storeythomas725 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Help Required To: excel-macros@googlegroups.com Date: Thursday, January 12, 2017, 10

Re: $$Excel-Macros$$ Help Required

On Thu, 1/12/17, julienneschindler via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Help Required To: excel-macros@googlegroups.com Date: Thursday, January 12, 2017, 10

Re: $$Excel-Macros$$ Help Required

On Thu, 1/12/17, georgemartin812 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Help Required To: excel-macros@googlegroups.com Date: Thursday, January 12, 2017, 8

Re: $$Excel-Macros$$ Help Required

On Thu, 1/12/17, spainy via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Help Required To: excel-macros@googlegroups.com Date: Thursday, January 12, 2017, 8

Re: $$Excel-Macros$$ Help Required

On Thu, 1/12/17, martinez.david533 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Help Required To: excel-macros@googlegroups.com Date: Thursday, January 12, 2017, 7

Re: $$Excel-Macros$$ Help Required

On Thu, 1/12/17, Saleem Ansari <saleem.logic...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ Help Required To: excel-macros@googlegroups.com Date: Thursday, January 12, 2017, 3:06 PM Dear Friend, Please check & Confirm if any

Re: $$Excel-Macros$$ Help Required

First of all, take a look at the Forum "rules".some of them are just simple good ideas, like: 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. The

Re: $$Excel-Macros$$ Help Required

Dear Friend, Please check & Confirm if any query plz revert Regards, Saleem Ansari On Thu, Jan 12, 2017 at 6:35 PM, Saleem Ansari wrote: > Dear Friend, > > Please check & Confirm > > if any query plz revert > > Regards, > Saleem Ansari > > On Thu, Jan 12, 2017 at

Re: $$Excel-Macros$$ Help Required

Dear Friend, Please check & Confirm if any query plz revert Regards, Saleem Ansari On Thu, Jan 12, 2017 at 2:13 PM, sriram ji wrote: > Hi Excel Guru, > > Kindly help me the below attached file, > > Thanks in advance. > > Thanks & Regards, > Sriram G > > -- > Are you

Re: $$Excel-Macros$$ Help with Conditionally Formatting

On Wed, 1/4/17, keisha.fry via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Help with Conditionally Formatting To: excel-macros@googlegroups.com Date: Wednesday, January 4, 2017, 10

Re: $$Excel-Macros$$ Help with Conditionally Formatting

On Wed, 1/4/17, martinez.david533 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Help with Conditionally Formatting To: excel-macros@googlegroups.com Date: Wednesday, January 4, 2017, 7

Re: $$Excel-Macros$$ Help with Conditionally Formatting

On Wed, 1/4/17, spainy via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Help with Conditionally Formatting To: excel-macros@googlegroups.com Date: Wednesday, January 4, 2017, 6

Re: $$Excel-Macros$$ Help with Conditionally Formatting

On Wed, 1/4/17, ileanakeating via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Help with Conditionally Formatting To: excel-macros@googlegroups.com Date: Wednesday, January 4, 2017, 5

Re: $$Excel-Macros$$ Help with Conditionally Formatting

On Wed, 1/4/17, storeythomas725 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Help with Conditionally Formatting To: excel-macros@googlegroups.com Date: Wednesday, January 4, 2017, 3

Re: $$Excel-Macros$$ Help with Conditionally Formatting

On Wed, 1/4/17, mahergeorge503 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Help with Conditionally Formatting To: excel-macros@googlegroups.com Date: Wednesday, January 4, 2017, 12

Re: $$Excel-Macros$$ Help with Conditionally Formatting

On Tue, 1/3/17, storeythomas725 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Help with Conditionally Formatting To: excel-macros@googlegroups.com Date: Tuesday, January 3, 2017, 5

Re: $$Excel-Macros$$ Help with Conditionally Formatting

On Tue, 1/3/17, storeythomas725 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Help with Conditionally Formatting To: excel-macros@googlegroups.com Date: Tuesday, January 3, 2017, 5

Re: $$Excel-Macros$$ Help with Conditionally Formatting

On Tue, 1/3/17, Mack Mans <mackman...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ Help with Conditionally Formatting To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com> Cc: ahprad...@gmail.com Date: Tuesday, Ja

Re: $$Excel-Macros$$ Help with Conditionally Formatting

> > http://tutorialway.com/conditional-cell-format-in-excel/ check this site -- 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,

Re: $$Excel-Macros$$ Help required in conditional formatting

> > http://tutorialway.com/conditional-cell-format-in-excel/ help ful wbsite -- 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,

Re: $$Excel-Macros$$ Help in IF Function

On Thu, 12/29/16, margaretatolliver via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Help in IF Function To: excel-macros@googlegroups.com Date: Thursday, December 29, 2016, 7

Re: $$Excel-Macros$$ Help in IF Function

On Thu, 12/29/16, keisha.fry via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Help in IF Function To: excel-macros@googlegroups.com Date: Thursday, December 29, 2016, 6

Re: $$Excel-Macros$$ Help in IF Function

On Thu, 12/29/16, libertystringer via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Help in IF Function To: excel-macros@googlegroups.com Date: Thursday, December 29, 2016, 5

Re: $$Excel-Macros$$ Help in IF Function

On Thu, 12/29/16, martinez.david533 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Help in IF Function To: excel-macros@googlegroups.com Date: Thursday, December 29, 2016, 3

Re: $$Excel-Macros$$ Help in IF Function

On Thu, 12/29/16, silvers.r via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Help in IF Function To: excel-macros@googlegroups.com Date: Thursday, December 29, 2016, 12

Re: $$Excel-Macros$$ Help in IF Function

On Thu, 12/29/16, Mack Mans <mackman...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ Help in IF Function To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com> Cc: lupins...@yahoo.com Date: Thursday, Decem

Re: $$Excel-Macros$$ Help in IF Function

On Wednesday, September 7, 2011 at 12:11:20 AM UTC+5, lupinskip wrote: > > result by IF function > > regards, > Pawel > > -- > *From:* anu gomathi > *To:* excel-...@googlegroups.com > *Sent:* Tuesday, September 6, 2011 9:00 PM > *Subject:*

Re: $$Excel-Macros$$ Help Needed on Index

You can't have an Excel function replace the values in the cell.You could use VBA, but it would be easier to simply use VLOOKUP. In Cell B21, put:=VLOOKUP(C21,$A$10:$B$17,2,FALSE)Then copy this down to row 29. HIghlight the cells and ctrl-CThen, right-click cell C21 and Paste Values. 

Re: $$Excel-Macros$$ Help with Proper Syntax for Range function with variables

Thank you Ashish it works perfectly. I will save this info so I don't repeat my question in the future. Much appreciated. -- John On Friday, November 4, 2016 at 4:08:49 PM UTC-4, ashish wrote: > try > > Range("A" & bottom & ":M" & bottom).Select > > On Sat, Nov 5, 2016 at 1:34 AM, Johnny

Re: $$Excel-Macros$$ Help with Proper Syntax for Range function with variables

try Range("A" & bottom & ":M" & bottom).Select On Sat, Nov 5, 2016 at 1:34 AM, Johnny wrote: > I searched for the answer to this before posting. I know what I'm trying > to do can work, it's just that the syntax is kicking my butt > > I find the bottom row number (in my

Re: $$Excel-Macros$$ Help for if condition....

Here you go. On Fri, Jul 22, 2016 at 12:47 AM, Mustapha LMIDMANI < lmidmani.musta...@gmail.com> wrote: > Hello, > > Please check this ? is what do you want? > > 2016-07-22 8:42 GMT+01:00 Neeraj Pal : > >> Hi All, >> >> Please solve my if condition >> >> --

Re: $$Excel-Macros$$ Help for if condition....

Hello, Please check this ? is what do you want? 2016-07-22 8:42 GMT+01:00 Neeraj Pal : > Hi All, > > Please solve my if condition > > -- > 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

Re: $$Excel-Macros$$ $$Help Required$$

use this: ={IFERROR(VLOOKUP($A3$1,CHOOSE({1,2},$M$13:$M$22&$O$13:$O$22,$N$13:$N$22),2,0),0)} *PJ * *MIS Analyst* *Greater Kailash-1, New Delhi.* *Instagram* *pj_sharma_* *Tweeter* *dude_sharma_pj**Facebook**

Re: $$Excel-Macros$$ Help on Vlookup

pfa attached without helping column. Vikas Verma Thanks & regards, www.MrExcel4U.com On Fri, Jun 17, 2016 at 12:22 AM, vikas khen wrote: > Hi all, > > > > Need your help on attached excel sheet as my vlookup formula is not > reflecting the

Re: $$Excel-Macros$$ Help on Vlookup

Thanks deepak for urgent help Regards, On Jun 17, 2016 13:03, "deepak kumar" wrote: > hi, > > PFA > > On 17 June 2016 at 12:52, vikas khen wrote: > >> Hi all, >> >> >> >> Need your help on attached excel sheet as my vlookup formula is not >> reflecting

Re: $$Excel-Macros$$ Help on Vlookup

hi, PFA On 17 June 2016 at 12:52, vikas khen wrote: > Hi all, > > > > Need your help on attached excel sheet as my vlookup formula is not > reflecting the value. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join

Re: $$Excel-Macros$$ Help to create data table

? On Fri, Jun 10, 2016 at 12:06 AM, Rabindra Thapa wrote: > Dear Excel guru, > > Can you give a idea how to create date enter sheet as per attach file.. > > i.e when i entry data on sheet 1 and entry press button, that data > automatically go to sheet 2 . > > kindly

Re: $$Excel-Macros$$ help required

Dear Abhisek I want to reconile the data and show the hanging in both the accounts as we normally do in bank reconciliation. If iam doing vlookup chances of overlooking same amount exist in both the accounts as you have seen same cost amount exists in both vendor & ledg which should be matched

Re: $$Excel-Macros$$ help required

>From your data, please give me an example of what exactly you want On Wed, May 25, 2016 at 7:53 PM, Cute Awesome wrote: > Dear Abhishek, > > But the dates won't be the similar with my ledger and vendor since vendor > would be giving the amount details line wise for the

Re: $$Excel-Macros$$ help required

Dear Abhishek, But the dates won't be the similar with my ledger and vendor since vendor would be giving the amount details line wise for the amount which needs to be reconciled with my ledger account ensuring amount received for all lines which mentioned. awaiting your help. I would be having

Re: $$Excel-Macros$$ HELP REQUIRED TO ESTABLISH FORMULA

Welcome!glad you could join us. As a GROUP, we offer our assistance free of charge.However, sometimes the project requires a great deal of time and effort. SOME of our members do this type of work for a living and may ask for compensation for large projects.If that were to happen, that is worked

Re: $$Excel-Macros$$ Help Required

Please see attached. It gets the result from an UDF so be sure to copy the function as well if you intend to use it in another file. HTH On Tue, Apr 26, 2016 at 4:22 PM, Neeraj Chauhan wrote: > Dear sir, > > > > I want all Indus id in one row with Comma > > > >

Re: $$Excel-Macros$$ Help for a logical formula

Thanks, Working On Tue, Apr 19, 2016 at 9:50 AM, Abhishek Jain wrote: > Check the attachment. > > If both cells do not have same value, the formula would return blank. > > > > On Tue, Apr 19, 2016 at 12:10 PM, Rajeev Kumar > wrote: > >> Yes, >> I

Re: $$Excel-Macros$$ Help for a logical formula

Check the attachment. If both cells do not have same value, the formula would return blank. On Tue, Apr 19, 2016 at 12:10 PM, Rajeev Kumar wrote: > Yes, > I need a formula that if in the any of column (A or B) value, should come > in Column C. > if in A10 Data

Re: $$Excel-Macros$$ Help for a logical formula

Yes, I need a formula that if in the any of column (A or B) value, should come in Column C. if in A10 Data available and B10 is empty then A10 value should come in C10 if in B10 Data available and A10 is empty then B10 value should come in C10 if in both A10 & B10, data will be available (but

Re: $$Excel-Macros$$ Help for a logical formula

Sorry I am unable to understand your query. If the value is same in Col A and Col B, your formula is correctly displaying in Col C. What exactly do you want? On Tue, Apr 19, 2016 at 11:15 AM, Rajeev Kumar wrote: > Dear Experts, > Please look in to the attached sheet and

Re: $$Excel-Macros$$ Help needed in Macro to send mails

Mr. Shot: :) I don't believe you're being "ignored".I suspect it's more along the lines of:"How much effort do I/we have to put into trying to figure out what it is you want to do and do I/we have the expertise to address it". Your messages are a "little" confusing. You've posted a question on

Re: $$Excel-Macros$$ Help needed in Macro to send mails

Hi Guys, Still waiting for some resolution in this group. Pls help. On Sat, Mar 26, 2016 at 12:46 AM, Secret Shot wrote: > Dear Experts, > > I want help in macro which can attach 4 mail with standard subject line > into one mail as an attachment and send that mail to a

Re: $$Excel-Macros$$ Help needed in Macro to send mails

Hi Guys, Cant anyone here help me pls. Does no one know OUTLOOK MACROS On Sat, Mar 26, 2016 at 12:46 AM, Secret Shot wrote: > Dear Experts, > > I want help in macro which can attach 4 mail with standard subject line > into one mail as an attachment and send that mail to a

Re: $$Excel-Macros$$ Help required to use GetConcat(A13) & macro using

Here, give this a try.It was a simple matter to have it select the text box after completing. The other problem was because basically, there are 16,384 columns in each row.When you add or delete the row, you're "changing" 16,384 cells. so, the macro is running 16,384 times! I added a line in

Re: $$Excel-Macros$$ Help required to use GetConcat(A13) & macro using

Respected Mr. Paul your idea of creating text box is really very nice .. But when i started using this i found two issues 1] When ever i change any cell -- crusor should automatically goes to that box only & not as normal as next cell or down ... 2] If i delete any raw or insert any raw

Re: $$Excel-Macros$$ Help required to use GetConcat(A13) & macro using

Thank you very much for explaining in details. God Bless you & all members of our wonderful groups. Excel can do so much wonders that we can not have think it before. On 3 March 2016 at 19:10, Paul Schreiner wrote: > I can make the changes, but you will still need to

Re: $$Excel-Macros$$ Help required to use GetConcat(A13) & macro using

I can make the changes, but you will still need to rely on others to make changes! I'll try to explain: Macros have "scope":That is: Macros (Subroutine or Function) are stored in VBA "Modules"There are several types of Modules.The most common are "Sheet" modules, "Standard" modules and "Form"

Re: $$Excel-Macros$$ Help building macro that takes data from entry form and fills out database

Easily done, provided you give us some details!  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$$ Help for macro

Dear Paul Thanks for reply. Cant get it. Can you please modify it for me and send it back Thanks in Advance Regards Shrinivas On Thu, Feb 4, 2016 at 6:16 PM, Paul Schreiner wrote: > In your macro, you CREATE the new workbook: > > Workbooks.Add >

Re: $$Excel-Macros$$ Help for macro

Change your macro to:Sub MyFilter()    Dim lngStart As Long, lngEnd As Long, thisWB As Workbook     Dim NewWB As Workbook         Set thisWB = ActiveWorkbook     '-     ' Create a new workbook     '-    

Re: $$Excel-Macros$$ Help for macro

Dear Paul Really great thanks for help. Regards Shrinivas On Fri, Feb 5, 2016 at 6:08 PM, Paul Schreiner wrote: > Change your macro to: > Sub MyFilter() > Dim lngStart As Long, lngEnd As Long, thisWB As Workbook > Dim NewWB As Workbook > > Set thisWB =

Re: $$Excel-Macros$$ Help for macro

In your macro, you CREATE the new workbook:     Workbooks.Add     ActiveWorkbook.SaveAs Filename:=thisWB.Path & "\filter.xls" But then you immediately CLOSE it!     ActiveWorkbook.Close savechanges:=False  So, then when you filter the data, copy it to the clipboard and select Sheet1,it's in the

Re: $$Excel-Macros$$ Help Required

PFA On Thu, Jan 14, 2016 at 3:56 PM, Neeraj Chauhan wrote: > Dear Experts. > > > > I want change Date Format > > -- > 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$$ Help Required

Thanks sir!! From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Saleem Ansari Sent: Thursday, January 14, 2016 4:05 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help Required PFA On Thu, Jan 14, 2016 at 3:56 PM, Neeraj Chauhan

Re: $$Excel-Macros$$ help on find the list matches to the cell part value

Thanks Pankaj and others. It works fine. Thanks a lot pankaj. Im going to apply in my base data if any concern kindly help... Thanks Regards, Ganesh N On Tue, Dec 22, 2015 at 9:37 PM, Pankaj Sharma wrote: > Dear Ganesh, > > I hope it should be ok. > > > Sub

RE: $$Excel-Macros$$ help on find the list matches to the cell part value

PFA. METABRAS Mihai Ghilea | Administrator retea T: +4(0) 268.407.410 | F: 0268.407.426 | M: 0728.994.113 A: Strada Grivitei A44, Cod postal RO500182 E: mihai.ghi...@metabras.ro W: 3W.METABRAS.RO

Re: $$Excel-Macros$$ help on find the list matches to the cell part value

check it ! *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p ankaj123...@gmail.com * *Skype** pankaj.sharma_pj* On Tue, Dec 22, 2015 at 5:07 PM, Ganesh N

Re: $$Excel-Macros$$ help on find the list matches to the cell part value

Dear Team, Thanks, But I not get the correct answer. I will say again in the column A I have the list of number. In column E I have some date. I want to check any one in the list (column A) is appearing in column E single cell. If cell E2 have the any number in Column A then i need the answer as

Re: $$Excel-Macros$$ help on find the list matches to the cell part value

Dear Ganesh, I hope it should be ok. Sub lookup_list() Dim wf As Object: Set wf = Application.WorksheetFunction Dim list As Range: Set list = Range("A1", Range("A" & Rows.Count).End(xlUp)) Dim v1 As Long, v2 As Long, r As Long, a As Long, b As Long On Error Resume Next For

Re: $$Excel-Macros$$ help required

See if this works On Sun, Nov 22, 2015 at 4:55 PM, Izhar wrote: > can we use vlookup or match,index function over here to sort column A like > column B, if possible can anyone do it for me, I tried on column E:I but > failed > Thanks in advance > NOTE: > Priority is the

Re: $$Excel-Macros$$ Help with Custom Vlookup

imes you can, To all the people you can, As long as ever you can.” - John Wesley - From: Mandeep Baluja <rockerna...@gmail.com> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> Cc: schreiner_p...@att.net; abhishek@gmail.com Sent: Friday, November 6, 20

Re: $$Excel-Macros$$ Help with Custom Vlookup

The speed of the worksheet is due to the fact that this UDF would execute for EACH row/cell where you've placed it.and update each time a sheet calculates(which occurs whenever you change a value) This function, run 50,000 times would indeed be slow! I'd suggest creating an alternative. Can I

Re: $$Excel-Macros$$ Help with Custom Vlookup

you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > -- > *From:* Abhishek Jain <abhishek@gmail.com> > *To:* Paul Schreiner <schreiner_p...@a

Re: $$Excel-Macros$$ Help with Custom Vlookup

gt;> >> *“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* >> --------- >> >> -- >> *From:* Abhishek Jain <abhish.

Re: $$Excel-Macros$$ help required to assign number value

Assuming that your values are stored in column A from cell 1 to 50, you could use this formula in cell B1 and drag it down - =RANK(A1,$A$1:$A$50) HTH Abhishek On Wed, Sep 9, 2015 at 2:22 PM, Nasir Saikh wrote: > Hi Experts, > > I need a formula to assign number value

Re: $$Excel-Macros$$ help required in petty cash transanction

AM Subject: Re: $$Excel-Macros$$ help required in petty cash transanction The formula you have sent is working but the problem over here is the date when i copy 02/06/2015 from another sheet and paste the same in TRANSANCTION sheet, then it is over write on the previous one. Now I'm sending 4

Re: $$Excel-Macros$$ help required in petty cash transanction

THANK YOU VERY MUCH FOR YOUR HELP On Saturday, 22 August 2015 10:16:25 UTC+5, GENIUS wrote: The formula you have sent is working but the problem over here is the date when i copy 02/06/2015 from another sheet and paste the same in TRANSANCTION sheet, then it is over write on the previous

Re: $$Excel-Macros$$ help required in petty cash transanction

The formula you have sent is working but the problem over here is the date when i copy 02/06/2015 from another sheet and paste the same in TRANSANCTION sheet, then it is over write on the previous one. Now I'm sending 4 days transanction to you just apply such a formula when i copy

Re: $$Excel-Macros$$ help required in petty cash transanction

What are the other sheet names for each day?They can't all be called  Transaction. Are you looking for a macro solution? or Excel formulas? the issue here is that for each ROW of data, you have to predict what the source transaction sheet name will be. For example, in Cell C4, you need the value

Re: $$Excel-Macros$$ HELP REQUIRED

In the autofilter panel,you are selecting cells that begin with M.In the next box,choose cells that do NOT begin with MN  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$$ HELP REQUIRED

THANK YOU VERY MUCH FOR YOUR HELP On Monday, 17 August 2015 16:43:38 UTC+5, Paul Schreiner wrote: In the autofilter panel, you are selecting cells that begin with M. In the next box, choose cells that do NOT begin with MN [image: Inline image] *Paul*

Re: $$Excel-Macros$$ Help with saveas file code

The user's My Documents folder is USUALLY set up in the C:\users\useridfolder. There's several ways of getting the login account name, but I think something like: MyDocsPath = Environ(USERPROFILE) \My Documents should give you the path to the user's My Documents folder. 

  1   2   3   4   5   6   7   8   9   10   >