$$Excel-Macros$$ Require formula to find the count targeted till date

today date as 7/30/2015 for subarea (APA in cell b3) the planned conditions till date is 38 (i.e. D2+E2+F2+G2) I would like to have the this data automatically reflected in C2 cell. Can any one help me with a formula macros for the same Regards Raghu -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

$$Excel-Macros$$ Thought you'd find this interesting

Hi! I’ve just learned about the water crisis and thought you would be interested to check out this story: https://waterforward.charitywater.org/et/qgN1rodl Thanks, raghu -- Sent via WaterForward, an initiative of charity: water WaterForward, 387 Tehama Street, San Francisco, CA 94103

$$Excel-Macros$$ back up - vba code

Hi, I want to take backup of excel files periodically from some "specified path" and to "specified path", is there vba code for same. Thank you with regards Raghu -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor

Re: $$Excel-Macros$$ How to export data from Excel to Tally

hi, pls explain the procedure with regards Raghu On Fri, May 18, 2012 at 6:52 PM, sridher sharma wrote: > how? > > > On 18 May 2012 18:32, Jai wrote: > >> if you use Tally 9 Then you have import the excel file in tally >> >> >> On Fri,

$$Excel-Macros$$ How to export data from Excel to Tally

Sir, I have lot of data in excel how to export it to Tally ERP 9, please give suggestions sir. Thanks Raghu -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code

$$Excel-Macros$$ inventory in excel

hi, how to maintain inventory in excel. if any one have samples pls let me know Thank you with regards Raghu -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

hi, Congrats sir, you are being very helpful to each and every one in this group i would also than Mr. Don and xlstime they are also equally helpful. keep it up sir. with regards raghu On Thu, Mar 15, 2012 at 11:53 AM, SAGAR KASANGOTTUWAR < sagarkasangottu...@gmail.com>

$$Excel-Macros$$ how to save file in 2 different locations

hi, I want save same excel file in two locations (different folders) if ctrl+s is pressed, so that there will be no need to take data backup. how to do it sir with regards raghu -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread

Re: $$Excel-Macros$$ inventory sheet

sir, Thank you, its good one. with regards raghu On Sun, Feb 26, 2012 at 12:56 AM, Maries wrote: > Hi, > > Check this link, > > http://www.webandmacros.com/macro_excel_gestion_stocks.htm > > Regards, > > MARIES. > On Sat, Feb 25, 2012 at 7:27 PM, xlstime wro

Re: $$Excel-Macros$$ how to find a text in a folder

hi, In folder "xyz" in "abc.xls" i typed 123456, then in agent ransack in "containing search" i typed 123456, but it is not seaching the file abc.xls thanks a lot sir with regards raghu On Sat, Feb 25, 2012 at 11:29 PM, xlstime wrote: > Hi raghu, > > c

Re: $$Excel-Macros$$ how to find a text in a folder

hi, i am using excel 2003 and number is stored in text only sir thank you On Sat, Feb 25, 2012 at 9:04 PM, xlstime wrote: > which version you are using ? > > > On Sat, Feb 25, 2012 at 7:00 PM, raghu gr wrote: > >> Hi xlstime, >> its working for text only, but fo

$$Excel-Macros$$ inventory sheet

Hi, How to maintain inventory in excel sheet, is there any excel sheet / template / macro. with regards raghu -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code

Re: $$Excel-Macros$$ how to find a text in a folder

Hi xlstime, its working for text only, but for numbers it is not working pls help. with regards raghu On Wed, Feb 22, 2012 at 9:02 PM, xlstime wrote: > please use same software for any data type.. > > > On Wed, Feb 22, 2012 at 12:21 AM, raghu gr wrote: > >> hi, >>

Re: $$Excel-Macros$$ how to find a text in a folder

hi, This is working fine for searching text, how to search for numbers sir, means example if i want search a invoce number 2000127845 in a folder in which there are 50 files. Thank you with regards raghu On Mon, Feb 20, 2012 at 11:47 PM, raghu gr wrote: > > hi, > > Thanks this

Re: $$Excel-Macros$$ how to find a text in a folder

hi, Thanks this is very good. thank you with regards raghu On Mon, Feb 20, 2012 at 3:11 PM, xlstime wrote: > Hi Raghu, > > > you can use "*Agent Ransack *" searching software > > http://mythicsoft.com/page.aspx?type=agentransack&page=home > > On Sun, Fe

Re: $$Excel-Macros$$ how to find a text in a folder

Sir, Sir some error in line, Set a = wk.Cells.Find(What:="*" & ThisWorkbook.Sheets("File Names").Range("c2").Value & "*", After:=wk.Cells(1, 1), _ LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, _ SearchDirection:=xlNext, MatchCase:=

Re: $$Excel-Macros$$ how to find a text in a folder

_ SearchDirection:=xlNext, MatchCase:=False) pls help me. Thank you with regards raghu On Sat, Feb 18, 2012 at 11:29 PM, NOORAIN ANSARI wrote: > Dear Raghu, > > Plwase try it.. > > Dim j As Long > Dim fldpath > Dim fld, fil, subfld As Object > Sub search_workbooks()

$$Excel-Macros$$ how to find a text in a folder

hi all, how to find a text in folder. Example - suppose in 1 folder there are 40 excel files, if i want find a text "apple" is in which file (as it becomes tedious to open each and every file and use ctrl +F option). with regards raghu -- FORUM RULES (986+ members already

Re: $$Excel-Macros$$ alert for duplicate name or number while entering the data in the sheet

hi, its limiting the entry also. with regards raghu On Sat, Feb 11, 2012 at 5:50 PM, Bé Trần Văn wrote: > ** > > 2012/2/10 rajeyssh aggarwaal > >> Hello Sir, >> Is it possible while we entering the date in the sheet system alert us >> that the name or number or

Re: $$Excel-Macros$$ formula in rate column

Thank you sir, its working with regards raghu On Mon, Feb 6, 2012 at 8:20 PM, The Viper wrote: > check the attachment and go to rate sheet > > > On Sun, Feb 5, 2012 at 2:13 PM, raghu gr wrote: > >> hi, >> >> Thanks a lot sir, >> >> For the same

$$Excel-Macros$$ formula in rate column

Hi experts, I have a invoice file and summary file, i want the formula in rate column, which has to pick from rate sheet. please help me in this regard Attached sample file Thank you with regards Raghu -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate

Re: $$Excel-Macros$$ excell to pdf

hi, its not working to me also, error in line fixed width is comming with regards raghu On Tue, Jan 31, 2012 at 7:13 PM, KAUSHIK SAVLA wrote: > Hi Chandra, > > It is not working in my system > Cold you please what you did to get it worked properly? > > Regards, > Kaushik

Re: $$Excel-Macros$$ Import data

hi noorain, I mean how Mr.Selva wrote or record the macro to import data set from two files and consolidate the data into a master file. thank you raghu On Thu, Jan 26, 2012 at 7:40 PM, NOORAIN ANSARI wrote: > Dear Raghu, > > Please use attached sheet vba code as per your re

Re: $$Excel-Macros$$ Import data

hi, how will u run macro, please elobarate with regards Raghu On Wed, Jan 25, 2012 at 10:53 AM, LearnExcel wrote: > Hi team, i wanted to import data set from two files and consolidate > the data into a master file. > > I need something in VBA, currently i run a marco that goes th

Re: $$Excel-Macros$$ Converting pdf to excel?

hi, thanks but its showing error in line Dim appAA As Acrobat.CAcroApp "user defined type not defined" alert is comming whn this program is run with regards raghu On Sun, Jan 22, 2012 at 9:52 PM, NOORAIN ANSARI wrote: > Dear Kaushik, > > Please use below code, hope