Re: $$Excel-Macros$$ Macro for Ageing of Inventory

Mr.C.G.Kumar See attached file as your require function. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Dec 22, 2014 at 9:44 AM, C.G.Kumar wrote: > Hi, > > I have purchase

Re: $$Excel-Macros$$ cells.find

Hi Ashakala, PFA 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 titles, like

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

Vaibhav Bhai, Superb..!! 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$$ cells.find

Hi ashakala, you want to find specific word in sheet. On 19 December 2014 at 20:40, wrote: > > > Can anyone help me with below code, > > Dim range1 As Range > > range1 = Cells.Find(what:="range") > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's > =TIME(2,DO:I

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

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

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$$ pdf file rename

Welcome Chintan -- 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, Urgen

Re: $$Excel-Macros$$ pdf file rename

Thanks Vaibhav Bhai. On 16 December 2014 at 22:42, Vaibhav Joshi wrote: > Good one ashish!! > > + > *I did not do this for you. God is here working through me for you.* > > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,

Re: $$Excel-Macros$$ pdf file rename

Hi Chintan, PFA 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 titles, like

Re: $$Excel-Macros$$ Distribute numbers to names

Vaibhav Bhai, SUperb Solution. 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

Re: $$Excel-Macros$$ Put Text Strings from Excel file to Outlook calander

Working Superb. WoW 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 titles

Re: $$Excel-Macros$$ Date query for conditional format

Hi Ashish, PFA 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 titles, like

Re: $$Excel-Macros$$ Array_concept

Hi Sam, Long Time Bro. Welcome Back...!! :) Regards Ashish On 13 December 2014 at 18:32, Sam Mathai Chacko wrote: > Mandeep, > > > It's not like that. For that you'll need to understand how Transpose > works. Try this first ;) > > ARR = Application.Tr

$$Excel-Macros$$ Date query for conditional format

Dear experts, I have series of date in which only sunday should be highlighted, please see attached file for example. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or =NOT(EXP

Re: $$Excel-Macros$$ Discussion

Hi Mandeep, Activate method works only on a single Cell, which much be inside the current selection and brings the cursor in that Cell. And, With the help of select method you can select any range, but does not let you define which cell has the cursor. Regards Ashish -- Are you =EXP(E:RT) or

$$Excel-Macros$$ need function to get data on exact match

Dear experts, I need function to receive data on fulfill particular cell data, the demo is attached herewith, thanks in advance. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ How to protect only few cells

Welcome Putta. -- 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, Urgent

Re: $$Excel-Macros$$ How to protect only few cells

button in the Changes group under Review tab. Step 8: In the Protect Sheet dialog box, enter a password in the blank box under Password to unprotect sheet. Step 9: Confirm Password dialog box pops up, please reenter the password again. Step 10: Click OK. Regards Ashish -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ move or copy define name range one sheet to another sheet vba code

Hi Amar, PFA Change the Data Range according to your requirement. Don't paste the data in this Sheet. If you want to Copy range from AAA sheet to BBB, then Paste your Data in AAA and Save it on Desktop and Create a blank Sheet on Desktop named BBB. Regards Ashish -- Are you =EXP(E:R

Re: $$Excel-Macros$$ move or copy define name range one sheet to another sheet vba code

Hi Amar, If it's not useful then share your requirement sheet with required output. 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

Re: $$Excel-Macros$$ move or copy define name range one sheet to another sheet vba code

Hi Amar, Check this :- SubJect - Copy paste data from one sheet to another based on click Query Raised in Group - 28th Nov, 2014. Status - Resolved. 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

Re: $$Excel-Macros$$ Querry production analysis

Hi Vaibhav Bhai, It's Simple and Superb Solution. 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 t

Re: $$Excel-Macros$$ row data copy to next sheet

Hi Vaibhav Bhai, It's Working Superb. 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.

Re: $$Excel-Macros$$ Copy paste data from one sheet to another based on click

Hi Vaibhav Bhai, It's working fine. Actually, I didn't recognize and understand the query properly. It's my mistake :) Regards Ashish On 29 November 2014 at 15:04, Vaibhav Joshi wrote: > hi > > chek this... > > Cheers!! > > + > *I did not do this

Re: $$Excel-Macros$$ Copy paste data from one sheet to another based on click

Hi Joseph, PFA 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 titles, like

Re: $$Excel-Macros$$ Copy paste data from one sheet to another based on click

Hi Joseph, PFA 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 titles, like

Re: $$Excel-Macros$$ Changing value to percentage

Hi Mandeep, If your Data in Cell A1 then put the formula in B1. This is concatenate function. Try it...!! 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

Re: $$Excel-Macros$$ Changing value to percentage

Dear Mandeep, Are you trying this formula. 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

Re: $$Excel-Macros$$ Changing value to percentage

Hi Chandra Shekar, Use this formula : =A1& "%" 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, a

Re: $$Excel-Macros$$ Need Help

Hi Chandru, PFA Regards Ashish On 24 November 2014 at 11:57, Chandru wrote: > I need Excel formula or VBA for the following. >*) To set cell width(for headers). >*) To make hyper link text blue. >*) Font Formatting(for headers). > > Regards, > Chandru >

Re: $$Excel-Macros$$ Help needed

Hi Ravinder, PFA Regards Ashish On Sun Nov 16 2014 at 5:10:24 PM Ravinder Kumar < ravinderbhardwa...@gmail.com> wrote: > Hi All, > > Please help me in the attached data, please share also the way to resolve > it. > > Regards, > Ravindra > > -- > Are you =E

Re: $$Excel-Macros$$ Re: Need macro to copy date from excel file to another excel file

Hi Yudy, Share your data with example. Regards Ashish On Sun Nov 16 2014 at 3:37:04 PM wrote: > Hello , > > Can anyone please help me with a solution > > .Yudy > > On Friday, November 14, 2014 11:31:53 PM UTC+5:30, yudy...@gmail.com > wrote: >> >> He

Re: $$Excel-Macros$$ Re: Fix the Shape

Hi Vaibhav Bhai, It's GREAT!!! Fantastic :) 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, acc

Re: $$Excel-Macros$$ Fix the Shape

Welcome Eugene. 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 titles, like

Re: $$Excel-Macros$$ Fix the Shape

Hi Eugene, PFA...! Use down arrow key to scroll down the sheet. Shape will appear on the top always. 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

Re: $$Excel-Macros$$ To create a sheet with macro and overwrite on next attempt

Hi Pravin, PFA!! Edit your data in Pending CN and Highlight the row which you want to paste in Party Wise and hit the macro. 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$$ Need help on data validation: List

Welcome Sharath. 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 titles, like

Re: $$Excel-Macros$$ To create a sheet with macro and overwrite on next attempt

Hi Pravin, PFA.!! 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 titles

Re: $$Excel-Macros$$ Need help on data validation: List

Hi Sharath, PFA..! Change your data in A1. If you select Global in A1 then drop down list will show in B1 and If you select Local in A1 then drop down list will be deleted in B1. you are able to write anything in B1 Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

Re: $$Excel-Macros$$ Macro for word & phrase recongnition & count of them

Hi Amit Sir, PFA. Don't delete the formula which was in C column and F Column. Enter your Data in E Column and drag the formula. 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

Re: $$Excel-Macros$$ Fix the Shape

Hi Eugene, For fix the shape in one position. Left Click on the shape Click on Format Shape Click on Properties Click on "Dont Move or Size with Cell" OK Regards Ashish On 13 November 2014 16:38, Eugene Bernard wrote: > Hi all, > > FInd attached an excel sheet, where in

Re: $$Excel-Macros$$ Macro for word & phrase recongnition & count of them

Hi Amit Sir, PFA. Don't delete the formula which was in C column and F Column. Enter your Data in E Column and drag the formula. 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

Re: $$Excel-Macros$$ Macro for word & phrase recongnition & count of them

Thanks Vaibhav Bhai -- 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, U

Re: $$Excel-Macros$$ Macro for word & phrase recongnition & count of them

Hi Amit Sir, Pls check, can it helps. 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

Re: $$Excel-Macros$$ Issue with: Open Sheet, Copy Sheet, Close Sheet, Retain Clipboard, Paste

Welcome Bud. 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 titles, like

Re: $$Excel-Macros$$ Issue with: Open Sheet, Copy Sheet, Close Sheet, Retain Clipboard, Paste

Hi Bud, PFA!! Do changes in macro according to your requirement in Set x and Set y. 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

Re: $$Excel-Macros$$ Please solve this sheet its very urgent

Hi Vaibhav Bhai, It's great. -- 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 Pleas

Re: $$Excel-Macros$$ VLOOKUP QUEARY

Thanks Mandeep. -- 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, Urgen

Re: $$Excel-Macros$$ VLOOKUP QUEARY

Hi Saleem, PFA 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 titles, like

Re: $$Excel-Macros$$ How to highlight duplicate data

Welcome. -- 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, Urgent, Need

Re: $$Excel-Macros$$ How to highlight duplicate 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 titles

Re: $$Excel-Macros$$ how to copy a text from a cell into several rows

Hi Vaibhav Bhai, It's perfect. 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.

Re: $$Excel-Macros$$ Userform - Login

Hi, Try this UserName & password. UserID - 123456 Password - secret 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)

Re: $$Excel-Macros$$ Automatic update excel file from website

Hi Vaibhav Bhai, Working according to the requirement. Great!!! -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread

Re: $$Excel-Macros$$ Automatic update excel file from website

Hi Vaibhav Bhai, It's great.!! 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.

Re: $$Excel-Macros$$ Compile data from specific sheet of many files in one folder

Dear Amit Sir, Try It. 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 titles

Re: $$Excel-Macros$$ Compile data from specific sheet of many files in one folder

Hi Amit Sir, HW r u. How many sheets you have in folder..? Approx. Revert awaited. 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

Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

Hi Vaibhav Bhai, Sheet is working fine. Superb! 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

Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

Hi Nilkanth, PFA 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 titles,

Re: $$Excel-Macros$$ Pasting Data from Different Files in One Worksheet

Thanks Vaibhav Bhai. -- 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$$ Pasting Data from Different Files in One Worksheet

HI, PFA.!! 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 titles,

Re: $$Excel-Macros$$ Pasting Data from Different Files in One Worksheet

Hi, You want to combine all files in 1 sheet. Revert awaited. Regards Ashish On 18 October 2014 18:59, Hasnain Raja wrote: > Hi All, > > I am getting different files from different customers (in same format) and > saving it in a folder. Now to combine all the data, I am tryin

Re: $$Excel-Macros$$ Report

Hi Vaibhav Bhai, Nice Solution. Sheet is working Great. 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, acc

Re: $$Excel-Macros$$ Job Opening for MIS profile.

Hi Guys, 3 more openings we have for this profile. Interested Candidates please send your resume Asap. Regards Ashish On 8 October 2014 09:50, Ashish Kumar wrote: > Hi Friends > > We have 2 Openings for MIS profile. > > Experience - 1 to 2 Yrs > Salary - 10 K (Take Home) + E

$$Excel-Macros$$ Job Opening for MIS profile.

Candidates please send your resumes. 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 t

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

Welcome Chandru. 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 titles,

Re: $$Excel-Macros$$ What seems to be a basic formula BUT I cant figure it out! Help,,,,Please

Welcome!!! -- 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, Urgent

Re: $$Excel-Macros$$ Report

Hi Vaibhav Bhai, It's superb. 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. P

Re: $$Excel-Macros$$ What seems to be a basic formula BUT I cant figure it out! Help,,,,Please

Hi Faye, You want to highlight the Cells of Sheet 1 Column D, if the same values are lying in Sheet 2 in Column B. PFA.!!! 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$$ Applying Date Filters using VBA

Hi Nitin, PFA.! 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 t

Re: $$Excel-Macros$$ Fwd: FILTER REQUIREMENTS -- Colour of Filter should catch our eyes. -- It may help more persons.

Hi, Check this. Filter data, any 1 column then don't remove the Filter, thenafter filter 2nd Column then filter 3rd Column. It will be change header color for each column. Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,

Re: $$Excel-Macros$$ Fwd: FILTER REQUIREMENTS -- Colour of Filter should catch our eyes. -- It may help more persons.

Ok friend call me. -- 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, Ur

Re: $$Excel-Macros$$ Fwd: FILTER REQUIREMENTS -- Colour of Filter should catch our eyes. -- It may help more persons.

Hi, So, you want to filter your data according to rows not columns...!! 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

Re: $$Excel-Macros$$ Fwd: FILTER REQUIREMENTS -- Colour of Filter should catch our eyes. -- It may help more persons.

Hi, PFA!! Sort and filter your data from (Row). {3.00}, {4.00}, {5.00} .!! 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

Re: $$Excel-Macros$$ Fwd: FILTER REQUIREMENTS -- Colour of Filter should catch our eyes. -- It may help more persons.

Hi, Use custom sort function for 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 t

Re: FW: $$Excel-Macros$$ Help needed for 2 Layered Bar Chart

call me On 24 September 2014 21:35, Amit Desai (MERU) wrote: > Dear Ashish, > > > > Thanks a lot for your help...however request you to please explain me how > you did this? > > > > Regards, > > *Amit Desai* > > *From:* excel-macros@googlegroups.co

Re: FW: $$Excel-Macros$$ Help needed for 2 Layered Bar Chart

Hi, Check this!! Final shot from my side. 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 t

Re: $$Excel-Macros$$ Help needed for 2 Layered Bar Chart

Hi, Check this one! 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 t

Re: $$Excel-Macros$$ Help needed for 2 Layered Bar Chart

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

Re: $$Excel-Macros$$ Help needed for 2 Layered Bar Chart

Hi Amit, PFA..!!! Regards Ashish Kumar On 24 September 2014 16:22, Amit Desai (MERU) wrote: > Dear All, > > > > I would like to have a layered chart for 3 cities...So for each city there > should be 3 main bars. These each Bar has to have 2 sub bars in side it

Re: $$Excel-Macros$$ Re: Macro Stop start (pause) Timer

Vaibhav Bhai, It's superb and unique creation. -- 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 t

Re: $$Excel-Macros$$ Need help to copy data from excel to notepad (Retain carriage return characters and delete non printable characters)

Hi Vaibhav Bhai, It's working superb. 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 thr

Re: $$Excel-Macros$$ Track the system Lock

. 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 titles, like Please Help, U

Re: $$Excel-Macros$$ hi all

Hi Sunil, PFA.!! 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 t

Re: $$Excel-Macros$$ need macro add Rows

Thank you very much Mr.Vaibhav, ones again u do a marvelous job for me. I also learn new things from your code. Cheers :) Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Sep 15, 2014 at 1:52 PM

$$Excel-Macros$$ need macro add Rows

under last series i.e. last series 10, then insert new 5 rows after 10 with writing series 11,12,13,14,15. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

Re: $$Excel-Macros$$ Unique values based on two conditions

Vaibhav Bhai, Its superb. Regards Ashish On 12 September 2014 15:38, Vaibhav Joshi wrote: > Chek this.. > > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > On Fri, Sep 12, 2014 at 2:34 PM, Chandra Shekar < > chand

$$Excel-Macros$$ Date in concatenate function

Dear experts, I am using Concatinate function to merge different text but date field not shown as a date in function. Kindly suggest require changes to merge text and date. See the attached file. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely

Re: $$Excel-Macros$$ VBA Code For Data Compiler

Hi Satender, Share your data with example. 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 t

Re: $$Excel-Macros$$ Re: Invitation to the Excel Modeling World Championships 2014

Hi Saleem, Check the information link which is provided by Vaibhav Sir. Hope you find your answer. 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.faceboo

Re: $$Excel-Macros$$ Folder data to wbk

Hi Vaibhav Bhai, Its Classic, Superb!! 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 t

Re: $$Excel-Macros$$ Folder data to wbk

Hi, you want to copy all data from folder into 1 Sheet. (Header Wise) Explain more your query. 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.faceboo

Re: $$Excel-Macros$$ Blank Cell Issue

Press OK - Press Ctrl with (-) minus sign. - Select Shift Cells UP - OK 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 RUL

Re: $$Excel-Macros$$ Auto filter issue

Vaibhav Bhai, Superb solutions according to the requirement. Regards Ashish On 4 September 2014 15:57, Vaibhav Joshi wrote: > cheers!! > > > On Thu, Sep 4, 2014 at 3:43 PM, Sunil Kumar Yadav > wrote: > >> yeah :-), it is absolutely working as per my requirement.

Re: $$Excel-Macros$$ Highlighted rows will be copy and paste in Sheet 2

Hi Ashu, PFA, 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 titles,

Re: $$Excel-Macros$$ Need Help - Show (-) Value

Thanks Vaibhav Bro. -- 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, U

Re: $$Excel-Macros$$ Need Help - Show (-) Value

Welcome Ashu. 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 titles,

Re: $$Excel-Macros$$ Need Help - Show (-) Value

Hi Ashu, PFA.!!! 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 t

Re: $$Excel-Macros$$ Transpose data

Hi Vaibhav, Macro sheet or Formula sheet both are working fine. Great work bro...!!! 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

<    1   2   3   4   5   6   7   8   9   10   >