$$Excel-Macros$$ Help with macro code: copy and rename template from a list

In search of a solution using a macro I would like to copy the 'active sheet' and rename each sheet created from a list on a hidden sheet in the file. The list changes based on which 'class' is selected from the list on the active sheet. I have a sheet1 "student" = activesheet

$$Excel-Macros$$ Help with macro code: copy and rename template from a list

In search of a solution using a macro I would like to copy the 'active sheet' and rename each sheet created from a list on a hidden sheet in the file. The list changes based on which 'class' is selected from the list on the active sheet. I have a sheet1 "student" = activesheet

$$Excel-Macros$$ Help Required

Dear expert, Kindly help *Site Id* *Site Name* *Days* 10-Jun-20 11-Jun-20 12-Jun-20 13-Jun-20 14-Jun-20 15-Jun-20 16-Jun-20 17-Jun-20 18-Jun-20 SUM SUM IN-1231470 *Jasar* 2 10.1 7.3 8.4 7.2 10.8 11.8 9.1 6.5 9.4 I want SUM accordingly to Column C, if there are 2

$$Excel-Macros$$ help with add-in

Hey guys, Bear with me if this is not the correct group where to send this question. I'm just hoping with the ammount of activity this group has I'd be at least be redirected to the correct place, if this is not. I'm writing an Excel add-in (in good old C, using COM), and I always find that a

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

$$Excel-Macros$$ Help Required

Dear Expert, I want to change the date format as per given below Date Date Want in this format 9/26/2018 Nov-18 -- 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 @

$$Excel-Macros$$ Help MS Excel

Hello, I would like to know if excel can sum all the numbers inside one single cell. Like: Cell A1 is : 3.123,5 so the sum of these numbers are 3+1+2+3+5=*14* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this

$$Excel-Macros$$ help++ 1８８８ 6785401 AT Number AT CALL CONTACT NUMBER AT nUMBER AT s

help++ 1８８８ 6785401 AT Number AT CALL CONTACT NUMBER AT nUMBER AT service help++ 1８８８ 6785401 AT Number AT CALL CONTACT NUMBER AT nUMBER AT service help++ 1８８８ 6785401 AT Number AT CALL CONTACT NUMBER AT nUMBER AT service help++ 1８８８ 6785401 AT Number AT CALL CONTACT NUMBER AT nUMBER AT

$$Excel-Macros$$ Help Required

Dear Experts, As per Given detail how can I convert each Site ID in Row separate row VehicleNo SitesId I Want this UP23T1457 IN-1035632,IN-1035940,IN-1035968,IN-1075463,IN-1075466,IN-1081661,IN-1112678 ,IN-1116387 IN-1000446 UP23T1457

$$Excel-Macros$$ Help Required on VE Project

Dear Expert, Urgent help required on VE Project. I want to send multiple mail with attachment on click Getting Error on below given code or attached excel Sub Send_email_fromexcel() Dim edress As String Dim subj As String Dim message As String Dim filename As String Dim outlookapp As Object Dim

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

$$Excel-Macros$$ Help with replacing formula with value over large range

Hi Can someone please explain why this macro does not work I have no formal training in VB or any programming so everything in the macro is bits taken from various posts What I need to do is put 1 or 0 over a range that starts at B8 and ends at the last column with data at row 44652 but if I

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

$$Excel-Macros$$ Help on Week Formula

Hello Team, Could you please help me in attached week formula. Regards, Chandru -- 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 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

$$Excel-Macros$$ Help required in excel

Hi Friends, I want to help in Excel ramu Ramu False Raju Raju True mohan Mohan False Venu VenuTrue SAISai False I first cell and second cell there will be data, please bring me a formulae that says the True and False data based on the

$$Excel-Macros$$ Help Help

Dear Excerpt, When i drag below Formula than like range A1:A25 than some no showing duplicate. I want to only unique no when i drag the below formula =Randbetween(1,100) Regards Vinay Panchal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW)

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

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

I need to solve a problem and I need help with the IF:THEN:ELSE calculation please. I need to create a spreadsheet where this is the model and calculate costs. IF(TRANSACTION) IS MORE THAN $50, AND UNDER 100 TRANSACTIONS TOTAL, BILLING RATE IS .005 IF(TRANSACTION) IS LESS THAN $50, AND

$$Excel-Macros$$ Help Required

Dear Excel Guru, I need help how to find out the list of name male or female, If Male adding infront of name (MR), If Female adding infront of name (Mrs). Please find attached the file for your reference. Kindly resolve the problem. Thanks in Advance. Thanks & Regards, Sriram G -- Are you

$$Excel-Macros$$ HELP - Access 2013 data export to Excel

Hi, I need your help how to set the heading after exporting data to excel template with heading. I have the data populate to excel without heading. can you help ? Here is the code below: With ExportTables Do While Not .EOF strQueryName = ExportTables("Query")

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

$$Excel-Macros$$ Help Required

Hi Excel Guru, Kindly help me the below attached file, Thanks in advance. Thanks & Regards, Sriram G -- 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

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

September 6, 2011 9:00 PM > *Subject:* $$Excel-Macros$$ Help in IF Function > > Hi All, > > Please help me to put the IF function for the below table. If the table > value is 0 the product should not be there > > Attached the file for u r reference > > Tech OFM Apps Sy

$$Excel-Macros$$ Help on Index and Match

Folks, Can you please help me in using index and match in the attached sheet to use to calculate distance between the cities ? regards raj -- 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 @

$$Excel-Macros$$ HELP HELP!!! Error 76 when running a Macro!!! time matters

Hello, I am receiving the error 76 when running a macro here some of the script Sub All() Sheets("Dictionary").Select Range("B2:B150").Select Selection.Copy Sheets("Macro").Select Range("E11").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone _ ,

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. 

$$Excel-Macros$$ Help Needed on Index

Dear All, Attached file has a small exercise done on INDEX function , Presently cells C21 to C29 has numbers, Instead of that how can I replace those cells with the names of the cities given in the table and continue using INDEX function ? Do I need to do this with a macro ? Note this is part of

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

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

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 case 462) using Column E in this example, and I'd like to select the Range from Column A to Column M with that row

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

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

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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor

$$Excel-Macros$$ help requrried for earlier email

Respected friends I have send two emails -- Yesterday one & today one kindly reply & give me the solution which is possible . Hope to receive your fast reply -- 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

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

$$Excel-Macros$$ $$Help Required$$

Dear Experts, Kindly find the attached sheet I want reduce or addition amount against particular Indus id and date wise. Kindly give me solution -- 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 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

$$Excel-Macros$$ Help on Vlookup

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 official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES

Fwd: $$Excel-Macros$$ Help !

Dear ALL, Anybody can help me ! Regards, IQbal -- Forwarded message -- From: Shaikh Iqbal <iqbal.hp...@gmail.com> 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 corr

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

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

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 see the attach file. Regards, Rabin -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

$$Excel-Macros$$ Help !

Hi, Export Pls find attached a file and pls do the correction in formula. Thanks Iqbal -- 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

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

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

Got your email address from discussion excel website, If you could help me to establish formula in the attached excel sheet. I have mentioned the data available format and the required format by utilizing the available data. IMPORTANT NOTE: I have to work multiple times on the data, therefore if

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

$$Excel-Macros$$ Help Required

Dear sir, I want all Indus id in one row with Comma INDUS ID INDUS ID IN-1000333 IN-1000333,IN-1034694,IN-1036098, IN-1075473, IN-1080707 IN-1034694 IN-1036098 IN-1075473 IN-1080707 IN-1107890 IN-1109310 IN-1237655 IN-1263842 IN-1276207

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

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

Dear Experts, Please look in to the attached sheet and please tell me formula for column C. Details in sheet 1 -- Rajeev 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 @

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

  1   2   3   4   5   6   7   8   9   10   >