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

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

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

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 eugene.bern...@gmail.com wrote: Hi all, FInd attached an excel sheet, where in i

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

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

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

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,

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

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

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

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

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

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

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

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 mhr...@gmail.com 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 trying to

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

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

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

Hi Friends We have 2 Openings for MIS profile. Experience - 1 to 2 Yrs Salary - 10 K (Take Home) + ESI + PF + Gratuity Job Location - Gurgaon. Freshers are Welcome but have Good Hands on Excel. 1 Vacancy is for Gurgaon and 1 for Mundka (New Delhi). [Peeragarhi - Rohtak Road] Interested

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 kumar.ashish...@gmail.com wrote: Hi Friends We have 2 Openings for MIS profile. Experience - 1 to 2 Yrs Salary - 10 K (Take Home

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

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,

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. Poor thread

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

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

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,

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,DO:IT,N:OW) !

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) amit.de...@merucabs.com 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

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

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

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 thread

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

@googlegroups.com] *On Behalf Of *Ashish Kumar *Sent:* Wednesday, September 24, 2014 8:11 PM *To:* excel-macros@googlegroups.com *Subject:* 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

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

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 FORUM

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 thread titles.

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

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

Hi Ganesh, For Enable or Disable Ctrl+Alt+Del function. Press Window button and Write Group Policy and press Enter for Search. Click on User Configuration then Click on Administrative Templates then after Click on System then after Click on Ctrl+Del Option. Choose setting as per your need.

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

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

Vaibhav Bhai, Its superb. Regards Ashish On 12 September 2014 15:38, Vaibhav Joshi v...@vabs.in 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 chandrashekarb@gmail.com wrote:

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

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 @

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 @

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 thread

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

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

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

Hi LJ, Follow the below mentioned simple steps to pull up the values of Column G. - Select the data G2 to G1048576 (mean to say: select the G column data from G2 to till last the column, Don't select G1 to G1048576) - Press F5 - Click on Special button - Select Blanks - Press

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

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

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

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,

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 FORUM

RE: $$Excel-Macros$$ Transpose data

What kind of output you want….! From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rupesh Patil Sent: Saturday, August 30, 2014 3:08 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Transpose data Dear Expert, I need one micro or

Re: $$Excel-Macros$$ Transpose data

Hi Vaibhav, Bro its 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$$ kindly UNLOCK MY EXCEL FILE

Please Read Rule (3) Don't Post question's regarding breaking or bypassing any security measures. On 22 August 2014 16:15, jayendra gaurav jayendra.gau...@gmail.com wrote: TEAM, I have forgotten my password.kindly unlock the same . its very urgent . -- J.Gaurav Call-7838594954 --

Re: $$Excel-Macros$$ EXCEL TO OUTLOOK

Hi Chintan, You want only paste table in mail body which is in Sheet 2. Regards Ashish On 22 August 2014 16:21, chintz rajanichintan...@gmail.com wrote: Hello sir, Please could any one help me to resolve this problem. In Excel 2 sheets and there are two different table (with one or two

Re: $$Excel-Macros$$ EXCEL TO OUTLOOK

reply. On Fri, Aug 22, 2014 at 4:30 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Chintan, You want only paste table in mail body which is in Sheet 2. Regards Ashish On 22 August 2014 16:21, chintz rajanichintan...@gmail.com wrote: Hello sir, Please could any one help me

Re: $$Excel-Macros$$ EXCEL TO OUTLOOK

Hi Chintan, PFA..!!! Regards Ashish On 22 August 2014 16:42, Ashish Kumar kumar.ashish...@gmail.com wrote: what subject you want to write. On 22 August 2014 16:37, Chintan Rajani rajanichintan...@gmail.com wrote: Yes, i have to paste 2 tables start from both sheets 1) and 2

Re: $$Excel-Macros$$ EXCEL TO OUTLOOK

Rajani rajanichintan...@gmail.com wrote: Thank you very much code is working but when i have to paste 2nd table from sheet number 2 .. after that its not working.. sorry for trouble. On Fri, Aug 22, 2014 at 5:10 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Chintan, PFA

Re: $$Excel-Macros$$ EXCEL TO OUTLOOK

Hi Rajni, Pfa according to your requirement. Regards Ashish Kumar On 22 August 2014 17:29, Chintan Rajani rajanichintan...@gmail.com wrote: Ok.. Thank you very much.. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official

Re: $$Excel-Macros$$ EXCEL TO OUTLOOK

Thanks Sir. On 22 August 2014 18:00, Vaibhav Joshi v...@vabs.in wrote: Bros its Super!! Cheers!! On Fri, Aug 22, 2014 at 5:37 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Rajni, Pfa according to your requirement. Regards Ashish Kumar On 22 August 2014 17:29, Chintan

Re: Re: $$Excel-Macros$$ I need VBA code to copy the cell value and paste in comment box for the same cell.

Vaibhav Bro, Superb!!! On 20 August 2014 12:12, Vaibhav Joshi v...@vabs.in wrote: FA Cheers!! On Wed, Aug 20, 2014 at 8:03 AM, Pankaj Kumar pankaj...@gmail.com wrote: Hello Ashish and Vaibhav, You guys are genius. Thanks a lot for modified code. However, it seems. It still has

Re: Re: $$Excel-Macros$$ I need VBA code to copy the cell value and paste in comment box for the same cell.

Thanks Pankaj, but Full Credit goes to Vaibhav Sir. He is Genius. Regards Ashish On 21 August 2014 09:56, Pankaj Kumar pankaj...@gmail.com wrote: Thanks a ton to Ashish and Vaibav!! I looks good now. You guys are brilliant. :) On Wed, Aug 20, 2014 at 1:59 AM, Ashish Kumar kumar.ashish

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

Welcome Jan. On 19 August 2014 14:24, Jan Knudsen jaf...@gmail.com wrote: Hi , My Name Is Jan Knudsen, from Denmark. I am Hospital Engineer , and use Excel and Acces for Developing small management tools. I am 54 years old. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

Hi Ujjwal, PFA...!!! Regards Ashish On 19 August 2014 15:54, Vaibhav Joshi v...@vabs.in wrote: On which line you are getting error also pls share screen shot with error number.. On Tue, Aug 19, 2014 at 3:40 PM, Ujjwal Desai ujjwal1...@gmail.com wrote: Deleted the lines.

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

Thanks Brother!! On 19 August 2014 16:47, Vaibhav Joshi v...@vabs.in wrote: Great!! On Tue, Aug 19, 2014 at 4:08 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Ujjwal, PFA...!!! Regards Ashish On 19 August 2014 15:54, Vaibhav Joshi v...@vabs.in wrote

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

Welcome!! On 20 August 2014 00:21, Ujjwal Desai ujjwal1...@gmail.com wrote: A Big Thanks guys for helping me out giving your immense help ! Looking for your support in future too. On Aug 19, 2014 4:51 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Thanks Brother!! On 19

Re: $$Excel-Macros$$ I need VBA code to copy the cell value and paste in comment box for the same cell.

Hi Pankaj, PFA .!!! Regards Ashish On 18 August 2014 10:24, Pankaj Kumar pankaj...@gmail.com wrote: I need VBA code to copy the cell value and paste in comment box for the same cell. Example: If I select any cell or merged cells which has some text in it then code should copy

Re: $$Excel-Macros$$ Happy Independence Day!

Dear All Group Members, Happy Independence Day. -- 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$$ Filter on name in all sheet than paste in Master sheet

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

Re: $$Excel-Macros$$ Help for date formula

Hi Srinivas, PFA...!! Regards Ashish On 11 August 2014 15:54, Shrinivas Shevde shrinivas...@gmail.com wrote: I wish to find out difference between two dates in terms of Months. e.g. 10th May 2014 today = 3 months 10th May 1993 today = 255 months 10th jan 1981 today = 403

Re: $$Excel-Macros$$ Please create a macro of this sheet according urgent

and Third workbook create C name that's type Regards, Kapil Gupta On Saturday, August 9, 2014 7:15:46 PM UTC+5:30, Ashish Kumar wrote: Hi Kapil, PFA !!! Regards Ashish On 9 August 2014 17:21, kapil Gupta kgupt2...@gmail.com wrote: Hello, I have attached one

Re: $$Excel-Macros$$ Please create a macro of this sheet according urgent

Hi Kapil, PFA !!! Regards Ashish On 9 August 2014 17:21, kapil Gupta kgupt2...@gmail.com wrote: Hello, I have attached one sheet please create a macro as per unique name required create workbook if the name is duplication but create workbook as per unique name. And if

Re: $$Excel-Macros$$ Hyperlink

Hi Prafull, PFA.!!! Regards Ashish On 5 August 2014 11:44, Prafull Jadhav prafulltjad...@gmail.com wrote: Dear All, Very Good Morning. I have attahced one excel sheet it contain two sheet 1) Index 2) details. I want to hperlink the both sheets. once i click on the index contion

Re: $$Excel-Macros$$ Hyperlink

:40, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Prafull, PFA.!!! Regards Ashish On 5 August 2014 11:44, Prafull Jadhav prafulltjad...@gmail.com wrote: Dear All, Very Good Morning. I have attahced one excel sheet it contain two sheet 1) Index 2) details. I want

Re: $$Excel-Macros$$ Hyperlink

will blink or select which contain the same (MTD- Incident /Request for Service Performanc). I have made it but it is not blinking. Please check my excel file. Regards, Prafull Jadhav 9920553518 On 5 August 2014 15:11, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Prafull, PFA

Re: $$Excel-Macros$$ make 10 digit data

Hi, PFA...!! Regards Ashish On 3 August 2014 21:36, my excel myxlg...@gmail.com wrote: Sir, i have a excel file its contains customer mobile no ex: Jan Feb Mar . etc 919845098450 09888021555 9.19293E+11 919899989696 9.19845E+11 9.19845E+11 09595959595 +919449449460

Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile

this, done minor changes! Cheers!! On Mon, Jul 21, 2014 at 8:22 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Vaibhav Ji, This sheet is Working better than the first one. Tremendous..!!! Regards

Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile

Hi Vaibhav Ji, This sheet is Working better than the first one. Tremendous..!!! Regards Ashish On 21 July 2014 20:03, Vaibhav Joshi v...@vabs.in wrote: Hi Check this, i have added Ok button in First form, only after pressing Ok now form 2 will appear also added check box in front

Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile

Hi Vaibhav, Its Great buddy. Regards Ashish On 19 July 2014 22:02, Vaibhav Joshi v...@vabs.in wrote: Check this.. Cheers!! On Sat, Jul 19, 2014 at 2:32 PM, Vijay vijaymailsi...@gmail.com wrote: Dear Team, Please Help on this to Solve this Problem !!! Regards, Vijayakumar R

Re: $$Excel-Macros$$ Remove Duplicates

Hi Waheed, Welocme. Regards Ashish On 14 July 2014 14:08, Shaik Waheed waheedb...@gmail.com wrote: Its working, Thank you Ashish for your help :) Thanks, Waheed On Fri, Jul 11, 2014 at 9:51 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Waheed, PFA sheet and its code

Re: $$Excel-Macros$$ Remove Duplicates

Hi Waheed, You want to find duplicates in A D column. ?? Regards Ashish On 10 July 2014 18:04, Shaik Waheed waheedb...@gmail.com wrote: Hi Friends, I need your help to remove duplicate names from two columns and produce a single column with unique names and followed by the comparision

Re: $$Excel-Macros$$ Remove Duplicates

Hi Waheed, PFA ...!!! Regards Ashish On 10 July 2014 18:48, Shaik Waheed waheedb...@gmail.com wrote: Yes Ashish Thanks, Waheed On Thu, Jul 10, 2014 at 6:26 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Waheed, You want to find duplicates in A D column. ?? Regards

Re: $$Excel-Macros$$ Remove Duplicates

Hi Waheed, This code is find all duplicates like : Shaik Waheed Khan Shaik Waheed K I think you want to capture only exactly matched values in the data, like : Ashish Kumar Ashish Kumar NOT Ashish Kumar Singh Ashish Kumar S Please Reply. Regards Ashish On 10 July 2014 19:27, Shaik

Re: $$Excel-Macros$$ Disable Row and sheet name

Hi Ashish, For Hide Sheet Names. Click on the File TAB. Click on the Option Button. Go to Advanced category and uncheck the show sheet tabs option for hide the sheet names. Click OK For Hide and show (Row Columns) Select the rows and columns according to your requirement and choose Hide

Re: $$Excel-Macros$$ Re: Look for date/time stamp when any cells in a particular row are modified.

Hi Bill, Press ALT + 11, you will see the VBA Coding for the same and change or modify it according to your requirement. Regards Ashish On 7 July 2014 17:36, Bill Q ronsmith...@gmail.com wrote: Pramod Your latest version is not working at all. No updates occur when cell(s) change.

Re: $$Excel-Macros$$ Re: Look for date/time stamp when any cells in a particular row are modified.

HI Bill, Press ALT + *F11* to see VBA coding. Regards Ashish On 7 July 2014 17:41, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Bill, Press ALT + 11, you will see the VBA Coding for the same and change or modify it according to your requirement. Regards Ashish On 7 July 2014 17

Re: $$Excel-Macros$$ Re: Look for date/time stamp when any cells in a particular row are modified.

Welcome !! On 7 July 2014 22:47, Vaibhav Joshi v...@vabs.in wrote: Great!! Cheers!! On Mon, Jul 7, 2014 at 9:32 PM, Bill Q ronsmith...@gmail.com wrote: Perfect. Thanks for all your help Pramod, Ashish Vabz !! On Sunday, 6 July 2014 13:53:24 UTC-4, Bill Q wrote: Hi, I

<    1   2   3   >