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

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

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

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

Respected All Last time some brothers have help to make this file perfect I want some clarification / suggestion on this file I have approx more than 1000 entries to do in this file 1]When I start inserting lines & copy

$$Excel-Macros$$ Help Required

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

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

$$Excel-Macros$$ Help Required

Sir, I have an attached tamplete called advice, I want to make a data sheet each time I save a work book from the advice. Please help 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

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

$$Excel-Macros$$ help required

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 formula if not possible then you may use macro -- *Izhar Ul Haq* Cell# 009203069072597 -- Are

$$Excel-Macros$$ HELP REQUIRED

Is there any macro for searching a text inside the workbook if I have 100 workbook in a folder, I'm using windows 7 enterprise edition, this facility was available in XP but I dont know how to search in windows 7, let me clear I'm talking about inside the workbook not the name of the workbook

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

Hi Experts, I need a formula to assign number value example is given below where i need is if the value is max then assign 4, below that 3, below that 2, below that 1 Value 1000 1 100 10 required 43 1 2 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

$$Excel-Macros$$ Help Required

Dear Experts, I want total duration time DATETIME_UP DATETIME_DOWN Total Duration Required 9/1/2015 04:06.5 9/1/2015 05:04.1 HRS:MIN:SS -- 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 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

can.” - John Wesley* - -- *From:* Izhar izhar...@gmail.com *To:* excel-...@googlegroups.com *Sent:* Friday, August 21, 2015 7:14 AM *Subject:* $$Excel-Macros$$ help required in petty cash transanction in this workbook, I

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

izhar...@gmail.com javascript: *To:* excel-...@googlegroups.com javascript: *Sent:* Friday, August 21, 2015 7:14 AM *Subject:* $$Excel-Macros$$ help required in petty cash transanction in this workbook, I have two worksheets namely PETTY CASH SHEET and TRANSANCTION, I need a formula through

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

in this workbook, I have two worksheets namely PETTY CASH SHEET and TRANSANCTION, I need a formula through which I may be able to transfer amount from TRANSANCTION sheet to PETTY CASH SHEET in the date and respective accounts mentioned in the TRANSANCTION sheet, in this workbook I've provided only

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

: Friday, August 21, 2015 7:14 AM Subject: $$Excel-Macros$$ help required in petty cash transanction in this workbook, I have two worksheets namely PETTY CASH SHEET and TRANSANCTION, I need a formula through which I may be able to transfer amount from TRANSANCTION sheet to PETTY CASH SHEET

Re: $$Excel-Macros$$ HELP REQUIRED

, To all the people you can, As long as ever you can.” - John Wesley - From: Izhar izharra...@gmail.com To: excel-macros@googlegroups.com Sent: Saturday, August 15, 2015 1:36 AM Subject: $$Excel-Macros$$ HELP REQUIRED look at the sheet

Re: $$Excel-Macros$$ HELP REQUIRED

:* Izhar izhar...@gmail.com javascript: *To:* excel-...@googlegroups.com javascript: *Sent:* Saturday, August 15, 2015 1:36 AM *Subject:* $$Excel-Macros$$ HELP REQUIRED look at the sheet, in this sheet I want to search the article start with M with numbers not MN with numbers becoz when I try

$$Excel-Macros$$ HELP REQUIRED

look at the sheet, in this sheet I want to search the article start with M with numbers not MN with numbers becoz when I try to search M as picture has shwon in the sheet, it shows MN with number also but I need only M with Numbers after filtering I have also highlighted the ARTICLES please help

Re: $$Excel-Macros$$ Help Required

pls check On Wed, May 20, 2015 at 2:58 PM, Neeraj neerajchauhan...@gmail.com wrote: Dear Experts, Kindly find the sheet and do the needful formula -- 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 Required

Dear Experts, Kindly find the sheet and do the needful formula -- 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

$$Excel-Macros$$ Help required for MS- Access application.

Hi Experts, I want to split table from main table with their names available in column For example. I have a database in the database name available A,B,C,D,E only then the data for each should be make separate. Thanks in advance. Regards Nasir Shaikh -- Are you =EXP(E:RT) or

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

Dear Sir, My company has two shifts say Ist shift working =6:00 to 14:00 ans second shift 14:00 to 22:00 i have large data of employees (rotating shifts) and want to calculate which employee worked in which shift Excel is on that format EmployeeCode Shift

$$Excel-Macros$$ Help required for conslidate

Dear Experts, Kindly Help on urgent basis to get it resolve as below . suggest any formula to get the exact data as i required. reference sheet attached ​ I have data as below source 1 1 1 1 1 1 1 1 1 1 1 1 RAKESH A B C DMUKESH A B C D E GAURAV A B

Re: $$Excel-Macros$$ Help Required on Conditional Formating

Do let us know if you need any help.. Cheers!! On Sat, Mar 7, 2015 at 3:42 PM, Mukesh Gupta mukesh2k2...@gmail.com wrote: Thanks On 7 Mar 2015 14:46, Vaibhav Joshi v...@vabs.in wrote: Hi check this.. www.excelzoom.com/how-to-create-a-calendar-in-excel/ Cheers!! On Fri, Mar 6, 2015 at

Re: $$Excel-Macros$$ Help Required on Conditional Formating

Hi check this.. www.excelzoom.com/how-to-create-a-calendar-in-excel/ Cheers!! On Fri, Mar 6, 2015 at 8:02 AM, Mukesh Gupta mukesh2k2...@gmail.com wrote: Dear Friedns, Kindly help me in creating a conditional formating calander just like goole calander. My basis needs are as follows:-

Re: $$Excel-Macros$$ Help Required on Conditional Formating

Thanks On 7 Mar 2015 14:46, Vaibhav Joshi v...@vabs.in wrote: Hi check this.. www.excelzoom.com/how-to-create-a-calendar-in-excel/ Cheers!! On Fri, Mar 6, 2015 at 8:02 AM, Mukesh Gupta mukesh2k2...@gmail.com wrote: Dear Friedns, Kindly help me in creating a conditional formating

$$Excel-Macros$$ Help Required on Conditional Formating

Dear Friedns, Kindly help me in creating a conditional formating calander just like goole calander. My basis needs are as follows:- 1. Start Date 2. End Date 3. Days of Week( Could be Sunday to Monday any) 4. Start time of Class 5. End time of Class This could be for many teachers. Depending

$$Excel-Macros$$ Help required

Dear experts, I want to some of times as given below format 2/1/2015 2/21/2015 sum in Hours Like 11:39:49 9:42:15 9 hrs 30 Minute -- 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 - alternate sorting

Great..Cheers! On Sun, Feb 8, 2015 at 1:20 PM, singla.kris...@gmail.com singla.kris...@gmail.com wrote: Hi Vabz, Thank you very much That worked like wonder... Many 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

Re: $$Excel-Macros$$ Help required - alternate sorting

Hi Vabz, Thank you very much That worked like wonder... Many 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

Re: $$Excel-Macros$$ Help required - alternate sorting

Hi, check this file.. Put formula countif in next columncopy paste down, you can see there is Separate set of sequential numbering for Dr Cr. Once it is ok, copy paste value for formula column sort data AtoZ .. Cheers!! On Tue, Feb 3, 2015 at 5:25 PM, singla.kris...@gmail.com

Re: $$Excel-Macros$$ Help required - alternate sorting

Send with Excel file where you want to do this. Pramod On 3 Feb 2015 17:25, singla.kris...@gmail.com singla.kris...@gmail.com wrote: Hi, Can somebody please help me in a small macro. My sheet have a column with some values and I want to sort them alternately. Current Dr. Cr. Dr. Dr.

$$Excel-Macros$$ Help required - alternate sorting

Hi, Can somebody please help me in a small macro. My sheet have a column with some values and I want to sort them alternately. Current Dr. Cr. Dr. Dr. Cr. Cr. Cr. Dr. Required Dr. Cr. Dr. Cr. Dr. Cr. Dr. Cr. Thanks in advance Krishan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

$$Excel-Macros$$ Help Required on Dependent Data Validation

Hi, I need help on Dependent Data validation. and please try to solve it without adding any other column. -- Thanks £ Regards Rakesh Kumar +91-9650303464 # -- 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 on Dependent Data Validation

You can do so using macro..else you need to use dependent columns for data validation list. + *I did not do this for you. God is here working through me for you.* On Tue, Dec 30, 2014 at 2:48 PM, Rakesh kumar rakesh.apt...@gmail.com wrote: Hi, I need help on Dependent Data validation.

$$Excel-Macros$$ Help required for Match DATA

Dear Seniors, I have data in sheet 1 Name Class Roll NO. Exam Date and, I have data in Sheet 2 Name Class Roll No. Exam Date But some Names are not in Name Column and Some Class are not in Class Column, I want to get all Roll No. in Sheet 2 from Sheet 1. Example data attached.

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

Dear Seniors, Please help. how can i get data from sheet 1 Ashu Kenith On Wed, Dec 17, 2014 at 6:30 PM, Ashu k direct2as...@gmail.com wrote: Dear Seniors, I have data in sheet 1 Name Class Roll NO. Exam Date and, I have data in Sheet 2 Name Class Roll No. Exam Date But

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

Hi Check this..cell with yellow colour has formula. Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Dec 17, 2014 at 8:21 PM, Ashu k direct2as...@gmail.com wrote: Dear Seniors, Please help. how can i get data from sheet 1 Ashu Kenith On Wed,

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

Dear Sir, Thanks for your support. I dont want to get data in A and B column, I want to get data in C column only. Don't want to put formula in A and B column. It is possible. to get data from Sheet 1 without put any formula in A and B column in Sheet 2. pls help. Thanks Ashu Kenith On Wed,

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

Dear Sir, I have huge data, So i want only single formula. or can it done by vba help. Thanks Ashu Kenith On Wed, Dec 17, 2014 at 8:35 PM, Ashu k direct2as...@gmail.com wrote: Dear Sir, Thanks for your support. I dont want to get data in A and B column, I want to get data in C column

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

Yes, only if class no. is also unique the same way Name. Check this cell with blue color. Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Dec 17, 2014 at 8:35 PM, Ashu k direct2as...@gmail.com wrote: Dear Sir, Thanks for your support. I dont want

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

Dear Sir, I have some Blank cells in A column and Some Blank Cells in B Column in sheet 2. I want to match the C column data from Sheet 1. only single formula required. If we don't want to put any formula in A and B column but some cells are blank in both columns. It is possible. Thanks Ashu

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

Hi Ashu, Use Simple Vlookup function which is suggested by Vaibhav Sir. and Delete NA# with help of filter. It's simple. Regards Ashish -- 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 for Match DATA

Dear Sir, I want only single formula. I have some blank Cells in A and B column in sheet 2. Query is attached please check again. -- 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 for Match DATA

Hi Ashu, Check this!! Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread

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

Dear Vaibhav/Ashish Sir, Thanks for your help. I am looking for this only. Thanks Ashu Kenith On Wed, Dec 17, 2014 at 9:10 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Ashu, Check this!! Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

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

Welcome Ashu. -- 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, like Please Help,

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

Dear Sir, Can we do it by vba. please help. Thanks Ashu Kenith. On Wed, Dec 17, 2014 at 9:21 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Welcome Ashu. -- 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

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

*Subject:* Re: $$Excel-Macros$$ Help Required. There is no difference between Vlookup in Excel 2003 and Excel 2007 and above. Please elaborate what is the actual issue. On Mon, Nov 24, 2014 at 9:55 PM, sriram ji sriramg...@gmail.com wrote: Dear Excel Guru's, Is there any possible to vlookup

$$Excel-Macros$$ Help Required.

Dear Excel Guru's, Is there any possible to vlookup in 2003 excel to 2007 excel or above.. If possible please provide the excel vlookup formula. Thanks in advance. Sriram G(chennai) -- 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 Required.

There is no difference between Vlookup in Excel 2003 and Excel 2007 and above. Please elaborate what is the actual issue. On Mon, Nov 24, 2014 at 9:55 PM, sriram ji sriramg...@gmail.com wrote: Dear Excel Guru's, Is there any possible to vlookup in 2003 excel to 2007 excel or above.. If

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

Dear Excel guru's, I have 4 Data in 2003 excel format. I want to vlookup in 10 data, its 2007 excel format... Am trying to vlookup in 2003 to 2007 excel format the below attached error is came. Please solve the error... [image: Inline image 1] Thanks Regards Sriram G On Mon, Nov 24,

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

:28 AM Subject: Re: $$Excel-Macros$$ Help Required. There is no difference between Vlookup in Excel 2003 and Excel 2007 and above. Please elaborate what is the actual issue. On Mon, Nov 24, 2014 at 9:55 PM, sriram ji sriramg...@gmail.com wrote: Dear Excel Guru's, Is there any possible

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

you can.” - John Wesley - From: sriram ji sriramg...@gmail.com To: excel-macros@googlegroups.com Sent: Monday, November 24, 2014 11:42 AM Subject: Re: $$Excel-Macros$$ Help Required. Dear Excel guru's, I have 4

Re: $$Excel-Macros$$ Help Required in MS Access(Urgent)

Please try these query. Query1. SELECT Table1.Name, Table2.NAme FROM Table1 INNER JOIN Table2 ON cstr(Table1.Name) = cstr(left(Table2.NAme,len(Table1.Name))); query2. UPDATE Table1 INNER JOIN Query1 ON Table1.Name = Query1.Table1.NAme SET Table1.Name = [Query1].[Table2]![NAme] WHERE ((Not

Re: $$Excel-Macros$$ Help required for changing the file name in a query programmatically

Mr Basole, Thanks for the attachements, I am getting an error msg as in the attachment, even after adding Ms-ado object library. [image: Inline image 1] TIA. Eugene On Fri, Aug 29, 2014 at 11:06 PM, Ricardo® ricardo...@gmail.com wrote: Ok, is attached files. To test, hold the 2 files in

Re: $$Excel-Macros$$ Help required for changing the file name in a query programmatically

Dear Basole, Please ignore my earlier mail, I removed the slash in between dd/mm from the below statement from your example fileXLS = T Replace(Format(Date, dd/mm), /, ) .xls like below, fileXLS = T Replace(Format(Date, ddmm), /, ) .xls and example sent by you started working. Thank you

Re: $$Excel-Macros$$ Help required for changing the file name in a query programmatically

Was precisely the error: problem with the file name. * xls. To work well, every day change the name, for example: 31/08/2014 and rename to (T3108.xls). Then do the test with your file. If you have any problems, please send me an example of your file (Tddmm.xls). Regards, Basole. 2014-08-30

Re: $$Excel-Macros$$ Help required for changing the file name in a query programmatically

At A7 sheet Homepage, select Office. GET FILE button to select the file and get into 2014-08-30 22:10 GMT+07:00 Eugene Bernard eugene.bern...@gmail.com: Mr Basole, Thanks for the attachements, I am getting an error msg as in the attachment, even after adding Ms-ado object library.

Re: $$Excel-Macros$$ Help required for changing the file name in a query programmatically

Basole, Thanks for your solution. Can you please send me the working example along with excel file with sample data. I tried your code with my data, and i am getting an error message. Regards Eugene On Saturday, August 23, 2014 7:04:59 PM UTC+5:30, Basole wrote: Hi, See this example

Re: $$Excel-Macros$$ Help required for changing the file name in a query programmatically

Ok, is attached files. To test, hold the 2 files in the same folder Regards, Basole. 2014-08-29 11:58 GMT-03:00 Eugene Bernard eugene.bern...@gmail.com: Basole, Thanks for your solution. Can you please send me the working example along with excel file with sample data. I tried your

$$Excel-Macros$$ Help required for changing the file name in a query programmatically

Dear all, I am daily using the attached sample query file to extract data from an excel file stored in my windows desktop. I am pasting below a part of code from the test.dqy file, where I am daily changing the file name based on the date on which it is being run. Instead of changing it

  1   2   3   4   >