Re: $$Excel-Macros$$ Re: How to prevent from duplication in one work book

hi my dear again i m very thankful to you. but i have the same problem. i m sending u the attachement plz help me out regards, On Thu, Mar 24, 2011 at 2:46 PM, Bhushan Sabbani wrote: > Dear Arya, > > Please find the below attached file. > > Pls let me know any problem in the file. > > > Warm R

$$Excel-Macros$$ Number to Text ?

Hi Friends, how can we convert the numeric value to its text e.g. if i type 1 its text value should be One if i type 132 its text value should be One hundred thirty two.and so on. -- -- Some important links for ex

Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

Ok , I added Microsoft Scripting Runtime in the refrence, its #5 in the Priority list , but the macro is still not picking up sub-directories. thanks again -- -- Some important links for excel users: 1. Follo

Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

How do i add Microsoft scripting run time reference to this file? thnaks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our

Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

I changed the ftdpath as below my production files are on a server so have to put in the address as below, macro runs but does not traverse the sub directories Under the pdf directory below I have directories for years and than months and days. Files are in days folder. ftdpth = \\codebase1

RE: $$Excel-Macros$$ Multi User in Excel file

Dear Dilipji & Thamuji As per your opinion i had done, but when i save the file on that time all data comes. I want when 1st your type 2nd user see that data as chatting wise. Give me tips Awaiting Sajid Memon Date: Fri, 4 Mar 2011 17:19:02 +0530 Subject: Re: $$Excel-Macr

RE: $$Excel-Macros$$ Microsoft Certification

Hi Ayush, If you are going for Microsoft Exam then it's my suggesstion prepare for excel. No need to study 2 hours daily. You can face the exam through online. It's very simple just know about all frontand options. I have Microsoft Certified in MS office. Regards Sajid Memon Date: Fri, 1

Re: $$Excel-Macros$$ Macro to sum across columns and replace columns with calculated result

Outstanding! Thank you so much. On Mar 25, 1:02 pm, ashish koul wrote: > check this > > have create a macro to add quarters  also one to hide the value of > individual quarters so you don need to delete anything > > > > On Fri, Mar 25, 2011 at 7:58 PM, 0 1 wrote: > > I can no longer find where t

Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

is it giving any errors try this code . i haven't tried it on server. always on my local desktop Sub withsubfolder() Dim fldpth As String fldpth = "ftdpth = \\codebase1\docs\pdf\" Dim r As Long ListFilesInFolder fldpth, True End Sub Sub ListFilesInFolder(SourceFolderName As Strin

Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

press alt f11 goto tool -> references-> select Microsoft scripting run time reference On Fri, Mar 25, 2011 at 10:33 PM, Dave wrote: > How do i add Microsoft scripting run time reference to this file? > > thnaks > -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com

Re: $$Excel-Macros$$ Macro to sum across columns and replace columns with calculated result

check this have create a macro to add quarters also one to hide the value of individual quarters so you don need to delete anything On Fri, Mar 25, 2011 at 7:58 PM, 0 1 wrote: > I can no longer find where to attach/upload documents. > > I've linked a sample spreadsheet here though: > http://dl

Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

please add Microsoft scripting run time reference in the workbook also is it working on the local desktop On Fri, Mar 25, 2011 at 10:20 PM, Dave wrote: > I changed the ftdpath as below my production files are on a server so have > to put in the address as below, macro runs but does not traverse

Re: $$Excel-Macros$$ discussexcel : Macro: Column Number to Alphabetical reference

Please try my UDF for the same Public Function ColumnLetter(N As Long) As String ColumnLetter = Replace(Replace(Cells(1, N).Address, "$", ""), 1, "") End Function On Fri, Mar 25, 2011 at 10:40 PM, Ayush wrote: > Hello everyone, > > Here is the UDF to convert a number into Alphabetical refe

Re: $$Excel-Macros$$ discussexcel : Macro: Column Number to Alphabetical reference

The Excel function =Char() converts a number to the equivalent ASCII character. So.. =Char(65) is "A" while =Char(97) is "a" The equivalent VBA function is chr() So, depending on what you're trying to accomplish, you can use an "offset" into this function. That is to say.. if you're trying to p

Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

try the attached macro change fldpth = "D:\my latest data\" this as per ur requirement if you copy the code of( withsubfolder) to other workbook add Microsoft scripting run time reference in that workbook On Fri, Mar 25, 2011 at 6:13 PM, Dave wrote: > Ashish, > > Thanks It works great, can y

$$Excel-Macros$$ discussexcel : Macro: Column Number to Alphabetical reference

Hello everyone, Here is the UDF to convert a number into Alphabetical reference. If you pass 1 to the function, it will Return A. If you pass 26, It will return Z. If you pass 27 It will return AAand so on. http://www.discussexcel.com/learn-macros/vba-macros Let me know if you have better s

Re: $$Excel-Macros$$ Macro to sum across columns and replace columns with calculated result

I can no longer find where to attach/upload documents. I've linked a sample spreadsheet here though: http://dl.dropbox.com/u/6817228/macrotosum.xlsx I also tried to do some of it manually (e.g., AA = B+C, AB = D+E, etc.), hoping I could create the formula once (AA = B+C) and then "drag" it acros

Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

Ashish, Thanks It works great, can you please make one change for me I want the macro to start searching from c:\temp\vba always and traverse sub-directories and not ask the operator any questions. thanks, Dave -- ---

$$Excel-Macros$$ Don't want GETPIVOTDATA formula

Hi Expert, Wanted your help.. while working on Pivot table and using formula with Pivot data by default we are "GETPIVOTDATA" formula and we can use this flexible way. So everytime we need to put manually like "D5" given below and can use as variable. Is there any VBA Code which I can save in

$$Excel-Macros$$ Select numbers date wise using a formula

Hi, How can I select bill numbers of a particular date and show it in ascending order using a formula.Kindly check the attachment . Regards Rajesh Kainikkara -- -- Some important links for excel users: 1. Follow us o

Re: $$Excel-Macros$$ Round the decimal part of the numbers .5 or 1

Hi, Thanks for the formula, sorry for late reply, Regards Rajesh Kainikkara On 3/18/11, STDEV(i) wrote: > =INT(I3)+CHOOSE(MATCH(I3-INT(I3),{0,0.32999,0.82999},1),0,0.5,1) > > or > =IF(ROUND(MOD(I3,1),2)>=0.83,ROUNDUP(I3,0),IF(ROUND(MOD(I3,1),2)>=0.33,TRUNC(I3)+0.5,TRUNC(I3))) > > and more.. > >

Re: $$Excel-Macros$$ Can I find the source of a pivotchart using VBA?

Very many thanks Ashish. That does the job nicely. Regards John On Mar 24, 6:29 am, ashish koul wrote: > Try this see if it helps > > Sub checksource() > Dim x As PivotTable > Dim s As Charts > > Dim y As ChartObject > Dim ws As Worksheet > For Each ws In ThisWorkbook.Sheets > > For Each y In ws

Re: $$Excel-Macros$$ Is there any carrer in excel.

Dear Anand, Thanks for the valuable advice. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldai

$$Excel-Macros$$ How to prevent from duplication in one work book

Hi Akbar, Have a look at the attached. Type "Akbar" anywhere on sheet 1 To do the vice-versa thing, enter similar code into the VBA Sheet 3 window. Regards - Dave. Date: Thu, 24 Mar 2011 11:36:15 +0500 Subject: $$Excel-Macros$$ How to prevent from duplication in one work book From: sh.talal.ak

Re: $$Excel-Macros$$ NEED HELP

Hi Daniel, Thank you so much for helping me out with this. Appreciate ur help bro Thanks n Regards Anupam On Fri, Mar 25, 2011 at 1:55 AM, Daniel wrote: > Hi, > > Have a look at the attached file. > > Regards. > > Daniel > > > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@

Re: $$Excel-Macros$$ Re: How to prevent from duplication in one work book

Dear Arya, How I had apply the conditional formatting for the one column you can apply to all the column where you needed.. Pls attached the sample file so i can get the brief knowledge of your data. Pls let me know i did solve the problem or not,. Warm Regards Bhushan Sabbani +91 98208 26012

Re: $$Excel-Macros$$ Is there any carrer in excel.

Thanks. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ ht