$$Excel-Macros$$ Regarding paste options

Dear All, I have a range. In that range when i select some range of numbers from other sheets and paste it in then present range or cell by right click or by just pressing cltr+V , then it should directly paste it as values. Is there any idea -- Thanks Regards, Gawli Anil Narayan

Re: $$Excel-Macros$$ Pivot Table Running Balance - Grand Total

Dear Nath, Pl find the attached herewith. Warm Regards, Gawli Anil On Wed, Aug 14, 2013 at 3:09 PM, Gopinath nath@gmail.com wrote: Dear Shri Satendra Kumar, Thank you for your suggestion. However, what I wanted is Running Balance for each Bank - Datewise as well as Grand Total Balance

Re: $$Excel-Macros$$ Folder Query (urgrnt)

Dear Shrinivas, Pl see that u have filter the ext with the following one. .Filters.Add Excel, *.xls; *.xlsx; *.xlsm; *.xlsb, 1 Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Mon, Aug 19, 2013 at 2:24 PM, Shrinivas

Re: $$Excel-Macros$$ Changing txtbox backcolor when linked cell value changes...

Dear Ashkan, on textbox enter event write a code Me.txtshiptoparty.BackColor = vbGreen after on textbox exit event write again the same code with different color. Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Tue, Aug 20,

Re: $$Excel-Macros$$ Don't see 'View Code' option when I right-click on the sheet tab

Dear Chaya, Pl share a sample sheet with us. Warm Regards, Gawli Anil. Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Tue, Aug 20, 2013 at 6:00 AM, Chaya Cooper chayacoo...@gmail.com wrote: A tutorial I'm using (to create a multi-select box)

Re: $$Excel-Macros$$ Sum between two different data.

Dear Manok, Find attached herewith . Warm Regards, Gawli Anil. Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Wed, Aug 21, 2013 at 2:30 PM, Manoj Kumar manoj.11...@gmail.com wrote: Please help me. I have a data like details mention below. xxx

Re: $$Excel-Macros$$ How to split Data based on last comm,

Dear Rajkumar, U can use text to columns option . click on comma checkbox and finish it. Warm Regads, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Wed, Aug 21, 2013 at 2:42 PM, Andrew Mangozho andrew.mango...@gmail.com wrote: Another

Re: $$Excel-Macros$$ I need to delete entire rows which contain exact matches from a static list on a seperate sheet

Dear svenyarl, Pls share a worksheet with us. Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Wed, Aug 21, 2013 at 8:13 PM, sveny...@gmail.com wrote: I sample of the file I receive is as follows: 25727861 GM DLT 1

Re: $$Excel-Macros$$ Which cell color and font color combination is suitable to show negative value.

Dear Waseem, Mostly font color should be black and cell color should be red for negative. positive:- font color should be black and cell color should be gree. Warm Regards, Gawli Anil. Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Thu, Aug 22,

Re: $$Excel-Macros$$ counting of a particular denomination

Dear Kushlesh, You can u with countifs(criteriarange,criteria) and enter Pl find the attached sheet Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Fri, Aug 30, 2013 at 12:04 PM, Kush Shama kushleshsha...@gmail.com wrote:

Re: $$Excel-Macros$$ Getting Array out of Bound Error

Dear Saggi, Pl share the file with us. Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Mon, Sep 2, 2013 at 11:04 AM, shyam.utha...@gmail.com shyam.utha...@gmail.com wrote: Sent from my HTC - Reply message -

Re: $$Excel-Macros$$ copy data paste into new worksheet or book save into folder

Dear Prajakt Pande, Has it has lots of rows init. It will take nearly 5 min, so have patients. Warm Regards, Gawli Anil. Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Tue, Sep 3, 2013 at 10:07 AM, अनिल नारायण गवली gawlianil8...@gmail.com wrote

Re: $$Excel-Macros$$ am getting compile error

Dear Prabhu, Use this code Sub sample() Sheets(sheet2).Range(A10).Value = 1000 Sheets(sheet2).Activate Sheets(sheet2).Range(A10).Select MsgBox Task Completed If MsgBox(Do you want to Clear the data ?, vbYesNo, Confirm) = vbYes Then Range(A:A).ClearContents MsgBox Data has been cleared Else

Re: $$Excel-Macros$$ am getting compile error

Dear Prabhu, In place of Sheet2 write Sheets(2).range(A10).value=1000 Warm Regards, Gawli Anil. Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Wed, Sep 11, 2013 at 11:44 AM, De Premor d...@premor.net wrote: Give more attention here !

Re: $$Excel-Macros$$ Filter Data of Bold letter

Dear Ashish, Pl share the workbook with us. Warm Regards, Gawli Anil. Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Wed, Sep 11, 2013 at 1:20 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, I have a data columnar and want

Re: $$Excel-Macros$$ Filter Data of Bold letter

Dear Ashish, Pl see the attached workbook. Is it ok? Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Wed, Sep 11, 2013 at 2:11 PM, अनिल नारायण गवली gawlianil8...@gmail.com wrote: Dear Ashish, Pl share the workbook

Re: $$Excel-Macros$$ Query on vlookup

Dear Shrinivas, u can also use =VLOOKUP(F3,A3:E13,COLUMNS(A3:E3),0) Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Sat, Sep 14, 2013 at 11:07 AM, Shrinivas Shevde shrinivas...@gmail.com wrote: Dear Ashish,De Premor,Ravi

Re: $$Excel-Macros$$ Need Formula

Dear Prabhu, Pl see the attached sheet. Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Tue, Sep 17, 2013 at 10:22 AM, Prabhu Pinky prabhupin...@gmail.com wrote: Hi Experts, Please find the attached file, please revert

Re: $$Excel-Macros$$ Set range and action according to sheet name

Dear Melimob, Pl share a workbook with us. Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Wed, Sep 18, 2013 at 12:29 AM, Melimob melissasobrien...@gmail.com wrote: Hi all I am new to this group so I hope someone can

Re: $$Excel-Macros$$ Need experts help ***URGENT***

Dear Indrajit Workbooks.Open fil,,false Try using above code . Pl reply Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Thu, Sep 19, 2013 at 4:33 AM, Indrajit $nai talk2indra...@gmail.com wrote: Hi Experts, I am facing

Re: $$Excel-Macros$$ Total Count of Unique ID's

Dear Ashish, See d attached workbook. Wam Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Mon, Sep 23, 2013 at 11:48 AM, Ashish Kumar kumar.ashish...@gmail.com wrote: Dear Seniors, I want total count of unique User ID's.

$$Excel-Macros$$ Required the file like the output file.

Dear Friends, As i had attached two files one is the source file named Attendance workbook and another is output . in attendance file there are no. of sheets which contain all the attendance data. I want that data should convert as output file as attached with the name output file. Note : In

Re: $$Excel-Macros$$ Need experts help ***URGENT***

Dear Indrajit, Kindly send it across the Slave files also so that we can test it from out side. Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Tue, Sep 24, 2013 at 3:48 AM, Indrajit $nai talk2indra...@gmail.com wrote: Hi

Re: $$Excel-Macros$$ Re: Required the file like the output file.

Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Tue, Sep 24, 2013 at 10:01 AM, अनिल नारायण गवली gawlianil8...@gmail.com wrote: Dear Friends, As i had attached two files one is the source file named Attendance workbook and another is output

Re: $$Excel-Macros$$ Re: Required the file like the output file.

Dear Deepak , But here the outtime is missing Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Tue, Sep 24, 2013 at 1:33 PM, Deepak Singh dpk85si...@gmail.com wrote: Try this code.. Sub test() Application.ScreenUpdating =

Re: $$Excel-Macros$$ Re: Required the file like the output file.

Dear Deepak , See the Output file outitme is mentioned in the same field of Time field. Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Tue, Sep 24, 2013 at 2:26 PM, Deepak Singh dpk85si...@gmail.com wrote: Hi Anil, You

$$Excel-Macros$$ Pls convert time to given format

Dear Friends, i have to convert the time to given format . format is as follows. Time Output 08:590859 17:001700 15:30 1530 17:05 so on. 13:12 00:00 08:57 17:15 08:55 17:10 Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Are

Re: $$Excel-Macros$$ Pls convert time to given format

this formula =TEXT(A12,hhmm) On Wed, Sep 25, 2013 at 12:13 PM, अनिल नारायण गवली gawlianil8...@gmail.com wrote: Dear Friends, i have to convert the time to given format . format is as follows. Time Output 08:590859 17:001700 15:30 1530 17:05 so on. 13:12 00:00 08:57

Re: $$Excel-Macros$$ Facing 'run-time error -2147217871 (80040e31) Automation error' in excel VBA

Dear Junaid, Kindly attach the error file . Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Wed, Sep 25, 2013 at 12:26 PM, Junaid junaid.an...@gmail.com wrote: Hi guys, I am working on Excel 2007 macros. My requirement is

$$Excel-Macros$$ Small doubt in customize ribbon of user define function.

Dear Friends, I had made a macro, then created a new customized ribbon and assigned it with this macro. Problem is whenever i click on the ribbon to run the task then the original file where the macro is created is opening simulteneously. My idea is it should not open the file and only run the

Re: $$Excel-Macros$$ Small doubt in customize ribbon of user define function.

Dear Friends, Sorry for distrubing you . The solution has been resloved now. Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Thu, Sep 26, 2013 at 12:29 PM, अनिल नारायण गवली gawlianil8...@gmail.com wrote: Dear Friends, I

Re: $$Excel-Macros$$ Consolidate to one working sheet

Dear Harisha, The files which u have sent is in different format. kindly send proper format. Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Wed, Oct 9, 2013 at 2:54 PM, Hari harisha.prabha...@gmail.com wrote: Dear Excel

Re: $$Excel-Macros$$

Dear Raj Kumar, Pls find attached herewith. Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Fri, Oct 11, 2013 at 3:48 PM, Raj Kumar rajlu...@gmail.com wrote: Hi Guru, We have to calculate based on id of Raj Mohan through

<    1   2   3